Bug 14100: Better errors handling

[koha.git] / installer / data / mysql / kohastructure.sql

diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
index 8ad2205..593d96b 100644 (file)
--- a/installer/data/mysql/kohastructure.sql
+++ b/installer/data/mysql/kohastructure.sql
@@ -3574,7 +3574,8 @@ CREATE TABLE `localization` (
       code varchar(64) COLLATE utf8_unicode_ci NOT NULL,
       lang varchar(25) COLLATE utf8_unicode_ci NOT NULL, --could be a foreign key
       translation text COLLATE utf8_unicode_ci,
-      PRIMARY KEY (localization_id)
+      PRIMARY KEY (localization_id),
+      UNIQUE KEY `entity_code_lang` (`entity`,`code`,`lang`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;