diff options
author | Florian Floimair <f.floimair@commend.com> | 2017-09-05 18:13:19 +0200 |
---|---|---|
committer | Kevin Harwell <kharwell@digium.com> | 2017-09-08 11:51:20 -0500 |
commit | e9a81157ac0e97c6c64f5edac66359957d24beff (patch) | |
tree | 2e5b5b77630c25469d35dd469ebcab7cd30d0051 /contrib/ast-db-manage/config/versions/837aa67461fb_ps_contacts_add_authenticate_qualify.py | |
parent | 2857a3334aa430b81baac31bdfe0efb3871f37d4 (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/837aa67461fb_ps_contacts_add_authenticate_qualify.py')
-rw-r--r-- | contrib/ast-db-manage/config/versions/837aa67461fb_ps_contacts_add_authenticate_qualify.py | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/contrib/ast-db-manage/config/versions/837aa67461fb_ps_contacts_add_authenticate_qualify.py b/contrib/ast-db-manage/config/versions/837aa67461fb_ps_contacts_add_authenticate_qualify.py index 76faf394c..033a999af 100644 --- a/contrib/ast-db-manage/config/versions/837aa67461fb_ps_contacts_add_authenticate_qualify.py +++ b/contrib/ast-db-manage/config/versions/837aa67461fb_ps_contacts_add_authenticate_qualify.py @@ -28,5 +28,7 @@ def upgrade(): def downgrade(): + if op.get_context().bind.dialect.name == 'mssql': + op.drop_constraint('ck_ps_contacts_authenticate_qualify_yesno_values','ps_contacts') op.drop_column('ps_contacts', 'authenticate_qualify') |