21 Revision ID: 23530d604b96
23 Create Date: 2015-03-18 17:41:58.055412
28 revision =
'23530d604b96'
29 down_revision =
'45e3f47c6c44'
31 from alembic
import op
32 import sqlalchemy
as sa
33 from sqlalchemy.dialects.postgresql
import ENUM
35 YESNO_NAME =
'yesno_values'
36 YESNO_VALUES = [
'yes',
'no']
43 yesno_values = ENUM(*YESNO_VALUES, name=YESNO_NAME, create_type=
False)
45 op.add_column(
'ps_endpoints', sa.Column(
'rpid_immediate', yesno_values))
48 if op.get_context().bind.dialect.name ==
'mssql':
49 op.drop_constraint(
'ck_ps_endpoints_rpid_immediate_yesno_values',
'ps_endpoints')
50 op.drop_column(
'ps_endpoints',
'rpid_immediate')