@@ -, +, @@ --- installer/data/mysql/atomicupdate/bug_20307.sql | 3 ++- installer/data/mysql/kohastructure.sql | 2 +- 2 files changed, 3 insertions(+), 2 deletions(-) --- a/installer/data/mysql/atomicupdate/bug_20307.sql +++ a/installer/data/mysql/atomicupdate/bug_20307.sql @@ -1,2 +1,3 @@ alter table localization add column interface varchar(30) default null after entity; - +alter table localization drop constraint entity_code_lang; +alter table localization add unique key entity_code_interface_lang (entity, code, interface, lang); --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -3721,7 +3721,7 @@ CREATE TABLE `localization` ( lang varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL, -- could be a foreign key translation MEDIUMTEXT COLLATE utf8mb4_unicode_ci, PRIMARY KEY (localization_id), - UNIQUE KEY `entity_code_lang` (`entity`,`code`,`lang`) + UNIQUE KEY `entity_code_interface_lang` (`entity`,`code`,`interface`,`lang`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- --