Attachment 123141 Details for Bug 15067 – Bug 15067: Add additional languages to advanced search language search

[patch] Bug 15067: Add additional languages to advanced search language search

Bug-15067-Add-additional-languages-to-advanced-sea.patch (text/plain), 4.87 KB, created by Nick Clemens (kidclamp) on 2021-07-23 16:12:33 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Nick Clemens (kidclamp)

Created: 2021-07-23 16:12:33 UTC

Size: 4.87 KB

patch

obsolete

>From 74356a2cafbc3c27ec6f3155c81ea445fcf7f59d Mon Sep 17 00:00:00 2001
>From: Gus <gel1163@stacmail.net>
>Date: Thu, 21 Jan 2016 02:23:38 +0000
>Subject: [PATCH] Bug 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
>
>Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
>
>Signed-off-by: David Nind <david@davidnind.com>
>
>Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
>---
> .../bug_15067-add_newlanguages.sql            | 15 +++++
> .../data/mysql/mandatory/subtag_registry.sql  | 55 +++++++++++++++++++
> 2 files changed, 70 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 0000000000..a2f5589514
>--- /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 3b281d30d6..a75824ac6f 100644
>--- a/installer/data/mysql/mandatory/subtag_registry.sql
>+++ b/installer/data/mysql/mandatory/subtag_registry.sql
>@@ -1804,3 +1804,58 @@ 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');
>-- 
>2.20.1

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