Add alembic script that adds contact user_agent and endpoint message_context.
[asterisk/asterisk.git] / contrib / ast-db-manage / config / versions / 3855ee4e5f85_add_missing_pjsip_options.py
1 """add_missing_pjsip_options
2
3 Revision ID: 3855ee4e5f85
4 Revises: 4c573e7135bd
5 Create Date: 2014-03-28 10:49:04.637730
6
7 """
8
9 # revision identifiers, used by Alembic.
10 revision = '3855ee4e5f85'
11 down_revision = '4c573e7135bd'
12
13 from alembic import op
14 import sqlalchemy as sa
15
16
17 def upgrade():
18     op.add_column('ps_endpoints', sa.Column('message_context', sa.String(40)))
19     op.add_column('ps_contacts', sa.Column('user_agent', sa.String(40)))
20
21
22 def downgrade():
23     op.drop_column('ps_contacts', 'user_agent')
24     op.drop_column('ps_endpoints', 'message_context')