From cd5ae02812faa311056adb3f27cd8270642a4a6e Mon Sep 17 00:00:00 2001 From: Corey Farrell Date: Mon, 2 Nov 2015 21:11:11 -0500 Subject: Increase account code maximum length to 80. This increases the maximum length of account code's to match extensions. This ensures it is always possible to set an accountcode to ${EXTEN} without truncation. ASTERISK-23904 Reported by: Ben Merrills Change-Id: If122602304ce03362722eb213a3111b32da5eeb9 --- .../54cde9847798_expand_accountcode_to_80.py | 26 ++++++++++++++++++++ .../339a3bdf53fc_expand_accountcode_to_80.py | 28 ++++++++++++++++++++++ 2 files changed, 54 insertions(+) create mode 100644 contrib/ast-db-manage/cdr/versions/54cde9847798_expand_accountcode_to_80.py create mode 100644 contrib/ast-db-manage/config/versions/339a3bdf53fc_expand_accountcode_to_80.py (limited to 'contrib/ast-db-manage') diff --git a/contrib/ast-db-manage/cdr/versions/54cde9847798_expand_accountcode_to_80.py b/contrib/ast-db-manage/cdr/versions/54cde9847798_expand_accountcode_to_80.py new file mode 100644 index 000000000..dd61a44ee --- /dev/null +++ b/contrib/ast-db-manage/cdr/versions/54cde9847798_expand_accountcode_to_80.py @@ -0,0 +1,26 @@ +"""expand accountcode to 80 + +Revision ID: 54cde9847798 +Revises: 210693f3123d +Create Date: 2015-11-05 09:54:06.815364 + +""" + +# revision identifiers, used by Alembic. +revision = '54cde9847798' +down_revision = '210693f3123d' + +from alembic import op +import sqlalchemy as sa + + +def upgrade(): + op.alter_column('cdr', 'accountcode', type_=sa.String(80)) + op.alter_column('cdr', 'peeraccount', type_=sa.String(80)) + pass + + +def downgrade(): + op.alter_column('cdr', 'accountcode', type_=sa.String(20)) + op.alter_column('cdr', 'peeraccount', type_=sa.String(20)) + pass diff --git a/contrib/ast-db-manage/config/versions/339a3bdf53fc_expand_accountcode_to_80.py b/contrib/ast-db-manage/config/versions/339a3bdf53fc_expand_accountcode_to_80.py new file mode 100644 index 000000000..31889c66b --- /dev/null +++ b/contrib/ast-db-manage/config/versions/339a3bdf53fc_expand_accountcode_to_80.py @@ -0,0 +1,28 @@ +"""expand accountcode to 80 + +Revision ID: 339a3bdf53fc +Revises: 28ce1e718f05 +Create Date: 2015-11-05 10:10:27.465794 + +""" + +# revision identifiers, used by Alembic. +revision = '339a3bdf53fc' +down_revision = '28ce1e718f05' + +from alembic import op +import sqlalchemy as sa + + +def upgrade(): + op.alter_column('ps_endpoints', 'accountcode', type_=sa.String(80)) + op.alter_column('sippeers', 'accountcode', type_=sa.String(80)) + op.alter_column('iaxfriends', 'accountcode', type_=sa.String(80)) + pass + + +def downgrade(): + op.alter_column('ps_endpoints', 'accountcode', type_=sa.String(20)) + op.alter_column('sippeers', 'accountcode', type_=sa.String(40)) + op.alter_column('iaxfriends', 'accountcode', type_=sa.String(20)) + pass -- cgit v1.2.3