diff options
| author | Mark Michelson <mmichelson@digium.com> | 2016-06-20 13:21:52 -0500 |
|---|---|---|
| committer | Mark Michelson <mmichelson@digium.com> | 2016-06-22 12:23:44 -0500 |
| commit | b6bd97eea2ddeba2b0ea2380da29fba98b8a3208 (patch) | |
| tree | afc7f87a63ce0e80385356fd381d6d945b29fcde /contrib/ast-db-manage | |
| parent | 11caa10cf5abae8abef91a887c30e81e8d38486a (diff) | |
Fix Alembic upgrades.
A non-existent constraint was being referenced in the upgrade script.
This patch corrects the problem by removing the reference.
In addition, the head of the alembic branch referred to a non-existent
revision. This has been fixed by referring to the proper revision.
This patch fixes another realtime problem as well. Our Alembic scripts
store booleans as yes or no values. However, Sorcery tries to insert
"true" or "false" instead. This patch introduces a new boolean type that
translates to "yes" or "no" instead.
ASTERISK-26128 #close
Change-Id: I51574736a881189de695a824883a18d66a52dcef
Diffstat (limited to 'contrib/ast-db-manage')
| -rw-r--r-- | contrib/ast-db-manage/config/versions/6d8c104e6184_res_pjsip_add_contact_via_addr_and_.py | 2 | ||||
| -rw-r--r-- | contrib/ast-db-manage/config/versions/81b01a191a46_pjsip_add_contact_reg_server.py | 2 |
2 files changed, 1 insertions, 3 deletions
diff --git a/contrib/ast-db-manage/config/versions/6d8c104e6184_res_pjsip_add_contact_via_addr_and_.py b/contrib/ast-db-manage/config/versions/6d8c104e6184_res_pjsip_add_contact_via_addr_and_.py index 893d9d82e..77242ac4b 100644 --- a/contrib/ast-db-manage/config/versions/6d8c104e6184_res_pjsip_add_contact_via_addr_and_.py +++ b/contrib/ast-db-manage/config/versions/6d8c104e6184_res_pjsip_add_contact_via_addr_and_.py @@ -8,7 +8,7 @@ Create Date: 2016-05-19 15:51:33.410852 # revision identifiers, used by Alembic. revision = 'a845e4d8ade8' -down_revision = 'bca7113d796f' +down_revision = 'd7e3c73eb2bf' from alembic import op import sqlalchemy as sa diff --git a/contrib/ast-db-manage/config/versions/81b01a191a46_pjsip_add_contact_reg_server.py b/contrib/ast-db-manage/config/versions/81b01a191a46_pjsip_add_contact_reg_server.py index 0318b9a4f..0919370ba 100644 --- a/contrib/ast-db-manage/config/versions/81b01a191a46_pjsip_add_contact_reg_server.py +++ b/contrib/ast-db-manage/config/versions/81b01a191a46_pjsip_add_contact_reg_server.py @@ -16,10 +16,8 @@ import sqlalchemy as sa def upgrade(): op.add_column('ps_contacts', sa.Column('reg_server', sa.String(20))) - op.drop_constraint('id', 'ps_contacts', type_='unique') op.create_unique_constraint('ps_contacts_uq', 'ps_contacts', ['id','reg_server']) def downgrade(): op.drop_constraint('ps_contacts_uq', 'ps_contacts', type_='unique') op.drop_column('ps_contacts', 'reg_server') - op.create_unique_constraint(None, 'ps_contacts', 'id') |