From 80c628f90ad9fac91119158ea5002bbdd955dddf Mon Sep 17 00:00:00 2001 From: Bernardo Gonzalez Kriegel Date: Mon, 20 Apr 2015 21:34:05 -0300 Subject: [PATCH] [PASSED QA] 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 Signed-off-by: Katrin Fischer --- .../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