Asterisk - The Open Source Telephony Project GIT-master-f36a736
dac2b4c328b8_incease_pjsip_id_length.py
Go to the documentation of this file.
1"""increase pjsip id length
2
3Revision ID: dac2b4c328b8
4Revises: f5b0e7427449
5Create Date: 2023-09-23 02:15:24.270526
6
7"""
8
9# revision identifiers, used by Alembic.
10revision = 'dac2b4c328b8'
11down_revision = 'f5b0e7427449'
12
13from alembic import op
14import sqlalchemy as sa
15
16
17def 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
51def 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
dac2b4c328b8_incease_pjsip_id_length.upgrade
def upgrade()
Definition: dac2b4c328b8_incease_pjsip_id_length.py:17
dac2b4c328b8_incease_pjsip_id_length.downgrade
def downgrade()
Definition: dac2b4c328b8_incease_pjsip_id_length.py:51
Generated on Wed Dec 18 2024 20:04:15 for Asterisk - The Open Source Telephony Project by doxygen 1.9.4