summaryrefslogtreecommitdiff
path: root/contrib/ast-db-manage/config/versions/f638dbe2eb23_symmetric_transport.py
diff options
context:
space:
mode:
authorFlorian Floimair <f.floimair@commend.com>2017-09-05 18:13:19 +0200
committerKevin Harwell <kharwell@digium.com>2017-09-08 11:48:00 -0500
commitad606844bec37c3c782580ff807e2d2f2d23feb2 (patch)
treeabdc5bb99ddffbb8a2ed0733cdbb8eb12fda9a25 /contrib/ast-db-manage/config/versions/f638dbe2eb23_symmetric_transport.py
parent9a366d24242a0fc1e7d04b8859ac5773193aa932 (diff)
alembic: Add support for MS-SQL
MS-SQL has no native Enum-type support and therefore needs to work with constraints. Since these constraints need unique names the suggested approach referenced in the following alembic documentation has been applied: http://bit.ly/2x9r8pb ASTERISK-27255 #close Change-Id: I4a399ba3eed41a33ce8cb294968ad340221580ee
Diffstat (limited to 'contrib/ast-db-manage/config/versions/f638dbe2eb23_symmetric_transport.py')
-rw-r--r--contrib/ast-db-manage/config/versions/f638dbe2eb23_symmetric_transport.py2
1 files changed, 2 insertions, 0 deletions
diff --git a/contrib/ast-db-manage/config/versions/f638dbe2eb23_symmetric_transport.py b/contrib/ast-db-manage/config/versions/f638dbe2eb23_symmetric_transport.py
index 51b5066f5..0585aa52d 100644
--- a/contrib/ast-db-manage/config/versions/f638dbe2eb23_symmetric_transport.py
+++ b/contrib/ast-db-manage/config/versions/f638dbe2eb23_symmetric_transport.py
@@ -29,4 +29,6 @@ def upgrade():
def downgrade():
op.drop_column('ps_subscription_persistence', 'contact_uri')
+ if op.get_context().bind.dialect.name == 'mssql':
+ op.drop_constraint('ck_ps_transports_symmetric_transport_yesno_values','ps_transports')
op.drop_column('ps_transports', 'symmetric_transport')