pjsip: Added "reg_server" to contacts.
[asterisk/asterisk.git] / contrib / ast-db-manage / config / versions / 81b01a191a46_pjsip_add_contact_reg_server.py
1 """pjsip: add contact reg_server
2
3 Revision ID: 81b01a191a46
4 Revises: 65eb22eb195
5 Create Date: 2016-04-15 15:00:35.024525
6
7 """
8
9 # revision identifiers, used by Alembic.
10 revision = '81b01a191a46'
11 down_revision = '65eb22eb195'
12
13 from alembic import op
14 import sqlalchemy as sa
15
16
17 def upgrade():
18     op.add_column('ps_contacts', sa.Column('reg_server', sa.String(20)))
19     op.drop_constraint(UniqueConstraint('id'), 'ps_contacts', type_='unique')
20     op.create_unique_constraint('ps_contacts_uq', 'ps_contacts', ['id','reg_server'])
21
22 def downgrade():
23     op.drop_constraint('ps_contacts_uq', 'ps_contacts', type_='unique')
24     op.drop_column('reg_server')
25     op.create_unique_constraint(None, 'ps_contacts', 'id')