From fe9fed3efcc4db6a037d7db68b886d3480c4e9b8 Mon Sep 17 00:00:00 2001
From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Date: Wed, 10 Feb 2021 08:00:54 +0100
Subject: [PATCH] Bug 27621: Keep COUNTRY and LANG

Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>

Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>

Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>

Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
---
 .../data/mysql/localization/it-IT/custom.sql    | 17 +++++++++++++++++
 1 file changed, 17 insertions(+)

diff --git a/installer/data/mysql/localization/it-IT/custom.sql b/installer/data/mysql/localization/it-IT/custom.sql
index d9aca86600..a85176c3fa 100644
--- a/installer/data/mysql/localization/it-IT/custom.sql
+++ b/installer/data/mysql/localization/it-IT/custom.sql
@@ -62,3 +62,20 @@ UPDATE systempreferences SET value = '1' WHERE variable = 'UseICUStyleQuotes';
 UPDATE systempreferences SET value = 'URLLinkText' WHERE variable = 'URLLinkText';
 
 UPDATE systempreferences SET value = '#200|<span style=\"font-weight:bold\">|{200a}{. 200c}{ : 200e}{200d}{ / 200f}{ ; 200g}{. 200h}{. 200i}|</span>\r\n#210|. &ndash; |{210a}{ : 210c}{, 210d}|\r\n#215|. &ndash; |{215a}{ ; 215d}|\r\n#225|. &ndash; |{(225a}{ ; 225v)}|\r\n#010|. &ndash; |{ISBN 010a}|' WHERE variable = 'ISBD';
+
+INSERT INTO authorised_values (category, authorised_value, lib) VALUES
+('COUNTRY', 'IT', 'Italia'),
+('COUNTRY', 'US', 'Stati Uniti'),
+('COUNTRY', 'GB', 'Regno Unito - UK '),
+('COUNTRY', 'DE', 'Germania'),
+('COUNTRY', 'FR', 'Francia'),
+('COUNTRY', 'VA', 'Vaticano'),
+('COUNTRY', 'CN', 'Cina'),
+('COUNTRY', 'IN', 'India');
+
+INSERT INTO authorised_values (category, authorised_value, lib) VALUES
+('LANG', 'ita', 'italiano'),
+('LANG', 'eng', 'inglese'),
+('LANG', 'ger', 'tedesco'),
+('LANG', 'fre', 'francese'),
+('LANG', 'lat', 'latino');
-- 
2.39.5