From 390f304256004f8b4421dbeef7caac772864aba1 Mon Sep 17 00:00:00 2001
From: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com>
Date: Mon, 20 Apr 2015 21:34:05 -0300
Subject: [PATCH] Bug 14030: Add Georgian language and fix Kannada language
 code

This patch adds Georgian language and a fix wrong language code

Language added: Georgian - ka - geo
I selected 'geo' for ISO639-2 instead of 'kat' because it's the
same code form http://www.loc.gov/marc/languages/language_code.html

Also a fix is needed to Kannada ISO639-1 code, from 'ka' to 'kn'

To test:
1) Apply the patch
2) Run updatedatabase.pl (once)
3) Check language, e.g. go to staff > search > More options > Limits
and search for Georgian on language list

I only added language code 'ka', not script 'Geor' nor country 'GE',
the plan is to name translation files 'ka-*', but can ammend the patch
if needed.

Signed-off-by: Mark Tompsett <mtompset@hotmail.com>
---
 .../bug_14030-Add_Georgian_fix_Kannada_code.sql    | 21 +++++++++++++++
 installer/data/mysql/mandatory/subtag_registry.sql | 30 +++++++++++++++++++---
 2 files changed, 47 insertions(+), 4 deletions(-)
 create mode 100644 installer/data/mysql/atomicupdate/bug_14030-Add_Georgian_fix_Kannada_code.sql

diff --git a/installer/data/mysql/atomicupdate/bug_14030-Add_Georgian_fix_Kannada_code.sql b/installer/data/mysql/atomicupdate/bug_14030-Add_Georgian_fix_Kannada_code.sql
new file mode 100644
index 0000000..d07503e
--- /dev/null
+++ b/installer/data/mysql/atomicupdate/bug_14030-Add_Georgian_fix_Kannada_code.sql
@@ -0,0 +1,21 @@
+UPDATE language_subtag_registry SET subtag = 'kn' WHERE subtag = 'ka' AND description = 'Kannada';
+
+UPDATE language_rfc4646_to_iso639 SET rfc4646_subtag = 'kn' WHERE rfc4646_subtag = 'ka' AND iso639_2_code = 'kan';
+
+UPDATE language_descriptions SET subtag = 'kn', lang = 'kn' WHERE subtag = 'ka' AND lang = 'ka' AND description = 'ಕನ್ನಡ';
+
+UPDATE language_descriptions SET subtag = 'kn' WHERE subtag = 'ka' AND description = 'Kannada';
+
+INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'ka', 'language', 'Georgian','2015-04-20');
+
+INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'ka', 'geo');
+
+INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ka', 'language', 'ka', 'ქართული');
+
+INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ka', 'language', 'en', 'Georgian');
+
+INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ka', 'language', 'fr', 'Géorgien');
+
+INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ka', 'language', 'de', 'Georgische');
+
+INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ka', 'language', 'es', 'Georgiano');
diff --git a/installer/data/mysql/mandatory/subtag_registry.sql b/installer/data/mysql/mandatory/subtag_registry.sql
index 6001fff..bdf2631 100755
--- a/installer/data/mysql/mandatory/subtag_registry.sql
+++ b/installer/data/mysql/mandatory/subtag_registry.sql
@@ -537,18 +537,40 @@ VALUES ( 'ja', 'language', 'fr', 'Japonais');
 INSERT INTO language_descriptions(subtag, type, lang, description)
 VALUES ( 'ja', 'language', 'de', 'Japanisch');
 
+-- Georgian
+INSERT INTO language_subtag_registry( subtag, type, description, added)
+VALUES ( 'ka', 'language', 'Georgian','2015-04-20');
+
+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
+VALUES ( 'ka', 'geo');
+
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES ( 'ka', 'language', 'ka', 'ქართული');
+
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES ( 'ka', 'language', 'en', 'Georgian');
+
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES ( 'ka', 'language', 'fr', 'Géorgien');
+
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES ( 'ka', 'language', 'de', 'Georgische');
+
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES ( 'ka', 'language', 'es', 'Georgiano');
+
 -- Kannada
 INSERT INTO language_subtag_registry( subtag, type, description, added)
-VALUES ( 'ka', 'language', 'Kannada','2014-10-30');
+VALUES ( 'kn', 'language', 'Kannada','2014-10-30');
 
 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
-VALUES ( 'ka','kan');
+VALUES ( 'kn', 'kan');
 
 INSERT INTO language_descriptions(subtag, type, lang, description)
-VALUES ( 'ka', 'language', 'ka', 'ಕನ್ನಡ');
+VALUES ( 'kn', 'language', 'kn', 'ಕನ್ನಡ');
 
 INSERT INTO language_descriptions(subtag, type, lang, description)
-VALUES ( 'ka', 'language', 'en', 'Kannada');
+VALUES ( 'kn', 'language', 'en', 'Kannada');
 
 -- Khmer
 INSERT INTO language_subtag_registry( subtag, type, description, added)
-- 
1.9.1