summaryrefslogtreecommitdiff
path: root/contrib/ast-db-manage/config/versions/28ab27a7826d_add_srv_lookups_to_identify.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:51:20 -0500
commite9a81157ac0e97c6c64f5edac66359957d24beff (patch)
tree2e5b5b77630c25469d35dd469ebcab7cd30d0051 /contrib/ast-db-manage/config/versions/28ab27a7826d_add_srv_lookups_to_identify.py
parent2857a3334aa430b81baac31bdfe0efb3871f37d4 (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: I8b579750dae0c549f1103ee50172644afb9b2f95
Diffstat (limited to 'contrib/ast-db-manage/config/versions/28ab27a7826d_add_srv_lookups_to_identify.py')
-rw-r--r--contrib/ast-db-manage/config/versions/28ab27a7826d_add_srv_lookups_to_identify.py2
1 files changed, 2 insertions, 0 deletions
diff --git a/contrib/ast-db-manage/config/versions/28ab27a7826d_add_srv_lookups_to_identify.py b/contrib/ast-db-manage/config/versions/28ab27a7826d_add_srv_lookups_to_identify.py
index 8831e2002..9325da3eb 100644
--- a/contrib/ast-db-manage/config/versions/28ab27a7826d_add_srv_lookups_to_identify.py
+++ b/contrib/ast-db-manage/config/versions/28ab27a7826d_add_srv_lookups_to_identify.py
@@ -28,4 +28,6 @@ def upgrade():
def downgrade():
+ if op.get_context().bind.dialect.name == 'mssql':
+ op.drop_constraint('ck_ps_endpoint_id_ips_srv_lookups_yesno_values','ps_endpoint_id_ips')
op.drop_column('ps_endpoint_id_ips', 'srv_lookups')