1 """add further dtls options
3 Revision ID: 51f8cb66540e
5 Create Date: 2014-06-30 07:16:12.291684
10 revision =
'51f8cb66540e'
11 down_revision =
'c6d929b23a8'
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)
27 op.add_column(
'ps_endpoints', sa.Column(
'force_avp', yesno_values))
28 op.add_column(
'ps_endpoints', sa.Column(
'media_use_received_transport', yesno_values))
31 if op.get_context().bind.dialect.name ==
'mssql':
32 op.drop_constraint(
'ck_ps_endpoints_force_avp_yesno_values',
'ps_endpoints')
33 op.drop_constraint(
'ck_ps_endpoints_media_use_received_transport_yesno_values',
'ps_endpoints')
34 op.drop_column(
'ps_endpoints',
'force_avp')
35 op.drop_column(
'ps_endpoints',
'media_use_received_transport')