diff options
author | Mark Michelson <mmichelson@digium.com> | 2016-07-22 14:44:50 -0500 |
---|---|---|
committer | Mark Michelson <mmichelson@digium.com> | 2016-07-22 14:44:50 -0500 |
commit | eda95236d10f4bd0d772efc29a0a2ad270db8c32 (patch) | |
tree | 4e92884879663c584ea6e3e1f6206040294ca89c /contrib | |
parent | 8d6a7b89bd663fe87c64bd49a41450851ea3d928 (diff) |
Fix sqlalchemy error regarding identifier length.
sqlalchemy was complaining:
sqlalchemy.exc.IdentifierError: Identifier
'ps_contacts_qualifyfreq_exptime' exceeds maximum length of 30
characters
This fixes the problem by changing the index name to be
"ps_contacts_qualifyfreq_exp" instead.
ASTERISK-26227 #close
Reported by Mark Michelson
Change-Id: I0ed784f87504be2a59ee8d3242ef6f625d5ed1a9
Diffstat (limited to 'contrib')
-rw-r--r-- | contrib/ast-db-manage/config/versions/ef7efc2d3964_ps_contacts_add_endpoint_and_modify_.py | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/contrib/ast-db-manage/config/versions/ef7efc2d3964_ps_contacts_add_endpoint_and_modify_.py b/contrib/ast-db-manage/config/versions/ef7efc2d3964_ps_contacts_add_endpoint_and_modify_.py index ff1834329..43d4028f2 100644 --- a/contrib/ast-db-manage/config/versions/ef7efc2d3964_ps_contacts_add_endpoint_and_modify_.py +++ b/contrib/ast-db-manage/config/versions/ef7efc2d3964_ps_contacts_add_endpoint_and_modify_.py @@ -24,10 +24,10 @@ def upgrade(): else: op.execute('ALTER TABLE ps_contacts ALTER COLUMN expiration_time TYPE BIGINT USING expiration_time::bigint') - op.create_index('ps_contacts_qualifyfreq_exptime', 'ps_contacts', ['qualify_frequency', 'expiration_time']) + op.create_index('ps_contacts_qualifyfreq_exp', 'ps_contacts', ['qualify_frequency', 'expiration_time']) op.create_index('ps_aors_qualifyfreq_contact', 'ps_aors', ['qualify_frequency', 'contact']) def downgrade(): op.drop_index('ps_aors_qualifyfreq_contact') - op.drop_index('ps_contacts_qualifyfreq_exptime') + op.drop_index('ps_contacts_qualifyfreq_exp') op.drop_column('ps_contacts', 'endpoint') op.alter_column('ps_contacts', 'expiration_time', type_=sa.String(40)) |