From 7d465ff354b438604b078e5f97103bfb216c16a3 Mon Sep 17 00:00:00 2001 From: Gus Date: Thu, 21 Jan 2016 02:23:38 +0000 Subject: [PATCH] 15067 - Add additional languages to advanced search language search run update database script, look for new laguages under 'Language:' in Advanced search. Languages that should be added are: 1. Estonian 2. Latvian 3. Lithuanian 4. Inuktitut 5. Inupiaq --- .../atomicupdate/bug_15067-add_newlanguages.sql | 15 ++++++ installer/data/mysql/mandatory/subtag_registry.sql | 56 ++++++++++++++++++++ 2 files changed, 71 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug_15067-add_newlanguages.sql diff --git a/installer/data/mysql/atomicupdate/bug_15067-add_newlanguages.sql b/installer/data/mysql/atomicupdate/bug_15067-add_newlanguages.sql new file mode 100644 index 0000000..a2f5589 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_15067-add_newlanguages.sql @@ -0,0 +1,15 @@ +INSERT INTO language_subtag_registry (subtag, type, description, added) VALUES ('et', 'language', 'Estonian', now()); +INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('et', 'language', 'en', 'Estonian'); +INSERT INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) VALUES ('et', 'est'); +INSERT INTO language_subtag_registry (subtag, type, description, added) VALUES ('lv', 'language', 'Latvian', now()); +INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('lv', 'language', 'en', 'Latvian'); +INSERT INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) VALUES ('lv', 'lav'); +INSERT INTO language_subtag_registry (subtag, type, description, added) VALUES ('lt', 'language', 'Lithuanian', now()); +INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('lt', 'language', 'en', 'Lithuanian'); +INSERT INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) VALUES ('lt', 'lit'); +INSERT INTO language_subtag_registry (subtag, type, description, added) VALUES ('iu', 'language', 'Inuktitut', now()); +INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('iu', 'language', 'en', 'Inuktitut'); +INSERT INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) VALUES ('iu', 'iku'); +INSERT INTO language_subtag_registry (subtag, type, description, added) VALUES ('ik', 'language', 'Inupiaq', now()); +INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('ik', 'language', 'en', 'Inupiaq'); +INSERT INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) VALUES ('ik', 'ipk'); diff --git a/installer/data/mysql/mandatory/subtag_registry.sql b/installer/data/mysql/mandatory/subtag_registry.sql index 5dc2af2..0fb7ed8 100755 --- a/installer/data/mysql/mandatory/subtag_registry.sql +++ b/installer/data/mysql/mandatory/subtag_registry.sql @@ -1801,3 +1801,59 @@ VALUES ( 'VN', 'region', 'en', 'Vietnam'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'VN', 'region', 'vi', 'Việt Nam'); + +-- Estonian + +INSERT INTO language_descriptions (subtag, type, lang, description) +VALUES ('et', 'language', 'en', 'Estonian'); + +INSERT INTO language_subtag_registry (subtag, type, description, added) +VALUES ('et', 'language', 'Estonian', now()); + +INSERT INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) +VALUES ('et', 'est'); + +-- Latvian + +INSERT INTO language_descriptions (subtag, type, lang, description) +VALUES ('lv', 'language', 'en', 'Latvian'); + +INSERT INTO language_subtag_registry (subtag, type, description, added) +VALUES ('lv', 'language', 'Latvian', now()); + +INSERT INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) +VALUES ('lv', 'lav'); + +-- Lithianian + +INSERT INTO language_descriptions (subtag, type, lang, description) +VALUES ('lt', 'language', 'en', 'Lithuanian'); + +INSERT INTO language_subtag_registry (subtag, type, description, added) +VALUES ('lt', 'language', 'Lithuanian', now()); + +INSERT INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) +VALUES ('lt', 'lit'); + +-- Inuktitut + +INSERT INTO language_descriptions (subtag, type, lang, description) +VALUES ('iu', 'language', 'en', 'Inuktitut'); + +INSERT INTO language_subtag_registry (subtag, type, description, added) +VALUES ('iu', 'language', 'Inuktitut', now()); + +INSERT INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) +VALUES ('iu', 'iku'); + +--Inupiaq + +INSERT INTO language_descriptions (subtag, type, lang, description) +VALUES ('ik', 'language', 'en', 'Inupiaq'); + +INSERT INTO language_subtag_registry (subtag, type, description, added) +VALUES ('ik', 'language', 'Inupiaq', now()); + +INSERT INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) +VALUES ('ik', 'ipk'); + -- 1.7.10.4