From f1cff5367108aadaca6b9b3d1566312347a8e9bf Mon Sep 17 00:00:00 2001 From: Hayley Mapley Date: Mon, 13 May 2019 10:10:03 +1200 Subject: [PATCH] [SIGNED OFF] Bug 15067: Added translations of languages to those 5 languages Estonian, Latvian, Lithuanian, Inuktitut and Inupiaq are added with their translations to the Advanced Search languages. Test Plan: 1. From homepage, go to Advanced search 2. Click on More options next to the Search button 3. Scroll down to the Limits section 4. Click on Language: No limit 5. Find Estonian, Latvian, Lithuanian, Inuktitut and Inupiaq at the bottom of the dropdown. 6. They should all be there. 7. Estonian and Latvian are repeated, this need to be fixed. 8. They need to be put in alphabetical order. Signed-off-by: Hayley Mapley The five languages are present, sorted alphabetically, and are not repeated. --- .../mysql/atomicupdate/bug_15067-add_newlanguages.sql | 19 +++++++++++++++++++ installer/data/mysql/mandatory/subtag_registry.sql | 15 +++++++++++++++ 2 files changed, 34 insertions(+) diff --git a/installer/data/mysql/atomicupdate/bug_15067-add_newlanguages.sql b/installer/data/mysql/atomicupdate/bug_15067-add_newlanguages.sql index a2f5589514..0dd5d3da70 100644 --- a/installer/data/mysql/atomicupdate/bug_15067-add_newlanguages.sql +++ b/installer/data/mysql/atomicupdate/bug_15067-add_newlanguages.sql @@ -1,15 +1,34 @@ +-- Estonian + 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_descriptions (subtag, type, lang, description) VALUES ('et', 'language', 'et', 'Eesti'); INSERT INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) VALUES ('et', 'est'); + +-- Latvian + 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_descriptions (subtag, type, lang, description) VALUES ('lv', 'language', 'lv', 'Latvija'); INSERT INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) VALUES ('lv', 'lav'); + +-- Lithuanian + 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_descriptions (subtag, type, lang, description) VALUES ('lt', 'language', 'lt', 'Lietuvių'); INSERT INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) VALUES ('lt', 'lit'); + +-- Inuktitut + 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_descriptions (subtag, type, lang, description) VALUES ('iu', 'language', 'iu', 'ᐃᓄᒃᑎᑐᑦ'); INSERT INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) VALUES ('iu', 'iku'); + +-- Inupiaq + 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_descriptions (subtag, type, lang, description) VALUES ('ik', 'language', 'ik', 'Iñupiaq'); 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 70fcffc5e2..5b33f0afcd 100755 --- a/installer/data/mysql/mandatory/subtag_registry.sql +++ b/installer/data/mysql/mandatory/subtag_registry.sql @@ -1810,6 +1810,9 @@ VALUES ( 'VN', 'region', 'vi', 'Việt Nam'); INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('et', 'language', 'en', 'Estonian'); +INSERT INTO language_descriptions (subtag, type, lang, description) +VALUES ('et', 'language', 'et', 'Eesti'); + INSERT INTO language_subtag_registry (subtag, type, description, added) VALUES ('et', 'language', 'Estonian', now()); @@ -1821,6 +1824,9 @@ VALUES ('et', 'est'); INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('lv', 'language', 'en', 'Latvian'); +INSERT INTO language_descriptions (subtag, type, lang, description) +VALUES ('lv', 'language', 'lv', 'Latvija'); + INSERT INTO language_subtag_registry (subtag, type, description, added) VALUES ('lv', 'language', 'Latvian', now()); @@ -1832,6 +1838,9 @@ VALUES ('lv', 'lav'); INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('lt', 'language', 'en', 'Lithuanian'); +INSERT INTO language_descriptions (subtag, type, lang, description) +VALUES ('lt', 'language', 'lt', 'Lietuvių'); + INSERT INTO language_subtag_registry (subtag, type, description, added) VALUES ('lt', 'language', 'Lithuanian', now()); @@ -1843,6 +1852,9 @@ VALUES ('lt', 'lit'); INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('iu', 'language', 'en', 'Inuktitut'); +INSERT INTO language_descriptions (subtag, type, lang, description) +VALUES ('iu', 'language', 'iu', 'ᐃᓄᒃᑎᑐᑦ'); + INSERT INTO language_subtag_registry (subtag, type, description, added) VALUES ('iu', 'language', 'Inuktitut', now()); @@ -1854,6 +1866,9 @@ VALUES ('iu', 'iku'); INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('ik', 'language', 'en', 'Inupiaq'); +INSERT INTO language_descriptions (subtag, type, lang, description) +VALUES ('ik', 'language', 'ik', 'Iñupiaq'); + INSERT INTO language_subtag_registry (subtag, type, description, added) VALUES ('ik', 'language', 'Inupiaq', now()); -- 2.11.0