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/2fc7930b41b3_add_pjsip_endpoint_options_for_12_1.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/2fc7930b41b3_add_pjsip_endpoint_options_for_12_1.py')
| -rw-r--r-- | contrib/ast-db-manage/config/versions/2fc7930b41b3_add_pjsip_endpoint_options_for_12_1.py | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/contrib/ast-db-manage/config/versions/2fc7930b41b3_add_pjsip_endpoint_options_for_12_1.py b/contrib/ast-db-manage/config/versions/2fc7930b41b3_add_pjsip_endpoint_options_for_12_1.py index d39ddb41a..3ca16feaf 100644 --- a/contrib/ast-db-manage/config/versions/2fc7930b41b3_add_pjsip_endpoint_options_for_12_1.py +++ b/contrib/ast-db-manage/config/versions/2fc7930b41b3_add_pjsip_endpoint_options_for_12_1.py @@ -142,6 +142,8 @@ def upgrade(): def downgrade(): ########################## drop columns ########################## + if op.get_context().bind.dialect.name == 'mssql': + op.drop_constraint('ck_ps_aors_support_path_yesno_values', 'ps_aors') op.drop_column('ps_aors', 'support_path') op.drop_column('ps_aors', 'outbound_proxy') op.drop_column('ps_aors', 'maximum_expiration') @@ -153,6 +155,8 @@ def downgrade(): new_column_name='mwi_fromuser', existing_type=sa.String(40)) op.drop_column('ps_endpoints', 'set_var') + if op.get_context().bind.dialect.name == 'mssql': + op.drop_constraint('ck_ps_endpoints_redirect_method_pjsip_redirect_method_values', 'ps_endpoints') op.drop_column('ps_endpoints', 'redirect_method') op.drop_column('ps_endpoints', 'media_address') |