From 5e4eadd7f26235bd5931e2840444219076c48f74 Mon Sep 17 00:00:00 2001
From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Date: Wed, 28 Feb 2018 11:22:15 -0300
Subject: [PATCH] Bug 20307: Update the localization unique key
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
---
installer/data/mysql/atomicupdate/bug_20307.sql | 2 ++
installer/data/mysql/kohastructure.sql | 2 +-
2 files changed, 3 insertions(+), 1 deletion(-)
diff --git a/installer/data/mysql/atomicupdate/bug_20307.sql b/installer/data/mysql/atomicupdate/bug_20307.sql
index 0655e771b8..05ad215edf 100644
--- a/installer/data/mysql/atomicupdate/bug_20307.sql
+++ b/installer/data/mysql/atomicupdate/bug_20307.sql
@@ -1 +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);
diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
index 6ea3151ddf..be5d12b901 100644
--- a/installer/data/mysql/kohastructure.sql
+++ b/installer/data/mysql/kohastructure.sql
@@ -3664,7 +3664,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;
--
--
2.20.1