From 365b3cf4611fdeefcb542a1928d474c7f2d18786 Mon Sep 17 00:00:00 2001 From: Hayley Mapley Date: Mon, 13 May 2019 10:10:03 +1200 Subject: [PATCH] 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. Signed-off-by: David Nind Signed-off-by: Nick Clemens --- .../bug_15067-add_newlanguages.sql | 19 +++++++++++++++++++ .../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 a75824ac6f..10aa5f216b 100644 --- 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.20.1