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>

Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
Signed-off-by: Tomas Cohen Arazi <tomascohen@gmail.com>

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 (file)
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 (executable)
--- 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)