3 Revision ID: 1d0e332c32af
5 Create Date: 2017-04-25 12:50:09.412662
10 revision =
'1d0e332c32af'
11 down_revision =
'2da192dbbc65'
13 from alembic
import op
14 import sqlalchemy
as sa
15 from sqlalchemy.dialects.postgresql
import ENUM
17 YESNO_NAME =
'yesno_values'
18 YESNO_VALUES = [
'yes',
'no']
25 yesno_values = ENUM(*YESNO_VALUES, name=YESNO_NAME, create_type=
False)
29 sa.Column(
'id', sa.String(40), nullable=
False, unique=
True),
30 sa.Column(
'list_item', sa.String(2048)),
31 sa.Column(
'event', sa.String(40)),
32 sa.Column(
'full_state', yesno_values),
33 sa.Column(
'notification_batch_interval', sa.Integer),
36 op.create_index(
'ps_resource_list_id',
'ps_resource_list', [
'id'])
39 op.drop_table(
'ps_resource_list')