summaryrefslogtreecommitdiff
path: root/contrib/ast-db-manage/config/versions/6d8c104e6184_res_pjsip_add_contact_via_addr_and_.py
blob: 893d9d82e7ae7717de22c8c53a6d12bf26c6a673 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
"""res_pjsip: add contact via_addr and callid

Revision ID: a845e4d8ade8
Revises: bca7113d796f
Create Date: 2016-05-19 15:51:33.410852

"""

# revision identifiers, used by Alembic.
revision = 'a845e4d8ade8'
down_revision = 'bca7113d796f'

from alembic import op
import sqlalchemy as sa


def upgrade():
    op.add_column('ps_contacts', sa.Column('via_addr', sa.String(40)))
    op.add_column('ps_contacts', sa.Column('via_port', sa.Integer))
    op.add_column('ps_contacts', sa.Column('call_id', sa.String(255)))

def downgrade():
    op.drop_column('ps_contacts', 'via_addr')
    op.drop_column('ps_contacts', 'via_port')
    op.drop_column('ps_contacts', 'call_id')