Attachment #63265 for bug #18493

View | Details | Raw Unified | Return to bug 18493
Collapse All | Expand All




$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";
}




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' );

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' );

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' );

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');

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' );

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');

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');

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');

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' );

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');

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' );

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');

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' );

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' );

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');

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');

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' );

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');
- 

Return to bug 18493

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/Bug-18493-Add-new-searchable-languages.perl (+187 lines)
		1	$DBversion = 'XXX'; # will be replaced by the RM
		2	if( CheckVersion( $DBversion ) ) {
		3
		4	# Standard Tibetan
		5	$dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'bo', 'language', 'Standard Tibetan', '2017-04-21')");
		6	$dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'bo', 'tib')");
		7	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'bo', 'language', 'en', 'Standard Tibetan')");
		8	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'bo', 'language', 'bo', 'ལྷ་སའི་སྐད་')");
		9	# Bosnian
		10	$dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'bs', 'language', 'Bosnian', '2017-04-21')");
		11	$dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'bs', 'bos')");
		12	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'bs', 'language', 'en', 'Bosnian')");
		13	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'bs', 'language', 'bn', 'Bosanski')");
		14	# Welsh
		15	$dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'cy', 'language', 'Welsh', '2017-04-21')");
		16	$dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'cy', 'wel')");
		17	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'cy', 'language', 'en', 'Welsh')");
		18	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'cy', 'language', 'cy', 'Cymraeg')");
		19	# Esperanto
		20	$dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'eo', 'language', 'Esperanto', '2017-04-21')");
		21	$dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'eo', 'epo')");
		22	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'eo', 'language', 'en', 'Esperanto')");
		23	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'eo', 'language', 'eo', 'Esperanto')");
		24	# Estonian
		25	$dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'et', 'language', 'Estonian', '2017-04-21')");
		26	$dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'et', 'est')");
		27	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'et', 'language', 'et', 'Eesti')");
		28	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'et', 'language', 'en', 'Estonian')");
		29	# Irish Gaelic
		30	$dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'ga', 'language', 'Irish', '2017-04-21')");
		31	$dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'ga', 'gle')");
		32	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ga', 'language', 'en', 'Irish')");
		33	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ga', 'language', 'ga', 'Gaeilge')");
		34	# Scottish Gaelic
		35	$dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'gd', 'language', 'Scottish Gaelic', '2017-04-21')");
		36	$dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'gd', 'gla')");
		37	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'gd', 'language', 'en', 'Scottish Gaelic')");
		38	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'gd', 'language', 'gd', 'Gàidhlig')");
		39	# Ancient Greek
		40	$dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'grc', 'language', 'Greek, Ancient', '2017-04-21')");
		41	$dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'grc', 'grc')");
		42	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'grc', 'language', 'en', 'Greek, Ancient')");
		43	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'grc', 'language', 'grc', 'Ἑλληνική')");
		44	# Kazakh
		45	$dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'kk', 'language', 'Kazakh', '2017-04-21')");
		46	$dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'kk', 'kaz')");
		47	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'kk', 'language', 'en', 'Kazakh')");
		48	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'kk', 'language', 'kk', 'қазақ тілі')");
		49	# Greenlandic
		50	$dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'kl', 'language', 'Greenlandic', '2017-04-21')");
		51	$dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'kl', 'kal')");
		52	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'kl', 'language', 'en', 'Greenlandic')");
		53	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'kl', 'language', 'kl', 'Kalaallisut')");
		54	# Karelian
		55	$dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'krl', 'language', 'Karelian', '2017-04-21')");
		56	$dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'krl', 'krl')");
		57	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'krl', 'language', 'en', 'Karelian')");
		58	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'krl', 'language', 'krl', 'Karjala')");
		59	# Cornish
		60	$dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'kw', 'language', 'Cornish', '2017-04-21')");
		61	$dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'kw', 'cor')");
		62	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'kw', 'language', 'en', 'Cornish')");
		63	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'kw', 'language', 'kw', 'Kernowek')");
		64	# Lithuanian
