Asterisk - The Open Source Telephony Project  21.4.1
dac2b4c328b8_incease_pjsip_id_length.py
1 """increase pjsip id length
2 
3 Revision ID: dac2b4c328b8
4 Revises: f5b0e7427449
5 Create Date: 2023-09-23 02:15:24.270526
6 
7 """
8 
9 # revision identifiers, used by Alembic.
10 revision = 'dac2b4c328b8'
11 down_revision = 'f5b0e7427449'
12 
13 from alembic import op
14 import sqlalchemy as sa
15 
16 
17 def upgrade():
18  op.alter_column('ps_aors', 'id', type_=sa.String(255))
19  op.alter_column('ps_aors', 'outbound_proxy', type_=sa.String(255))
20 
21  op.alter_column('ps_auths', 'id', type_=sa.String(255))
22  op.alter_column('ps_auths', 'realm', type_=sa.String(255))
23 
24  op.alter_column('ps_contacts', 'outbound_proxy', type_=sa.String(255))
25  op.alter_column('ps_contacts', 'endpoint', type_=sa.String(255))
26 
27  op.alter_column('ps_domain_aliases', 'id', type_=sa.String(255))
28  op.alter_column('ps_domain_aliases', 'domain', type_=sa.String(255))
29 
30  op.alter_column('ps_endpoint_id_ips', 'id', type_=sa.String(255))
31  op.alter_column('ps_endpoint_id_ips', 'endpoint', type_=sa.String(255))
32 
33  op.alter_column('ps_endpoints', 'id', type_=sa.String(255))
34  op.alter_column('ps_endpoints', 'aors', type_=sa.String(2048))
35  op.alter_column('ps_endpoints', 'auth', type_=sa.String(255))
36  op.alter_column('ps_endpoints', 'outbound_auth', type_=sa.String(255))
37  op.alter_column('ps_endpoints', 'outbound_proxy', type_=sa.String(255))
38 
39  op.alter_column('ps_inbound_publications', 'id', type_=sa.String(255))
40  op.alter_column('ps_inbound_publications', 'endpoint', type_=sa.String(255))
41 
42  op.alter_column('ps_outbound_publishes', 'id', type_=sa.String(255))
43  op.alter_column('ps_outbound_publishes', 'outbound_auth', type_=sa.String(255))
44 
45  op.alter_column('ps_registrations', 'id', type_=sa.String(255))
46  op.alter_column('ps_registrations', 'outbound_auth', type_=sa.String(255))
47  op.alter_column('ps_registrations', 'outbound_proxy', type_=sa.String(255))
48  op.alter_column('ps_registrations', 'endpoint', type_=sa.String(255))
49 
50 
51 def downgrade():
52  op.alter_column('ps_aors', 'id', type_=sa.String(40))
53  op.alter_column('ps_aors', 'outbound_proxy', type_=sa.String(40))
54 
55  op.alter_column('ps_auths', 'id', type_=sa.String(40))
56  op.alter_column('ps_auths', 'realm', type_=sa.String(40))
57 
58  op.alter_column('ps_contacts', 'outbound_proxy', type_=sa.String(40))
59  op.alter_column('ps_contacts', 'endpoint', type_=sa.String(40))
60 
61  op.alter_column('ps_domain_aliases', 'id', type_=sa.String(40))
62  op.alter_column('ps_domain_aliases', 'domain', type_=sa.String(40))
63 
64  op.alter_column('ps_endpoint_id_ips', 'id', type_=sa.String(40))
65  op.alter_column('ps_endpoint_id_ips', 'endpoint', type_=sa.String(40))
66 
67  op.alter_column('ps_endpoints', 'id', type_=sa.String(40))
68  op.alter_column('ps_endpoints', 'aors', type_=sa.String(200))
69  op.alter_column('ps_endpoints', 'auth', type_=sa.String(40))
70  op.alter_column('ps_endpoints', 'outbound_auth', type_=sa.String(40))
71  op.alter_column('ps_endpoints', 'outbound_proxy', type_=sa.String(40))
72 
73  op.alter_column('ps_inbound_publications', 'id', type_=sa.String(40))
74  op.alter_column('ps_inbound_publications', 'endpoint', type_=sa.String(40))
75 
76  op.alter_column('ps_outbound_publishes', 'id', type_=sa.String(40))
77  op.alter_column('ps_outbound_publishes', 'outbound_auth', type_=sa.String(40))
78 
79  op.alter_column('ps_registrations', 'id', type_=sa.String(40))
80  op.alter_column('ps_registrations', 'outbound_auth', type_=sa.String(40))
81  op.alter_column('ps_registrations', 'outbound_proxy', type_=sa.String(40))
82  op.alter_column('ps_registrations', 'endpoint', type_=sa.String(40))
83