From a265b95daaa1a135ef97dc6fc5b82a0840320cc1 Mon Sep 17 00:00:00 2001 From: Lari Taskula Date: Tue, 25 Apr 2017 10:23:03 +0000 Subject: [PATCH] Bug 18493: Add new searchable languages MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit This patch adds the following languages into advanced search "Languages" dropdown: Greenlandic Karelian Cornish Burmese Punjabi Pashto Finnish Kalo Akkala Sami Kildin Sami Ter Sami Pite Sami Kemi Sami Ume Sami Southern Sami Northern Sami Sami languages Lule Sami Inari Sami Skolt Sami Somali Sotho Votic To test: 1. perl installer/data/mysql/updatedatabase.pl 2. Go to intranet advanced search 3. Click "More options" 4. See "Limits" fieldset, it should have "Language" drop down 5. Observe that the languages provided in this patch are visible in this dropdown Signed-off-by: Marc Véron Signed-off-by: Marcel de Rooy Just noting that the order in this dropdown is hopeless. Signed-off-by: Martin Renvoize --- ...ug-18493-Add-new-searchable-languages.perl | 187 +++++++++ .../data/mysql/mandatory/subtag_registry.sql | 363 ++++++++++++++++-- 2 files changed, 527 insertions(+), 23 deletions(-) create mode 100644 installer/data/mysql/atomicupdate/Bug-18493-Add-new-searchable-languages.perl diff --git a/installer/data/mysql/atomicupdate/Bug-18493-Add-new-searchable-languages.perl b/installer/data/mysql/atomicupdate/Bug-18493-Add-new-searchable-languages.perl new file mode 100644 index 0000000000..a6e27b8478 --- /dev/null +++ b/installer/data/mysql/atomicupdate/Bug-18493-Add-new-searchable-languages.perl @@ -0,0 +1,187 @@ +$DBversion = 'XXX'; # will be replaced by the RM +if( CheckVersion( $DBversion ) ) { + + # Standard Tibetan + $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'bo', 'language', 'Standard Tibetan', '2017-04-21')"); + $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'bo', 'tib')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'bo', 'language', 'en', 'Standard Tibetan')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'bo', 'language', 'bo', 'ལྷ་སའི་སྐད་')"); + # Bosnian + $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'bs', 'language', 'Bosnian', '2017-04-21')"); + $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'bs', 'bos')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'bs', 'language', 'en', 'Bosnian')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'bs', 'language', 'bn', 'Bosanski')"); + # Welsh + $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'cy', 'language', 'Welsh', '2017-04-21')"); + $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'cy', 'wel')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'cy', 'language', 'en', 'Welsh')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'cy', 'language', 'cy', 'Cymraeg')"); + # Esperanto + $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'eo', 'language', 'Esperanto', '2017-04-21')"); + $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'eo', 'epo')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'eo', 'language', 'en', 'Esperanto')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'eo', 'language', 'eo', 'Esperanto')"); + # Estonian + $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'et', 'language', 'Estonian', '2017-04-21')"); + $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'et', 'est')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'et', 'language', 'et', 'Eesti')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'et', 'language', 'en', 'Estonian')"); + # Irish Gaelic + $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'ga', 'language', 'Irish', '2017-04-21')"); + $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'ga', 'gle')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ga', 'language', 'en', 'Irish')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ga', 'language', 'ga', 'Gaeilge')"); + # Scottish Gaelic + $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'gd', 'language', 'Scottish Gaelic', '2017-04-21')"); + $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'gd', 'gla')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'gd', 'language', 'en', 'Scottish Gaelic')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'gd', 'language', 'gd', 'Gàidhlig')"); + # Ancient Greek + $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'grc', 'language', 'Greek, Ancient', '2017-04-21')"); + $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'grc', 'grc')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'grc', 'language', 'en', 'Greek, Ancient')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'grc', 'language', 'grc', 'Ἑλληνική')"); + # Kazakh + $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'kk', 'language', 'Kazakh', '2017-04-21')"); + $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'kk', 'kaz')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'kk', 'language', 'en', 'Kazakh')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'kk', 'language', 'kk', 'қазақ тілі')"); + # Greenlandic + $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'kl', 'language', 'Greenlandic', '2017-04-21')"); + $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'kl', 'kal')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'kl', 'language', 'en', 'Greenlandic')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'kl', 'language', 'kl', 'Kalaallisut')"); + # Karelian + $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'krl', 'language', 'Karelian', '2017-04-21')"); + $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'krl', 'krl')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'krl', 'language', 'en', 'Karelian')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'krl', 'language', 'krl', 'Karjala')"); + # Cornish + $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'kw', 'language', 'Cornish', '2017-04-21')"); + $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'kw', 'cor')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'kw', 'language', 'en', 'Cornish')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'kw', 'language', 'kw', 'Kernowek')"); + # Lithuanian + $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'lt', 'language', 'Lithuanian', '2017-04-21')"); + $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'lt', 'lit')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'lt', 'language', 'en', 'Lithuanian')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'lt', 'language', 'lt', 'lietuvių kalba')"); + # Latvian + $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'lv', 'language', 'Latvian', '2017-04-21')"); + $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'lv', 'lav')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'lv', 'language', 'en', 'Latvian')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'lv', 'language', 'lv', 'Latviešu valoda')"); + # Burmese + $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'my', 'language', 'Burmese', '2017-04-21')"); + $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'my', 'bur')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'my', 'language', 'en', 'Burmese')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'my', 'language', 'my', 'မြန်မာစာ')"); + # Punjabi + $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'pa', 'language', 'Punjabi', '2017-04-21')"); + $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'pa', 'pan')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'pa', 'language', 'en', 'Punjabi')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'pa', 'language', 'pa', 'پنجابی')"); + # Pashto + $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'ps', 'language', 'Pashto', '2017-04-21')"); + $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'ps', 'pus')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ps', 'language', 'en', 'Pashto')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ps', 'language', 'ps', 'پښتو')"); + # Finnish Kalo + $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES( 'rmf', 'rmf')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'rmf', 'language', 'en', 'Finnish Kalo')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'rmf', 'language', 'fi', 'Suomen romanikieli')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'rmf', 'language', 'rmf', 'Fíntika Rómma')"); + # Sanskrit + $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sa', 'language', 'Sanskrit', '2017-04-21')"); + $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sa', 'san')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sa', 'language', 'en', 'Sanskrit')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sa', 'language', 'sa', 'saṃskṛtam')"); + # Akkala Sami + $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sia', 'language', 'Akkala Sami', '2017-04-21')"); + $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sia', 'sia')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sia', 'language', 'en', 'Akkala Sami')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sia', 'language', 'sia', 'ču´kksuâlis')"); + # Kildin Sami + $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sjd', 'language', 'Kildin Sami', '2017-04-21')"); + $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sjd', 'sjd')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sjd', 'language', 'en', 'Kildin Sami')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sjd', 'language', 'sjd', 'Кӣллт са̄мь кӣлл')"); + # Ter Sami + $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sjt', 'language', 'Ter Sami', '2017-04-21')"); + $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sjt', 'sjt')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sjt', 'language', 'en', 'Ter Sami')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sjt', 'language', 'sjt', 'saa´mekiill')"); + # Pite Sami + $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sje', 'language', 'Pite Sami', '2017-04-21')"); + $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sje', 'sje')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sje', 'language', 'en', 'Pite Sami')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sje', 'language', 'sje', 'Bidumsámegiella')"); + # Kemi Sami + $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sjk', 'language', 'Kemi Sami', '2017-04-21')"); + $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sjk', 'sjk')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sjk', 'language', 'en', 'Kemi Sami')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sjk', 'language', 'sjk', 'samääškiela')"); + # Ume Sami + $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sju', 'language', 'Ume Sami', '2017-04-21')"); + $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sju', 'sju')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sju', 'language', 'en', 'Ume Sami')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sju', 'language', 'sju', 'Ubmejensámien giella')"); + # Southern Sami + $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sma', 'language', 'Southern Sami', '2017-04-21')"); + $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sma', 'sma')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sma', 'language', 'en', 'Southern Sami')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sma', 'language', 'sma', 'Åarjelsaemien gïele')"); + # Northern Sami + $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sme', 'language', 'Northern Sami', '2017-04-21')"); + $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sme', 'sme')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sme', 'language', 'en', 'Northern Sami')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sme', 'language', 'fi', 'pohjoissaame')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sme', 'language', 'sv', 'Nordsamiska')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sme', 'language', 'sme', 'davvisámegiella')"); + # Sami languages + $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'smi', 'language', 'Sami languages', '2017-04-21')"); + $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'smi', 'smi')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'smi', 'language', 'en', 'Sami languages')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'smi', 'language', 'fi', 'saamelaiskielet')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'smi', 'language', 'sv', 'Samiska')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'smi', 'language', 'smi', 'Saami')"); + # Lule Sami + $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'smj', 'language', 'Lule Sami', '2017-04-21')"); + $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'smj', 'smj')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'smj', 'language', 'en', 'Lule Sami')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'smj', 'language', 'smj', 'julevsámegiella')"); + # Inari Sami + $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'smn', 'language', 'Inari Sami', '2017-04-21')"); + $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'smn', 'smn')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'smn', 'language', 'en', 'Inari Sami')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'smn', 'language', 'smn', 'anarâškielâ')"); + # Skolt Sami + $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sms', 'language', 'Skolt Sami', '2017-04-21')"); + $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sms', 'sms')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sms', 'language', 'en', 'Skolt Sami')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sms', 'language', 'sms', 'sääʹmǩiõll')"); + # Somali + $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'so', 'language', 'Somali', '2017-04-21')"); + $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'so', 'som')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'so', 'language', 'en', 'Somali')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'so', 'language', 'so', 'Af-Soomaali')"); + # Sotho + $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'st', 'language', 'Sotho', '2017-04-21')"); + $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'st', 'sot')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'st', 'language', 'en', 'Sotho')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'st', 'language', 'st', 'Sesotho')"); + # Votic + $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'vot', 'language', 'Votic', '2017-04-21')"); + $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'vot', 'vot')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'vot', 'language', 'en', 'Votic')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'vot', 'language', 'vot', 'vađđa ceeli')"); + # Yiddish + $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'yi', 'language', 'Yiddish', '2017-04-21')"); + $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'yi', 'yid')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'yi', 'language', 'en', 'Yiddish')"); + $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'yi', 'language', 'yi', 'יידיש')"); + + # Always end with this (adjust the bug info) + SetVersion( $DBversion ); + print "Upgrade to $DBversion done (Bug XXXXX - description)\n"; +} diff --git a/installer/data/mysql/mandatory/subtag_registry.sql b/installer/data/mysql/mandatory/subtag_registry.sql index 671c08bff3..f6ce2f688a 100644 --- a/installer/data/mysql/mandatory/subtag_registry.sql +++ b/installer/data/mysql/mandatory/subtag_registry.sql @@ -693,6 +693,19 @@ VALUES ( 'ka', 'language', 'es', 'Georgiano'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ka', 'language', 'pl', 'Gruziński'); +-- Greenlandic +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'kl', 'language', 'Greenlandic', '2017-04-21'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES ( 'kl', 'kal'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'kl', 'language', 'en', 'Greenlandic'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'kl', 'language', 'kl', 'Kalaallisut'); + -- Kannada INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'kn', 'language', 'Kannada','2014-10-30'); @@ -750,6 +763,19 @@ VALUES ( 'ko', 'language', 'de', 'Koreanisch'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ko', 'language', 'pl', 'Koreański'); +-- Karelian +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'krl', 'language', 'Karelian', '2017-04-21'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES ( 'krl', 'krl'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'krl', 'language', 'en', 'Karelian'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'krl', 'language', 'krl', 'Karjala'); + -- Kurdish INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'ku', 'language', 'Kurdish','2014-05-13'); @@ -775,6 +801,19 @@ VALUES ( 'ku', 'language', 'es', 'Kurdo'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ku', 'language', 'pl', 'Kurdyjski'); +-- Cornish +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'kw', 'language', 'Cornish', '2017-04-21'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES ( 'kw', 'cor'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'kw', 'language', 'en', 'Cornish'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'kw', 'language', 'kw', 'Kernowek'); + -- Latin INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'la', 'language', 'Latin','2005-10-16' ); @@ -895,6 +934,19 @@ VALUES ( 'ms', 'language', 'de', 'Malaiisch'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ms', 'language', 'pl', 'Malajski'); +-- Burmese +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'my', 'language', 'Burmese', '2017-04-21'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES ( 'my', 'bur'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'my', 'language', 'en', 'Burmese'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'my', 'language', 'my', 'မြန်မာစာ'); + -- Norwegian (bokmål) INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'nb', 'language', 'Norwegian bokmål','2005-10-16' ); @@ -983,6 +1035,19 @@ VALUES ( 'nn', 'language', 'de', 'Norwegisch nynorsk'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'nn', 'language', 'pl', 'Norweski nynorsk'); +-- Punjabi +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'pa', 'language', 'Punjabi', '2017-04-21'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES ( 'pa', 'pan'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'pa', 'language', 'en', 'Punjabi'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'pa', 'language', 'pa', 'پنجابی'); + -- Pangwa INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'pbr', 'language', 'Pangwa','2014-10-30'); @@ -1034,6 +1099,19 @@ VALUES ( 'prs', 'language', 'en', 'Dari'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'prs', 'language', 'de', 'Dari'); +-- Pashto +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'ps', 'language', 'Pashto', '2017-04-21'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES ( 'ps', 'pus'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'ps', 'language', 'en', 'Pashto'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'ps', 'language', 'ps', 'پښتو'); + -- Portuguese INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'pt', 'language', 'Portuguese','2005-10-16' ); @@ -1056,6 +1134,19 @@ VALUES ( 'pt', 'language', 'de', 'Portugiesisch'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'pt', 'language', 'pl', 'Portugalski'); +-- Finnish Kalo +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'rmf', 'rmf'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'rmf', 'language', 'en', 'Finnish Kalo'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'rmf', 'language', 'fi', 'Suomen romanikieli'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'rmf', 'language', 'rmf', 'Fíntika Rómma'); + -- Romanian INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'ro', 'language', 'Romanian','2005-10-16' ); @@ -1176,6 +1267,187 @@ VALUES ( 'sl', 'language', 'de', 'Slowenisch'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sl', 'language', 'pl', 'Słoweński'); +-- Akkala Sami +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'sia', 'language', 'Akkala Sami', '2017-04-21'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES ( 'sia', 'sia'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'sia', 'language', 'en', 'Akkala Sami'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'sia', 'language', 'sia', 'ču´kksuâlis'); + +-- Kildin Sami +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'sjd', 'language', 'Kildin Sami', '2017-04-21'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES ( 'sjd', 'sjd'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'sjd', 'language', 'en', 'Kildin Sami'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'sjd', 'language', 'sjd', 'Кӣллт са̄мь кӣлл'); + +-- Ter Sami +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'sjt', 'language', 'Ter Sami', '2017-04-21'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES ( 'sjt', 'sjt'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'sjt', 'language', 'en', 'Ter Sami'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'sjt', 'language', 'sjt', 'saa´mekiill'); + +-- Pite Sami +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'sje', 'language', 'Pite Sami', '2017-04-21'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES ( 'sje', 'sje'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'sje', 'language', 'en', 'Pite Sami'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'sje', 'language', 'sje', 'Bidumsámegiella'); + +-- Kemi Sami +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'sjk', 'language', 'Kemi Sami', '2017-04-21'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES ( 'sjk', 'sjk'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'sjk', 'language', 'en', 'Kemi Sami'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'sjk', 'language', 'sjk', 'samääškiela'); + +-- Ume Sami +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'sju', 'language', 'Ume Sami', '2017-04-21'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES ( 'sju', 'sju'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'sju', 'language', 'en', 'Ume Sami'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'sju', 'language', 'sju', 'Ubmejensámien giella'); + +-- Southern Sami +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'sma', 'language', 'Southern Sami', '2017-04-21'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES ( 'sma', 'sma'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'sma', 'language', 'en', 'Southern Sami'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'sma', 'language', 'sma', 'Åarjelsaemien gïele'); + +-- Northern Sami +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'sme', 'language', 'Northern Sami', '2017-04-21'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES ( 'sme', 'sme'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'sme', 'language', 'en', 'Northern Sami'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'sme', 'language', 'fi', 'pohjoissaame'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'sme', 'language', 'sv', 'Nordsamiska'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'sme', 'language', 'sme', 'davvisámegiella'); + +-- Sami languages +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'smi', 'language', 'Sami languages', '2017-04-21'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES ( 'smi', 'smi'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'smi', 'language', 'en', 'Sami languages'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'smi', 'language', 'fi', 'saamelaiskielet'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'smi', 'language', 'sv', 'Samiska'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'smi', 'language', 'smi', 'Saami'); + +-- Lule Sami +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'smj', 'language', 'Lule Sami', '2017-04-21'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES ( 'smj', 'smj'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'smj', 'language', 'en', 'Lule Sami'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'smj', 'language', 'smj', 'julevsámegiella'); + +-- Inari Sami +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'smn', 'language', 'Inari Sami', '2017-04-21'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES ( 'smn', 'smn'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'smn', 'language', 'en', 'Inari Sami'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'smn', 'language', 'smn', 'anarâškielâ'); + +-- Skolt Sami +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'sms', 'language', 'Skolt Sami', '2017-04-21'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES ( 'sms', 'sms'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'sms', 'language', 'en', 'Skolt Sami'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'sms', 'language', 'sms', 'sääʹmǩiõll'); + +-- Somali +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'so', 'language', 'Somali', '2017-04-21'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES ( 'so', 'som'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'so', 'language', 'en', 'Somali'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'so', 'language', 'so', 'Af-Soomaali'); + -- Albanian INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sq', 'language', 'Albanian','2014-10-30'); @@ -1217,6 +1489,19 @@ VALUES ( 'sr', 'language', 'de', 'Serbisch'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sr', 'language', 'pl', 'Serbski'); +-- Sotho +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'st', 'language', 'Sotho', '2017-04-21'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES ( 'st', 'sot'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'st', 'language', 'en', 'Sotho'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'st', 'language', 'st', 'Sesotho'); + -- Swedish INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sv', 'language', 'Swedish','2005-10-16' ); @@ -1425,6 +1710,19 @@ VALUES ( 'vi', 'language', 'de', 'Vietnamesisch'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'vi', 'language', 'pl', 'Wietnamski'); +-- Votic +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'vot', 'language', 'Votic', '2017-04-21'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES ( 'vot', 'vot'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'vot', 'language', 'en', 'Votic'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'vot', 'language', 'vot', 'vađđa ceeli'); + -- Chinese INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'zh', 'language', 'Chinese','2005-10-16'); @@ -2116,7 +2414,7 @@ INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('et', 'language', 'de', 'Estnisch'); INSERT INTO language_subtag_registry (subtag, type, description, added) -VALUES ('et', 'language', 'Estonian', now()); +VALUES ('et', 'language', 'Estonian', NOW() ); INSERT INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) VALUES ('et', 'est'); @@ -2126,8 +2424,8 @@ 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_descriptionsn (subtag, type, lang, description) +VALUES ( 'lv', 'language', 'lv', 'Latviešu valoda'); INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('lv', 'language', 'de', 'Lettisch'); @@ -2138,13 +2436,13 @@ VALUES ('lv', 'language', 'Latvian', now()); INSERT INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) VALUES ('lv', 'lav'); --- Lithianian +-- Lithuanian 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ų'); +VALUES ('lt', 'language', 'lt', 'Lietuvių kalba'); INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('lt', 'language', 'de', 'Litauisch'); @@ -2195,22 +2493,22 @@ INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'yi', 'language', 'Yiddish', NOW() ); INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES ( 'yi','yid'); +VALUES ( 'yi', 'yid'); INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'yi', 'language', 'de', 'Jiddisch'); +VALUES ( 'yi', 'language', 'en', 'Yiddish'); INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'yi', 'language', 'en', 'Yiddish'); +VALUES ( 'yi', 'language', 'yi', 'יידיש'); INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'yi', 'language', 'es', 'Yidis'); +VALUES ( 'yi', 'language', 'de', 'Jiddisch'); INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'yi', 'language', 'fr', 'Yiddish'); +VALUES ( 'yi', 'language', 'es', 'Yidis'); INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'yi', 'language', 'yi', 'יידיש'); +VALUES ( 'yi', 'language', 'fr', 'Yiddish'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'yi', 'language', 'pl', 'Jidysz'); @@ -2327,7 +2625,10 @@ INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'grc','grc'); INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'grc', 'language', 'en', 'Greek, Ancient (to 1453)'); +VALUES ( 'grc', 'language', 'en', 'Ancient Greek (to 1453)'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'grc', 'language', 'grc', 'Ἑλληνική'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'grc', 'language', 'pl', 'Grecki starożytny (do 1453)'); @@ -2403,7 +2704,6 @@ INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ang', 'language', 'pl', 'Staroangielski (ok. 450-1100)'); -- Esperanto - INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'eo', 'language', 'Esperanto', NOW() ); @@ -2413,6 +2713,9 @@ VALUES ( 'eo','epo'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'eo', 'language', 'en', 'Esperanto'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'eo', 'language', 'eo', 'Esperanto'); + INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'eo', 'language', 'pl', 'Esperanto'); @@ -2459,16 +2762,18 @@ INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sla', 'language', 'pl', 'Słowiańskie (inne)'); -- Sanskrit - INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sa', 'language', 'Sanskrit', NOW() ); INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES ( 'sa','san'); +VALUES ( 'sa', 'san'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sa', 'language', 'en', 'Sanskrit'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'sa', 'language', 'sa', 'saṃskṛtam'); + INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sa', 'language', 'pl', 'Sanskryt'); @@ -2542,8 +2847,7 @@ VALUES ( 'wen', 'language', 'en', 'Sorbian (Other)'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'wen', 'language', 'pl', 'Łużyckie (inne)'); --- Irish - +-- Irish Gaelic INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'ga', 'language', 'Irish', NOW() ); @@ -2553,6 +2857,9 @@ VALUES ( 'ga','gle'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ga', 'language', 'en', 'Irish'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'ga', 'language', 'ga', 'Gaeilge'); + INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ga', 'language', 'pl', 'Irlandzki'); @@ -2685,7 +2992,7 @@ VALUES ( 'pi', 'language', 'pl', 'Pali'); -- Bosnian INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'bs', 'language', 'Bosnian', NOW() ); +VALUES ( 'bs', 'language', 'Bosnian', '2017-04-21'); INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'bs','bos'); @@ -2693,6 +3000,9 @@ VALUES ( 'bs','bos'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'bs', 'language', 'en', 'Bosnian'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'bs', 'language', 'bn', 'Bosanski'); + INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'bs', 'language', 'pl', 'Bośniacki'); @@ -2736,18 +3046,23 @@ INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'kk', 'language', 'en', 'Kazakh'); INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'kk', 'language', 'pl', 'Kazachski'); +VALUES ( 'kk', 'language', 'kk', 'қазақ тілі'); --- Tibetan +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'kk', 'language', 'pl', 'Kazachski'); +-- Standard Tibetan INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'bo', 'language', 'Tibetan', NOW() ); +VALUES ( 'bo', 'language', 'Standard Tibetan', '2017-04-21'); INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'bo','tib'); INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'bo', 'language', 'en', 'Tibetan'); +VALUES ( 'bo', 'language', 'en', 'Standard Tibetan'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'bo', 'language', 'bo', 'ལྷ་སའི་སྐད་'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'bo', 'language', 'pl', 'Tybetański'); @@ -3184,7 +3499,6 @@ INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'tt', 'language', 'pl', 'Tatarski'); -- Welsh - INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'cy', 'language', 'Welsh', NOW() ); @@ -3194,6 +3508,9 @@ VALUES ( 'cy','wel'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'cy', 'language', 'en', 'Welsh'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'cy', 'language', 'cy', 'Cymraeg'); + INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'cy', 'language', 'pl', 'Walijski'); -- 2.39.5