From 8a7a632b827516df24f9a29213e9b22b6807072e 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

---
 installer/data/mysql/atomicupdate/bug_20307.sql | 2 ++
 installer/data/mysql/kohastructure.sql          | 1 +
 2 files changed, 3 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..afaee63181
--- /dev/null
+++ b/installer/data/mysql/atomicupdate/bug_20307.sql
@@ -0,0 +1,2 @@
+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 4778e034bc..cdabcd1f19 100644
--- a/installer/data/mysql/kohastructure.sql
+++ b/installer/data/mysql/kohastructure.sql
@@ -3716,6 +3716,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.11.0