From 337ec9d893b88099ff4b36d07647b306b4eff704 Mon Sep 17 00:00:00 2001 From: Ethan Amohia Date: Thu, 17 Jan 2019 04:00:03 +0000 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. --- Koha/Illbackends/BLDSS | 1 + Koha/Illbackends/koha-ill-freeform | 1 + .../mysql/atomicupdate/bug_15067-add_newlanguages.sql | 19 +++++++++++++++++++ installer/data/mysql/mandatory/subtag_registry.sql | 15 +++++++++++++++ koha-ill-freeform | 1 + 5 files changed, 37 insertions(+) create mode 160000 Koha/Illbackends/BLDSS create mode 160000 Koha/Illbackends/koha-ill-freeform create mode 160000 koha-ill-freeform diff --git a/Koha/Illbackends/BLDSS b/Koha/Illbackends/BLDSS new file mode 160000 index 0000000000..39f98e6f80 --- /dev/null +++ b/Koha/Illbackends/BLDSS @@ -0,0 +1 @@ +Subproject commit 39f98e6f8028f5f152e5028582c94ae683a20f62 diff --git a/Koha/Illbackends/koha-ill-freeform b/Koha/Illbackends/koha-ill-freeform new file mode 160000 index 0000000000..a52db29936 --- /dev/null +++ b/Koha/Illbackends/koha-ill-freeform @@ -0,0 +1 @@ +Subproject commit a52db29936a520c1f84e08b7d2a54b16cba12cc5 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 70fcffc5e2..5b33f0afcd 100755 --- 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()); diff --git a/koha-ill-freeform b/koha-ill-freeform new file mode 160000 index 0000000000..a52db29936 --- /dev/null +++ b/koha-ill-freeform @@ -0,0 +1 @@ +Subproject commit a52db29936a520c1f84e08b7d2a54b16cba12cc5 -- 2.11.0