Bugzilla – Attachment 167122 Details for
Bug 18493
Many languages are missing from the advanced search languages dropdown
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 18493: Add new searchable languages
Bug-18493-Add-new-searchable-languages.patch (text/plain), 43.15 KB, created by
Martin Renvoize (ashimema)
on 2024-05-23 16:32:03 UTC
(
hide
)
Description:
Bug 18493: Add new searchable languages
Filename:
MIME Type:
Creator:
Martin Renvoize (ashimema)
Created:
2024-05-23 16:32:03 UTC
Size:
43.15 KB
patch
obsolete
>From 898df2a9f1eb2a8cb9e999cfa94191186f1f50f3 Mon Sep 17 00:00:00 2001 >From: Lari Taskula <lari.taskula@jns.fi> >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 > >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 <veron@veron.ch> >Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> >Just noting that the order in this dropdown is hopeless. >Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com> >--- > ...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 00000000000..a6e27b84784 >--- /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 671c08bff3c..f6ce2f688ac 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.45.1
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 18493
:
62678
|
62679
|
63265
|
66688
| 167122 |
167123
|
167626