@@ -, +, @@ code --- .../bug_14030-Add_Georgian_fix_Kannada_code.sql | 22 ++++++++++++++++ installer/data/mysql/mandatory/subtag_registry.sql | 30 +++++++++++++++++++--- 2 files changed, 48 insertions(+), 4 deletions(-) create mode 100644 installer/data/mysql/atomicupdate/bug_14030-Add_Georgian_fix_Kannada_code.sql --- a/installer/data/mysql/atomicupdate/bug_14030-Add_Georgian_fix_Kannada_code.sql +++ a/installer/data/mysql/atomicupdate/bug_14030-Add_Georgian_fix_Kannada_code.sql @@ -0,0 +1,22 @@ +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'); + --- a/installer/data/mysql/mandatory/subtag_registry.sql +++ a/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) --