contrib/ast-db-manage/config/versions/e96a0b8071c_increase_pjsip_column_size.py

   1 """increase pjsip columns size
   2
   3 Revision ID: e96a0b8071c
   4 Revises: 3855ee4e5f85
   5 Create Date: 2014-04-23 11:38:02.333786
   6
   7 """
   8
   9 # revision identifiers, used by Alembic.
  10 revision = 'e96a0b8071c'
  11 down_revision = '3855ee4e5f85'
  12
  13 from alembic import op
  14 import sqlalchemy as sa
  15
  16
  17 def upgrade():
  18     op.alter_column('ps_globals', 'user_agent', type_=sa.String(255))
  19
  20     op.alter_column('ps_contacts', 'id', type_=sa.String(255))
  21     op.alter_column('ps_contacts', 'uri', type_=sa.String(255))
  22     op.alter_column('ps_contacts', 'user_agent', type_=sa.String(255))
  23
  24     op.alter_column('ps_registrations', 'client_uri', type_=sa.String(255))
  25     op.alter_column('ps_registrations', 'server_uri', type_=sa.String(255))
  26
  27
  28 def downgrade():
  29     op.alter_column('ps_registrations', 'server_uri', type_=sa.String(40))
  30     op.alter_column('ps_registrations', 'client_uri', type_=sa.String(40))
  31
  32     op.alter_column('ps_contacts', 'user_agent', type_=sa.String(40))
  33     op.alter_column('ps_contacts', 'uri', type_=sa.String(40))
  34     op.alter_column('ps_contacts', 'id', type_=sa.String(40))
  35
  36     op.alter_column('ps_globals', 'user_agent', type_=sa.String(40))
  37
  38
  39