65	$dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'lt', 'language', 'Lithuanian', '2017-04-21')");
66	$dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'lt', 'lit')");
67	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'lt', 'language', 'en', 'Lithuanian')");
68	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'lt', 'language', 'lt', 'lietuvių kalba')");
69	# Latvian
70	$dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'lv', 'language', 'Latvian', '2017-04-21')");
71	$dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'lv', 'lav')");
72	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'lv', 'language', 'en', 'Latvian')");
73	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'lv', 'language', 'lv', 'Latviešu valoda')");
74	# Burmese
75	$dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'my', 'language', 'Burmese', '2017-04-21')");
76	$dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'my', 'bur')");
77	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'my', 'language', 'en', 'Burmese')");
78	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'my', 'language', 'my', 'မြန်မာစာ')");
79	# Punjabi
80	$dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'pa', 'language', 'Punjabi', '2017-04-21')");
81	$dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'pa', 'pan')");
82	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'pa', 'language', 'en', 'Punjabi')");
83	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'pa', 'language', 'pa', 'پنجابی')");
84	# Pashto
85	$dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'ps', 'language', 'Pashto', '2017-04-21')");
86	$dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'ps', 'pus')");
87	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ps', 'language', 'en', 'Pashto')");
88	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ps', 'language', 'ps', 'پښتو')");
89	# Finnish Kalo
90	$dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES( 'rmf', 'rmf')");
91	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'rmf', 'language', 'en', 'Finnish Kalo')");
92	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'rmf', 'language', 'fi', 'Suomen romanikieli')");
93	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'rmf', 'language', 'rmf', 'Fíntika Rómma')");
94	# Sanskrit
95	$dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sa', 'language', 'Sanskrit', '2017-04-21')");
96	$dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sa', 'san')");
97	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sa', 'language', 'en', 'Sanskrit')");
98	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sa', 'language', 'sa', 'saṃskṛtam')");
99	# Akkala Sami
100	$dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sia', 'language', 'Akkala Sami', '2017-04-21')");
101	$dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sia', 'sia')");
102	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sia', 'language', 'en', 'Akkala Sami')");
103	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sia', 'language', 'sia', 'ču´kksuâlis')");
104	# Kildin Sami
105	$dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sjd', 'language', 'Kildin Sami', '2017-04-21')");
106	$dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sjd', 'sjd')");
107	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sjd', 'language', 'en', 'Kildin Sami')");
108	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sjd', 'language', 'sjd', 'Кӣллт са̄мь кӣлл')");
109	# Ter Sami
110	$dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sjt', 'language', 'Ter Sami', '2017-04-21')");
111	$dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sjt', 'sjt')");
112	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sjt', 'language', 'en', 'Ter Sami')");
113	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sjt', 'language', 'sjt', 'saa´mekiill')");
114	# Pite Sami
115	$dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sje', 'language', 'Pite Sami', '2017-04-21')");
116	$dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sje', 'sje')");
117	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sje', 'language', 'en', 'Pite Sami')");
118	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sje', 'language', 'sje', 'Bidumsámegiella')");
119	# Kemi Sami
120	$dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sjk', 'language', 'Kemi Sami', '2017-04-21')");
121	$dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sjk', 'sjk')");
122	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sjk', 'language', 'en', 'Kemi Sami')");
123	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sjk', 'language', 'sjk', 'samääškiela')");
124	# Ume Sami
125	$dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sju', 'language', 'Ume Sami', '2017-04-21')");
126	$dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sju', 'sju')");
127	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sju', 'language', 'en', 'Ume Sami')");
128	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sju', 'language', 'sju', 'Ubmejensámien giella')");
129	# Southern Sami
130	$dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sma', 'language', 'Southern Sami', '2017-04-21')");
131	$dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sma', 'sma')");
132	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sma', 'language', 'en', 'Southern Sami')");
133	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sma', 'language', 'sma', 'Åarjelsaemien gïele')");
134	# Northern Sami
135	$dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sme', 'language', 'Northern Sami', '2017-04-21')");
136	$dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sme', 'sme')");
137	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sme', 'language', 'en', 'Northern Sami')");
138	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sme', 'language', 'fi', 'pohjoissaame')");
139	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sme', 'language', 'sv', 'Nordsamiska')");
140	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sme', 'language', 'sme', 'davvisámegiella')");
141	# Sami languages
142	$dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'smi', 'language', 'Sami languages', '2017-04-21')");
143	$dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'smi', 'smi')");
144	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'smi', 'language', 'en', 'Sami languages')");
145	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'smi', 'language', 'fi', 'saamelaiskielet')");
146	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'smi', 'language', 'sv', 'Samiska')");
147	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'smi', 'language', 'smi', 'Saami')");
148	# Lule Sami
149	$dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'smj', 'language', 'Lule Sami', '2017-04-21')");
150	$dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'smj', 'smj')");
151	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'smj', 'language', 'en', 'Lule Sami')");
152	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'smj', 'language', 'smj', 'julevsámegiella')");
153	# Inari Sami
154	$dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'smn', 'language', 'Inari Sami', '2017-04-21')");
155	$dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'smn', 'smn')");
156	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'smn', 'language', 'en', 'Inari Sami')");
157	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'smn', 'language', 'smn', 'anarâškielâ')");
158	# Skolt Sami
159	$dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sms', 'language', 'Skolt Sami', '2017-04-21')");
160	$dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sms', 'sms')");
161	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sms', 'language', 'en', 'Skolt Sami')");
162	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sms', 'language', 'sms', 'sääʹmǩiõll')");
163	# Somali
164	$dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'so', 'language', 'Somali', '2017-04-21')");
165	$dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'so', 'som')");
166	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'so', 'language', 'en', 'Somali')");
167	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'so', 'language', 'so', 'Af-Soomaali')");
168	# Sotho
169	$dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'st', 'language', 'Sotho', '2017-04-21')");
170	$dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'st', 'sot')");
171	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'st', 'language', 'en', 'Sotho')");
172	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'st', 'language', 'st', 'Sesotho')");
173	# Votic
174	$dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'vot', 'language', 'Votic', '2017-04-21')");
175	$dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'vot', 'vot')");
176	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'vot', 'language', 'en', 'Votic')");
177	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'vot', 'language', 'vot', 'vađđa ceeli')");
178	# Yiddish
179	$dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'yi', 'language', 'Yiddish', '2017-04-21')");
180	$dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'yi', 'yid')");
181	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'yi', 'language', 'en', 'Yiddish')");
182	$dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'yi', 'language', 'yi', 'יידיש')");
183
184	# Always end with this (adjust the bug info)
185	SetVersion( $DBversion );
186	print "Upgrade to $DBversion done (Bug XXXXX - description)\n";
187	}