Bugzilla – Attachment 167123 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: Modernise DB update
Bug-18493-Modernise-DB-update.patch (text/plain), 46.70 KB, created by
Martin Renvoize (ashimema)
on 2024-05-23 16:32:07 UTC
(
hide
)
Description:
Bug 18493: Modernise DB update
Filename:
MIME Type:
Creator:
Martin Renvoize (ashimema)
Created:
2024-05-23 16:32:07 UTC
Size:
46.70 KB
patch
obsolete
>From b252d89c971ed334119f4c36a20b192ae0d5b988 Mon Sep 17 00:00:00 2001 >From: Martin Renvoize <martin.renvoize@ptfs-europe.com> >Date: Thu, 23 May 2024 15:21:22 +0100 >Subject: [PATCH] Bug 18493: Modernise DB update > >Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com> >--- > ...ug-18493-Add-new-searchable-languages.perl | 187 -------- > .../data/mysql/atomicupdate/bug_18493.pl | 427 ++++++++++++++++++ > 2 files changed, 427 insertions(+), 187 deletions(-) > delete mode 100644 installer/data/mysql/atomicupdate/Bug-18493-Add-new-searchable-languages.perl > create mode 100755 installer/data/mysql/atomicupdate/bug_18493.pl > >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 >deleted file mode 100644 >index a6e27b84784..00000000000 >--- a/installer/data/mysql/atomicupdate/Bug-18493-Add-new-searchable-languages.perl >+++ /dev/null >@@ -1,187 +0,0 @@ >-$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/atomicupdate/bug_18493.pl b/installer/data/mysql/atomicupdate/bug_18493.pl >new file mode 100755 >index 00000000000..31f311a8dc9 >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_18493.pl >@@ -0,0 +1,427 @@ >+use Modern::Perl; >+use Koha::Installer::Output qw(say_warning say_failure say_success say_info); >+ >+return { >+ bug_number => "18493", >+ description => "Add missing languages to search options", >+ up => sub { >+ my ($args) = @_; >+ my ( $dbh, $out ) = @$args{qw(dbh out)}; >+ >+ # Greenlandic >+ $dbh->do( >+ q{INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'kl', 'language', 'Greenlandic', 'NOW()')} >+ ) == 1 >+ && say_success( $out, "Added language_subtag_registry for Greenlandic" ); >+ $dbh->do(q{INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'kl', 'kal')}) >+ == 1 && say_success( $out, "Added language_rfc4646_to_iso639 for Greenlandic" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'kl', 'language', 'en', 'Greenlandic')} >+ ) == 1 >+ && say_success( $out, "Added english language description for Greenlandic" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'kl', 'language', 'kl', 'Kalaallisut')} >+ ) == 1 >+ && say_success( $out, "Added native language description for Greenlandic" ); >+ >+ # Karelian >+ $dbh->do( >+ q{INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'krl', 'language', 'Karelian', 'NOW()')} >+ ) == 1 >+ && say_success( $out, "Added language_subtag_registry for Karelian" ); >+ $dbh->do(q{INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'krl', 'krl')}) >+ == 1 && say_success( $out, "Added language_rfc4646_to_iso639 for Karelian" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'krl', 'language', 'en', 'Karelian')} >+ ) == 1 >+ && say_success( $out, "Added english language description for Karelian" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'krl', 'language', 'krl', 'Karjala')} >+ ) == 1 >+ && say_success( $out, "Added native language description for Karelian" ); >+ >+ # Cornish >+ $dbh->do( >+ q{INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'kw', 'language', 'Cornish', 'NOW()')} >+ ) == 1 >+ && say_success( $out, "Added language_subtag_registry for Cornish" ); >+ $dbh->do(q{INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'kw', 'cor')}) >+ == 1 && say_success( $out, "Added language_rfc4646_to_iso639 for Cornish" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'kw', 'language', 'en', 'Cornish')} >+ ) == 1 >+ && say_success( $out, "Added english language description for Cornish" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'kw', 'language', 'kw', 'Kernowek')} >+ ) == 1 >+ && say_success( $out, "Added native language description for Cornish" ); >+ >+ # Burmese >+ $dbh->do( >+ q{INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'my', 'language', 'Burmese', 'NOW()')} >+ ) == 1 >+ && say_success( $out, "Added language_subtag_registry for Burmese" ); >+ $dbh->do(q{INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'my', 'bur')}) >+ == 1 && say_success( $out, "Added language_rfc4646_to_iso639 for Burmese" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'my', 'language', 'en', 'Burmese')} >+ ) == 1 >+ && say_success( $out, "Added english language description for Burmese" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'my', 'language', 'my', 'áá¼ááºáá¬áá¬')} >+ ) == 1 >+ && say_success( $out, "Added native language description for Burmese" ); >+ >+ # Punjabi >+ $dbh->do( >+ q{INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'pa', 'language', 'Punjabi', 'NOW()')} >+ ) == 1 >+ && say_success( $out, "Added language_subtag_registry for Punjabi" ); >+ $dbh->do(q{INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'pa', 'pan')}) >+ == 1 && say_success( $out, "Added language_rfc4646_to_iso639 for Punjabi" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'pa', 'language', 'en', 'Punjabi')} >+ ) == 1 >+ && say_success( $out, "Added english language description for Punjabi" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'pa', 'language', 'pa', 'Ù¾ÙجابÛ')} >+ ) == 1 >+ && say_success( $out, "Added native language description for Punjabi" ); >+ >+ # Pashto >+ $dbh->do( >+ q{INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'ps', 'language', 'Pashto', 'NOW()')} >+ ) == 1 >+ && say_success( $out, "Added language_subtag_registry for Pashto" ); >+ $dbh->do(q{INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'ps', 'pus')}) >+ == 1 && say_success( $out, "Added language_rfc4646_to_iso639 for Pashto" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ps', 'language', 'en', 'Pashto')} >+ ) == 1 >+ && say_success( $out, "Added english language description for Pashto" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ps', 'language', 'ps', 'Ù¾ÚتÙ')} >+ ) == 1 >+ && say_success( $out, "Added native language description for Pashto" ); >+ >+ # Finnish Kalo >+ $dbh->do(q{INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES( 'rmf', 'rmf')}) >+ == 1 && say_success( $out, "Added language_rfc4646_to_iso639 for Finnish Kalo" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES( 'rmf', 'language', 'en', 'Finnish Kalo')} >+ ) == 1 >+ && say_success( $out, "Added english language description for Finnish Kalo" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES( 'rmf', 'language', 'fi', 'Suomen romanikieli')} >+ ) == 1 >+ && say_success( $out, "Added native language description for Finnish Kalo" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES( 'rmf', 'language', 'rmf', 'FÃntika Rómma')} >+ ) == 1 >+ && say_success( $out, "Added native language description for Finnish Kalo" ); >+ >+ # Akkala Sami >+ $dbh->do( >+ q{INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sia', 'language', 'Akkala Sami', 'NOW()')} >+ ) == 1 >+ && say_success( $out, "Added language_subtag_registry for Akkala Sami" ); >+ $dbh->do(q{INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sia', 'sia')}) >+ == 1 && say_success( $out, "Added language_rfc4646_to_iso639 for Akkala Sami" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sia', 'language', 'en', 'Akkala Sami')} >+ ) == 1 >+ && say_success( $out, "Added english language description for Akkala Sami" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sia', 'language', 'sia', 'Äu´kksuâlis')} >+ ) == 1 >+ && say_success( $out, "Added native language description for Akkala Sami" ); >+ >+ # Kildin Sami >+ $dbh->do( >+ q{INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sjd', 'language', 'Kildin Sami', 'NOW()')} >+ ) == 1 >+ && say_success( $out, "Added language_subtag_registry for Kildin Sami" ); >+ $dbh->do(q{INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sjd', 'sjd')}) >+ == 1 && say_success( $out, "Added language_rfc4646_to_iso639 for Kildin Sami" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sjd', 'language', 'en', 'Kildin Sami')} >+ ) == 1 >+ && say_success( $out, "Added english language description for Kildin Sami" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sjd', 'language', 'sjd', 'ÐÓ£Ð»Ð»Ñ ÑаÌÐ¼Ñ ÐºÓ£Ð»Ð»')} >+ ) == 1 >+ && say_success( $out, "Added native language description for Kildin Sami" ); >+ >+ # Ter Sami >+ $dbh->do( >+ q{INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sjt', 'language', 'Ter Sami', 'NOW()')} >+ ) == 1 >+ && say_success( $out, "Added language_subtag_registry for Ter Sami" ); >+ $dbh->do(q{INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sjt', 'sjt')}) >+ == 1 && say_success( $out, "Added language_rfc4646_to_iso639 for Ter Sami" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sjt', 'language', 'en', 'Ter Sami')} >+ ) == 1 >+ && say_success( $out, "Added english language description for Ter Sami" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sjt', 'language', 'sjt', 'saa´mekiill')} >+ ) == 1 >+ && say_success( $out, "Added native language description for Ter Sami" ); >+ >+ # Pite Sami >+ $dbh->do( >+ q{INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sje', 'language', 'Pite Sami', 'NOW()')} >+ ) == 1 >+ && say_success( $out, "Added language_subtag_registry for Pite Sami" ); >+ $dbh->do(q{INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sje', 'sje')}) >+ == 1 && say_success( $out, "Added language_rfc4646_to_iso639 for Pite Sami" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sje', 'language', 'en', 'Pite Sami')} >+ ) == 1 >+ && say_success( $out, "Added english language description for Pite Sami" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sje', 'language', 'sje', 'Bidumsámegiella')} >+ ) == 1 >+ && say_success( $out, "Added native language description for Pite Sami" ); >+ >+ # Kemi Sami >+ $dbh->do( >+ q{INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sjk', 'language', 'Kemi Sami', 'NOW()')} >+ ) == 1 >+ && say_success( $out, "Added language_subtag_registry for Kemi Sami" ); >+ $dbh->do(q{INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sjk', 'sjk')}) >+ == 1 && say_success( $out, "Added language_rfc4646_to_iso639 for Kemi Sami" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sjk', 'language', 'en', 'Kemi Sami')} >+ ) == 1 >+ && say_success( $out, "Added english language description for Kemi Sami" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sjk', 'language', 'sjk', 'samääškiela')} >+ ) == 1 >+ && say_success( $out, "Added native language description for Kemi Sami" ); >+ >+ # Ume Sami >+ $dbh->do( >+ q{INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sju', 'language', 'Ume Sami', 'NOW()')} >+ ) == 1 >+ && say_success( $out, "Added language_subtag_registry for Ume Sami" ); >+ $dbh->do(q{INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sju', 'sju')}) >+ == 1 && say_success( $out, "Added language_rfc4646_to_iso639 for Ume Sami" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sju', 'language', 'en', 'Ume Sami')} >+ ) == 1 >+ && say_success( $out, "Added english language description for Ume Sami" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sju', 'language', 'sju', 'Ubmejensámien giella')} >+ ) == 1 >+ && say_success( $out, "Added native language description for Ume Sami" ); >+ >+ # Southern Sami >+ $dbh->do( >+ q{INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sma', 'language', 'Southern Sami', 'NOW()')} >+ ) == 1 >+ && say_success( $out, "Added language_subtag_registry for Southern Sami" ); >+ $dbh->do(q{INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sma', 'sma')}) >+ == 1 && say_success( $out, "Added language_rfc4646_to_iso639 for Southern Sami" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sma', 'language', 'en', 'Southern Sami')} >+ ) == 1 >+ && say_success( $out, "Added english language description for Southern Sami" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sma', 'language', 'sma', 'Ãarjelsaemien gïele')} >+ ) == 1 >+ && say_success( $out, "Added native language description for Southern Sami" ); >+ >+ # Northern Sami >+ $dbh->do( >+ q{INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sme', 'language', 'Northern Sami', 'NOW()')} >+ ) == 1 >+ && say_success( $out, "Added language_subtag_registry for Northern Sami" ); >+ $dbh->do(q{INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sme', 'sme')}) >+ == 1 && say_success( $out, "Added language_rfc4646_to_iso639 for Northern Sami" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sme', 'language', 'en', 'Northern Sami')} >+ ) == 1 >+ && say_success( $out, "Added english language description for Northern Sami" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sme', 'language', 'fi', 'pohjoissaame')} >+ ) == 1 >+ && say_success( $out, "Added native language description for Northern Sami" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sme', 'language', 'sv', 'Nordsamiska')} >+ ) == 1 >+ && say_success( $out, "Added native language description for Northern Sami" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sme', 'language', 'sme', 'davvisámegiella')} >+ ) == 1 >+ && say_success( $out, "Added native language description for Northern Sami" ); >+ >+ # Sami languages >+ $dbh->do( >+ q{INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'smi', 'language', 'Sami languages', 'NOW()')} >+ ) == 1 >+ && say_success( $out, "Added language_subtag_registry for Sami languages" ); >+ $dbh->do(q{INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'smi', 'smi')}) >+ == 1 && say_success( $out, "Added language_rfc4646_to_iso639 for Sami languages" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'smi', 'language', 'en', 'Sami languages')} >+ ) == 1 >+ && say_success( $out, "Added english language description for Sami languages" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'smi', 'language', 'fi', 'saamelaiskielet')} >+ ) == 1 >+ && say_success( $out, "Added native language description for Sami languages" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'smi', 'language', 'sv', 'Samiska')} >+ ) == 1 >+ && say_success( $out, "Added native language description for Sami languages" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'smi', 'language', 'smi', 'Saami')} >+ ) == 1 >+ && say_success( $out, "Added native language description for Sami languages" ); >+ >+ # Lule Sami >+ $dbh->do( >+ q{INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'smj', 'language', 'Lule Sami', 'NOW()')} >+ ) == 1 >+ && say_success( $out, "Added language_subtag_registry for Lule Sami" ); >+ $dbh->do(q{INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'smj', 'smj')}) >+ == 1 && say_success( $out, "Added language_rfc4646_to_iso639 for Lule Sami" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'smj', 'language', 'en', 'Lule Sami')} >+ ) == 1 >+ && say_success( $out, "Added english language description for Lule Sami" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'smj', 'language', 'smj', 'julevsámegiella')} >+ ) == 1 >+ && say_success( $out, "Added native language description for Lule Sami" ); >+ >+ # Inari Sami >+ $dbh->do( >+ q{INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'smn', 'language', 'Inari Sami', 'NOW()')} >+ ) == 1 >+ && say_success( $out, "Added language_subtag_registry for Inari Sami" ); >+ $dbh->do(q{INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'smn', 'smn')}) >+ == 1 && say_success( $out, "Added language_rfc4646_to_iso639 for Inari Sami" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'smn', 'language', 'en', 'Inari Sami')} >+ ) == 1 >+ && say_success( $out, "Added english language description for Inari Sami" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'smn', 'language', 'smn', 'anarâškielâ')} >+ ) == 1 >+ && say_success( $out, "Added native language description for Inari Sami" ); >+ >+ # Skolt Sami >+ $dbh->do( >+ q{INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sms', 'language', 'Skolt Sami', 'NOW()')} >+ ) == 1 >+ && say_success( $out, "Added language_subtag_registry for Skolt Sami" ); >+ $dbh->do(q{INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sms', 'sms')}) >+ == 1 && say_success( $out, "Added language_rfc4646_to_iso639 for Skolt Sami" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sms', 'language', 'en', 'Skolt Sami')} >+ ) == 1 >+ && say_success( $out, "Added english language description for Skolt Sami" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sms', 'language', 'sms', 'sääʹmÇ©iõll')} >+ ) == 1 >+ && say_success( $out, "Added native language description for Skolt Sami" ); >+ >+ # Somali >+ $dbh->do( >+ q{INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'so', 'language', 'Somali', 'NOW()')} >+ ) == 1 >+ && say_success( $out, "Added language_subtag_registry for Somali" ); >+ $dbh->do(q{INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'so', 'som')}) >+ == 1 && say_success( $out, "Added language_rfc4646_to_iso639 for Somali" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'so', 'language', 'en', 'Somali')} >+ ) == 1 >+ && say_success( $out, "Added english language description for Somali" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'so', 'language', 'so', 'Af-Soomaali')} >+ ) == 1 >+ && say_success( $out, "Added native language description for Somali" ); >+ >+ # Sotho >+ $dbh->do( >+ q{INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'st', 'language', 'Sotho', 'NOW()')} >+ ) == 1 >+ && say_success( $out, "Added language_subtag_registry for Sotho" ); >+ $dbh->do(q{INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'st', 'sot')}) >+ == 1 && say_success( $out, "Added language_rfc4646_to_iso639 for Sotho" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'st', 'language', 'en', 'Sotho')} >+ ) == 1 >+ && say_success( $out, "Added english language description for Sotho" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'st', 'language', 'st', 'Sesotho')} >+ ) == 1 >+ && say_success( $out, "Added native language description for Sotho" ); >+ >+ # Votic >+ $dbh->do( >+ q{INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'vot', 'language', 'Votic', 'NOW()')} >+ ) == 1 >+ && say_success( $out, "Added language_subtag_registry for Votic" ); >+ $dbh->do(q{INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'vot', 'vot')}) >+ == 1 && say_success( $out, "Added language_rfc4646_to_iso639 for Votic" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'vot', 'language', 'en', 'Votic')} >+ ) == 1 >+ && say_success( $out, "Added english language description for Votic" ); >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'vot', 'language', 'vot', 'vaÄÄa ceeli')} >+ ) == 1 >+ && say_success( $out, "Added native language description for Votic" ); >+ >+ $dbh->do( >+ q{UPDATE language_descriptions SET description = 'LatvieÅ¡u valoda' WHERE subtag = 'lv' AND type = 'language' AND lang = 'lv'} >+ ) == 1 >+ && say_success( $out, "Updated native lv language description from Latvija to LatvieÅ¡u valoda" ); >+ >+ $dbh->do( >+ q{UPDATE language_descriptions SET description = 'Lietuvių kalba' WHERE subtag = 'lt' AND type = 'language' AND lang = 'lt'} >+ ) == 1 >+ && say_success( $out, "Updated native lt language description from Lietuvių to Lietuvių kalba" ); >+ >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'grc', 'language', 'grc', 'á¼Î»Î»Î·Î½Î¹ÎºÎ®')} >+ ) == 1 >+ && say_success( $out, "Added native language description for Ancient Greek" ); >+ >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'eo', 'language', 'eo', 'Esperanto')} >+ ) == 1 >+ && say_success( $out, "Added native language description for Esperanto" ); >+ >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sa', 'language', 'sa', 'saá¹ská¹tam')} >+ ) == 1 >+ && say_success( $out, "Added native language description for Sanskrit" ); >+ >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ga', 'language', 'ga', 'Gaeilge')} >+ >+ ) == 1 && say_success( $out, "Added native language description for Irish Gaelic" ); >+ >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'bs', 'language', 'bn', 'Bosanski')} >+ ) == 1 >+ && say_success( $out, "Added native language description for Bosnian" ); >+ >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'kk', 'language', 'kk', 'ÒÐ°Ð·Ð°Ò ÑÑлÑ')} >+ ) && say_success( $out, "Added native language description for Kazakh" ); >+ >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'bo', 'language', 'bo', 'ལྷà¼à½¦à½ ིà¼à½¦à¾à½à¼')} >+ ) == 1 >+ && say_success( $out, "Added native language description of Standard Tibetan" ); >+ >+ $dbh->do( >+ q{INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'cy', 'language', 'cy', 'Cymraeg')} >+ ) && say_success( $out, "Added native language description of Welsh" ); >+ } >+ } >-- >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