Asterisk - The Open Source Telephony Project  18.5.0
837aa67461fb_add_pjsip_endpoint_ip_access_control_.py
Go to the documentation of this file.
1 """Add PJSIP Endpoint IP Access Control options
2 
3 Revision ID: d7e3c73eb2bf
4 Revises: 6be31516058d
5 Create Date: 2016-05-13 12:45:45.071871
6 
7 """
8 
9 # revision identifiers, used by Alembic.
10 revision = 'd7e3c73eb2bf'
11 down_revision = '6be31516058d'
12 
13 from alembic import op
14 import sqlalchemy as sa
15 
16 
17 def upgrade():
18  op.add_column('ps_endpoints', sa.Column('deny', sa.String(95)))
19  op.add_column('ps_endpoints', sa.Column('permit', sa.String(95)))
20  op.add_column('ps_endpoints', sa.Column('acl', sa.String(40)))
21  op.add_column('ps_endpoints', sa.Column('contact_deny', sa.String(95)))
22  op.add_column('ps_endpoints', sa.Column('contact_permit', sa.String(95)))
23  op.add_column('ps_endpoints', sa.Column('contact_acl', sa.String(40)))
24 
25 
26 def downgrade():
27  op.drop_column('ps_endpoints', 'contact_acl')
28  op.drop_column('ps_endpoints', 'contact_permit')
29  op.drop_column('ps_endpoints', 'contact_deny')
30  op.drop_column('ps_endpoints', 'acl')
31  op.drop_column('ps_endpoints', 'permit')
32  op.drop_column('ps_endpoints', 'deny')