Bugzilla – Attachment 123142 Details for
Bug 15067
Add additional languages to advanced search language search
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 15067: Added translations of languages to those 5 languages
Bug-15067-Added-translations-of-languages-to-those.patch (text/plain), 5.99 KB, created by
Nick Clemens (kidclamp)
on 2021-07-23 16:12:37 UTC
(
hide
)
Description:
Bug 15067: Added translations of languages to those 5 languages
Filename:
MIME Type:
Creator:
Nick Clemens (kidclamp)
Created:
2021-07-23 16:12:37 UTC
Size:
5.99 KB
patch
obsolete
>From 365b3cf4611fdeefcb542a1928d474c7f2d18786 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. > >Signed-off-by: David Nind <david@davidnind.com> > >Signed-off-by: Nick Clemens <nick@bywatersolutions.com> >--- > .../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
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
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