Attachment 121241 Details for Bug 15067 – Bug 15067: Added translations of languages to those 5 languages

[patch] Bug 15067: Added translations of languages to those 5 languages

Bug-15067-Added-translations-of-languages-to-those.patch (text/plain), 5.89 KB, created by Matthias Meusburger on 2021-05-20 13:02:06 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Matthias Meusburger

Created: 2021-05-20 13:02:06 UTC

Size: 5.89 KB

patch

obsolete

>From 3b0107d156d50eba0306f0f06d1eab04e86a29d6 Mon Sep 17 00:00:00 2001
>From: Hayley Mapley <hayleymapley@catalyst.net.nz>
>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 <hayleymapley@catalyst.net.nz>
>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 a2f5589..0dd5d3d 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 a75824a..10aa5f2 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.7.4

Actions: View | Diff | Splinter Review

Attachments on bug 15067: 47076 | 47279 | 47280 | 47285 | 47286 | 47287 | 84122 | 84124 | 86122 | 89642 | 121239 | 121240 | 121241 | 121260 | 121261 | 121262 | 123140 | 123141 | 123142 | 123143 | 128105 | 128112