diff options
Diffstat (limited to 'contrib/ast-db-manage/config/versions/e96a0b8071c_increase_pjsip_column_size.py')
-rw-r--r-- | contrib/ast-db-manage/config/versions/e96a0b8071c_increase_pjsip_column_size.py | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/contrib/ast-db-manage/config/versions/e96a0b8071c_increase_pjsip_column_size.py b/contrib/ast-db-manage/config/versions/e96a0b8071c_increase_pjsip_column_size.py index 9c00c012e..da103b1f0 100644 --- a/contrib/ast-db-manage/config/versions/e96a0b8071c_increase_pjsip_column_size.py +++ b/contrib/ast-db-manage/config/versions/e96a0b8071c_increase_pjsip_column_size.py @@ -28,7 +28,13 @@ def upgrade(): def downgrade(): op.alter_column('ps_globals', 'user_agent', type_=sa.String(40)) - op.alter_column('ps_contacts', 'id', type_=sa.String(40)) + if op.get_context().bind.dialect.name != 'mssql': + op.alter_column('ps_contacts', 'id', type_=sa.String(40)) + else: + op.drop_constraint('uq_ps_contacts_id', 'ps_contacts') + op.drop_index('ps_contacts_id', 'ps_contacts') + op.alter_column('ps_contacts', 'id', type_=sa.String(40)) + op.create_index('ps_contacts_id', 'ps_contacts', ['id']) op.alter_column('ps_contacts', 'uri', type_=sa.String(40)) op.alter_column('ps_contacts', 'user_agent', type_=sa.String(40)) |