Attachment 47286 Details for Bug 15067 – [SIGNED-OFF] 15067 - Add additional languages to advanced search language search

[patch] [SIGNED-OFF] 15067 - Add additional languages to advanced search language search

SIGNED-OFF-15067---Add-additional-languages-to-adv.patch (text/plain), 4.78 KB, created by Aleisha Amohia on 2016-01-26 01:05:28 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Aleisha Amohia

Created: 2016-01-26 01:05:28 UTC

Size: 4.78 KB

patch

obsolete

>From 6c75d860a17d02e75af7d41215660cf0b1ec16bc Mon Sep 17 00:00:00 2001
>From: Gus <gel1163@stacmail.net>
>Date: Thu, 21 Jan 2016 02:23:38 +0000
>Subject: [PATCH] [SIGNED-OFF] 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>
>---
> .../atomicupdate/bug_15067-add_newlanguages.sql    |   15 ++++++
> installer/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 0000000..a2f5589
>--- /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 5dc2af2..388e220 100755
>--- a/installer/data/mysql/mandatory/subtag_registry.sql
>+++ b/installer/data/mysql/mandatory/subtag_registry.sql
>@@ -1801,3 +1801,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');
>-- 
>1.7.10.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