[sr-dev] git:master: modules/lcr/utils/lcr_upgrade_from_3.1.sh: upgraded also lcr_gw index.

Module: sip-router Branch: master Commit: 20599670ead5e94f9b3716eaf6e05324eb99b39d URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=2059967… Author: Juha Heinanen <jh(a)tutpro.com> Committer: Juha Heinanen <jh(a)tutpro.com> Date: Thu Oct 6 21:25:38 2011 +0300 modules/lcr/utils/lcr_upgrade_from_3.1.sh: upgraded also lcr_gw index. --- modules/lcr/utils/lcr_upgrade_from_3.1.sh | 5 ++++- 1 files changed, 4 insertions(+), 1 deletions(-) diff --git a/modules/lcr/utils/lcr_upgrade_from_3.1.sh b/modules/lcr/utils/lcr_upgrade_from_3.1.sh index 3db7022..b8d30ee 100644 --- a/modules/lcr/utils/lcr_upgrade_from_3.1.sh +++ b/modules/lcr/utils/lcr_upgrade_from_3.1.sh @@ -45,9 +45,12 @@ function upgrade_lcr_gw_table() { or die("Failed to alter 'ser/lcr_gw' table!\n"); mysql_query("ALTER TABLE lcr_gw ADD COLUMN tag VARCHAR(64) DEFAULT NULL AFTER prefix") or die("Failed to alter 'ser/lcr_gw' table!\n"); + mysql_query("ALTER TABLE lcr_gw DROP INDEX lcr_id_ip_addr_port_hostname_idx") + or die ("Failed to drop 'ser/lcr_gw' index\n"); + mysql_query("ALTER TABLE lcr_gw ADD INDEX lcr_id_idx (lcr_id)") + or die ("Failed to add 'ser/lcr_gw' index\n"); mysql_query("UPDATE version SET table_version=2 WHERE table_name='lcr_gw'") or die ("Failed to update into 'ser/version' table\n"); - db_disconnect(); echo "Table 'ser/lcr_gw' upgraded\n";