From 33d453ca730c69f33c0e8e8e8579cfab6fc9a629 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=utf-8 Content-Transfer-Encoding: 8bit Content-Type: text/plain; charset=utf-8 This patch adds the following languages into advanced search "Languages" dropdown: Bosnian Welsh Esperanto Estonian Irish Gaelic Scottish Gaelic Ancient Greek Kazakh Greenlandic Karelian Cornish Lithuanian Latvian Burmese Punjabi Pashto Finnish Kalo Sanskrit 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 Yiddish 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. --- .../Bug-18493-Add-new-searchable-languages.perl | 187 +++++++++ installer/data/mysql/mandatory/subtag_registry.sql | 467 +++++++++++++++++++++ 2 files changed, 654 insertions(+) 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 0000000..a6e27b8 --- /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 e21577a..346eae1 100755 --- a/installer/data/mysql/mandatory/subtag_registry.sql +++ b/installer/data/mysql/mandatory/subtag_registry.sql @@ -146,6 +146,32 @@ VALUES ( 'bg', 'language', 'fr', 'Bulgare'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'bg', 'language', 'de', 'Bulgarisch'); +-- Standard Tibetan +INSERT INTO language_subtag_registry( subtag, type, description, added) +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', 'Standard Tibetan'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'bo', 'language', 'bo', 'ལྷ་སའི་སྐད་'); + +-- Bosnian +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'bs', 'language', 'Bosnian', '2017-04-21'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +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'); + -- Catalan INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'ca', 'language', 'Catalan','2013-01-12' ); @@ -187,6 +213,19 @@ VALUES ( 'cs', 'language', 'fr', 'Tchèque'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'cs', 'language', 'de', 'Tschechisch'); +-- Welsh +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'cy', 'language', 'Welsh', '2017-04-21'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +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'); + -- Danish INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'da', 'language', 'Danish','2005-10-16' ); @@ -257,6 +296,19 @@ VALUES ( 'en', 'language', 'fr', 'Anglais'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'en', 'language', 'de', 'Englisch'); +-- Esperanto +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'eo', 'language', 'Esperanto', '2017-04-21'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +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'); + -- Spanish, Castilian INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'es', 'language', 'Spanish','2005-10-16' ); @@ -276,6 +328,19 @@ VALUES ( 'es', 'language', 'fr', 'Espagnol'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'es', 'language', 'de', 'Spanisch'); +-- Estonian +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'et', 'language', 'Estonian', '2017-04-21'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES ( 'et', 'est'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'et', 'language', 'et', 'Eesti'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'et', 'language', 'en', 'Estonian'); + -- Basque INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'eu', 'language', 'Basque','2014-10-30'); @@ -353,6 +418,32 @@ VALUES ( 'fr', 'language', 'fr', 'Français'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'fr', 'language', 'de', 'Französisch'); +-- Irish Gaelic +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'ga', 'language', 'Irish', '2017-04-21'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +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'); + +-- Scottish Gaelic +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'gd', 'language', 'Scottish Gaelic', '2017-04-21'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES ( 'gd', 'gla'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'gd', 'language', 'en', 'Scottish Gaelic'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'gd', 'language', 'gd', 'Gàidhlig'); + -- Galician INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'gl', 'language', 'Galician','2005-10-16' ); @@ -372,6 +463,19 @@ VALUES ( 'gl', 'language', 'fr', 'Galicien'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'gl', 'language', 'de', 'Galicisch'); +-- Ancient Greek +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'grc', 'language', 'Greek, Ancient', '2017-04-21'); + +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'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'grc', 'language', 'grc', 'Ἑλληνική'); + -- Hebrew INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'he', 'language', 'Hebrew','2005-10-16'); @@ -559,6 +663,32 @@ VALUES ( 'ka', 'language', 'de', 'Georgisch'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ka', 'language', 'es', 'Georgiano'); +-- Kazakh +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'kk', 'language', 'Kazakh', '2017-04-21'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES ( 'kk', 'kaz'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'kk', 'language', 'en', 'Kazakh'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'kk', 'language', 'kk', 'қазақ тілі'); + +-- 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'); @@ -604,6 +734,19 @@ VALUES ( 'ko', 'language', 'fr', 'Coréen'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ko', 'language', 'de', 'Koreanisch'); +-- 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'); @@ -626,6 +769,19 @@ VALUES ( 'ku', 'language', 'de', 'Kurdisch'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ku', 'language', 'es', 'Kurdo'); +-- 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' ); @@ -664,6 +820,32 @@ VALUES ( 'lo', 'language', 'fr', 'Laotien'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'lo', 'language', 'de', 'Laotisch'); +-- Lithuanian +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'lt', 'language', 'Lithuanian', '2017-04-21'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES ( 'lt', 'lit'); + +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ų kalba'); + +-- Latvian +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'lv', 'language', 'Latvian', '2017-04-21'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES ( 'lv', 'lav'); + +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', 'Latviešu valoda'); + -- Maori INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'mi', 'language', 'Maori','2014-10-30'); @@ -716,6 +898,19 @@ VALUES ( 'ms', 'language', 'ms', 'Bahasa melayu'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ms', 'language', 'en', 'Malay'); +-- 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' ); @@ -789,6 +984,19 @@ VALUES ( 'nn', 'language', 'fr', 'Norvégien nynorsk'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'nn', 'language', 'de', 'Norwegisch 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'); @@ -834,6 +1042,19 @@ VALUES ( 'prs', 'language', 'prs', 'درى'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'prs', 'language', 'en', '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' ); @@ -853,6 +1074,19 @@ VALUES ( 'pt', 'language', 'fr', 'Portugais'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'pt', 'language', 'de', 'Portugiesisch'); +-- 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' ); @@ -904,6 +1138,19 @@ VALUES ( 'rw', 'language', 'rw', 'Ikinyarwanda'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'rw', 'language', 'en', 'Kinyarwanda'); +-- Sanskrit +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'sa', 'language', 'Sanskrit', '2017-04-21'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +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'); + -- Sindhi INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sd', 'language', 'Sindhi','2014-10-30'); @@ -943,6 +1190,187 @@ VALUES ( 'sl', 'language', 'sl', 'Slovenščina'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sl', 'language', 'en', 'Slovene'); +-- 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'); @@ -975,6 +1403,19 @@ VALUES ( 'sr', 'language', 'fr', 'Serbe'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sr', 'language', 'de', 'Serbisch'); +-- 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' ); @@ -1141,6 +1582,32 @@ VALUES ( 'vi', 'language', 'vi', '㗂越'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'vi', 'language', 'en', 'Vietnamese'); +-- 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'); + +-- Yiddish +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'yi', 'language', 'Yiddish', '2017-04-21'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES ( 'yi', 'yid'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'yi', 'language', 'en', 'Yiddish'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'yi', 'language', 'yi', 'יידיש'); + -- Chinese INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'zh', 'language', 'Chinese','2005-10-16'); -- 2.1.4