From 39c4304d96d1adbab8e7852ad5e314b8e0f27439 Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Sat, 1 May 2010 09:44:29 -0400 Subject: [PATCH] fix DBrev 132 * renamed index; there was already an index named 'lang' on language_description * removed reference to ersataz DB rev number Signed-off-by: Galen Charlton --- installer/data/mysql/kohastructure.sql | 3 ++- installer/data/mysql/updatedatabase.pl | 3 +-- 2 files changed, 3 insertions(+), 3 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index ace212e146..d09a6a979c 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -2013,7 +2013,8 @@ CREATE TABLE language_descriptions ( description varchar(255), id int(11) NOT NULL auto_increment, PRIMARY KEY (`id`), - KEY `lang` (`lang`) + KEY `lang` (`lang`), + KEY `subtag_type_lang` (`subtag`, `type`, `lang`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- bi-directional support, keyed by script subcode diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index cfa1ff3621..a2ebc5c810 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -3581,10 +3581,9 @@ INSERT IGNORE INTO message_transport_types (message_transport_type) VALUES ('pri } $DBversion = "3.01.00.132"; -#3.02.00.023 if (C4::Context->preference("Version") < TransformToNum($DBversion)) { $dbh->do(q{ - ALTER TABLE language_descriptions ADD INDEX LANG (subtag, type, lang); + ALTER TABLE language_descriptions ADD INDEX subtag_type_lang (subtag, type, lang); }); print "Upgrade to $DBversion done (Adding index to language_descriptions table)\n"; SetVersion ($DBversion); -- 2.39.5