diff options
author | Alexei Gradinari <alex2grad@gmail.com> | 2016-04-15 15:26:15 -0400 |
---|---|---|
committer | Joshua Colp <jcolp@digium.com> | 2016-05-02 10:01:40 -0300 |
commit | 2b1edee772ae3690d060bd067b489cbbb72b24f5 (patch) | |
tree | 76e6da16c355d891ac09ff29a1feb604360bb15a /contrib/ast-db-manage/config/versions | |
parent | adf32d11918fea837d1e12c526876b78ba4f6cb0 (diff) |
pjsip: Added "reg_server" to contacts.
If the Asterisk system name is set in asterisk.conf, it will be stored
into the "reg_server" field in the ps_contacts table to facilitate
multi-server setups.
ASTERISK-25931
Change-Id: Ia8f6bd2267809c78753b52bcf21835b9b59f4cb8
Diffstat (limited to 'contrib/ast-db-manage/config/versions')
-rw-r--r-- | contrib/ast-db-manage/config/versions/81b01a191a46_pjsip_add_contact_reg_server.py | 25 |
1 files changed, 25 insertions, 0 deletions
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 new file mode 100644 index 000000000..8bd151bd7 --- /dev/null +++ b/contrib/ast-db-manage/config/versions/81b01a191a46_pjsip_add_contact_reg_server.py @@ -0,0 +1,25 @@ +"""pjsip: add contact reg_server + +Revision ID: 81b01a191a46 +Revises: 65eb22eb195 +Create Date: 2016-04-15 15:00:35.024525 + +""" + +# revision identifiers, used by Alembic. +revision = '81b01a191a46' +down_revision = '65eb22eb195' + +from alembic import op +import sqlalchemy as sa + + +def upgrade(): + op.add_column('ps_contacts', sa.Column('reg_server', sa.String(20))) + op.drop_constraint(UniqueConstraint('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('reg_server') + op.create_unique_constraint(None, 'ps_contacts', 'id') |