From 40416ccaa7690fd8022097936c0f41a529b89d4d Mon Sep 17 00:00:00 2001 From: Florian Floimair Date: Thu, 23 Aug 2018 13:57:31 +0200 Subject: [PATCH] alembic: increase uri column size When mobile SIP clients register with Asterisk that use some sort of push notifications, the URI can get quite lengthy due to the additional push-service annotations (things like tokens, pn-type, etc.) contained in it. ASTERISK-28022 #close Change-Id: I4e5cfa3318da98deff223d613f82ffc92c9c387c --- .../1d3ed26d9978_increase_uri_column_size.py | 22 +++++++++++++++++++ 1 file changed, 22 insertions(+) create mode 100644 contrib/ast-db-manage/config/versions/1d3ed26d9978_increase_uri_column_size.py diff --git a/contrib/ast-db-manage/config/versions/1d3ed26d9978_increase_uri_column_size.py b/contrib/ast-db-manage/config/versions/1d3ed26d9978_increase_uri_column_size.py new file mode 100644 index 0000000000..d00d0fad8e --- /dev/null +++ b/contrib/ast-db-manage/config/versions/1d3ed26d9978_increase_uri_column_size.py @@ -0,0 +1,22 @@ +"""Increase uri column size + +Revision ID: 1d3ed26d9978 +Revises: 19b00bc19b7b +Create Date: 2018-08-23 11:46:13.283801 + +""" + +# revision identifiers, used by Alembic. +revision = '1d3ed26d9978' +down_revision = '19b00bc19b7b' + +from alembic import op +import sqlalchemy as sa + + +def upgrade(): + op.alter_column('ps_contacts', 'uri', type_=sa.String(511)) + + +def downgrade(): + op.alter_column('ps_contacts', 'uri', type_=sa.String(255)) -- 2.47.2