From ede26955db3f8182aacfea536b83d034f6e606e1 Mon Sep 17 00:00:00 2001
From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Date: Wed, 28 Feb 2018 10:27:10 -0300
Subject: [PATCH] Bug 20307: Add DB column localization.interface

Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Signed-off-by: Michal Denar <black23@gmail.com>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
---
 installer/data/mysql/atomicupdate/bug_20307.sql | 1 +
 installer/data/mysql/kohastructure.sql          | 1 +
 2 files changed, 2 insertions(+)
 create mode 100644 installer/data/mysql/atomicupdate/bug_20307.sql

diff --git a/installer/data/mysql/atomicupdate/bug_20307.sql b/installer/data/mysql/atomicupdate/bug_20307.sql
new file mode 100644
index 0000000000..0655e771b8
--- /dev/null
+++ b/installer/data/mysql/atomicupdate/bug_20307.sql
@@ -0,0 +1 @@
+alter table localization add column interface varchar(30) default null after entity;
diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
index 0aa3a9b784..1f37e04e1e 100644
--- a/installer/data/mysql/kohastructure.sql
+++ b/installer/data/mysql/kohastructure.sql
@@ -3696,6 +3696,7 @@ DROP TABLE IF EXISTS localization;
 CREATE TABLE `localization` (
       localization_id int(11) NOT NULL AUTO_INCREMENT,
       entity varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL,
+      interface varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
       code varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
       lang varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL, -- could be a foreign key
       translation MEDIUMTEXT COLLATE utf8mb4_unicode_ci,
-- 
2.20.1