[Koha-patches] [PATCH] followup 128 129 DB change

Wed Apr 7 17:34:48 CEST 2010

---
 installer/data/mysql/kohastructure.sql |    3 ++-
 1 files changed, 2 insertions(+), 1 deletions(-)

diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
index 1d5cba9..d925383 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  LN (subtag, type, lang)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 -- bi-directional support, keyed by script subcode
-- 
1.6.3.3


