Attachment 66688 Details for Bug 18493 – Bug 18493: Add new searchable languages

[patch] Bug 18493: Add new searchable languages

Bug-18493-Add-new-searchable-languages.patch (text/plain), 43.96 KB, created by Marcel de Rooy on 2017-09-01 06:59:36 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Marcel de Rooy

Created: 2017-09-01 06:59:36 UTC

Size: 43.96 KB

patch

obsolete

>From 33d453ca730c69f33c0e8e8e8579cfab6fc9a629 Mon Sep 17 00:00:00 2001
>From: Lari Taskula <lari.taskula@jns.fi>
>Date: Tue, 25 Apr 2017 10:23:03 +0000
>Subject: [PATCH] Bug 18493: Add new searchable languages
>MIME-Version: 1.0
>Content-Type: text/plain; charset=utf-8
>Content-Transfer-Encoding: 8bit
>Content-Type: text/plain; charset=utf-8
>
>This patch adds the following languages into advanced search "Languages" dropdown:
>
>Bosnian
>Welsh
>Esperanto
>Estonian
>Irish Gaelic
>Scottish Gaelic
>Ancient Greek
>Kazakh
>Greenlandic
>Karelian
>Cornish
>Lithuanian
>Latvian
>Burmese
>Punjabi
>Pashto
>Finnish Kalo
>Sanskrit
>Akkala Sami
>Kildin Sami
>Ter Sami
>Pite Sami
>Kemi Sami
>Ume Sami
>Southern Sami
>Northern Sami
>Sami languages
>Lule Sami
>Inari Sami
>Skolt Sami
>Somali
>Sotho
>Votic
>Yiddish
>
>To test:
>1. perl installer/data/mysql/updatedatabase.pl
>2. Go to intranet advanced search
>3. Click "More options"
>4. See "Limits" fieldset, it should have "Language" drop down
>5. Observe that the languages provided in this patch are visible in this dropdown
>
>Signed-off-by: Marc VÃ©ron <veron@veron.ch>
>
>Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
>Just noting that the order in this dropdown is hopeless.
>---
> .../Bug-18493-Add-new-searchable-languages.perl    | 187 +++++++++
> installer/data/mysql/mandatory/subtag_registry.sql | 467 +++++++++++++++++++++
> 2 files changed, 654 insertions(+)
> create mode 100644 installer/data/mysql/atomicupdate/Bug-18493-Add-new-searchable-languages.perl
>
>diff --git a/installer/data/mysql/atomicupdate/Bug-18493-Add-new-searchable-languages.perl b/installer/data/mysql/atomicupdate/Bug-18493-Add-new-searchable-languages.perl
>new file mode 100644
>index 0000000..a6e27b8
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/Bug-18493-Add-new-searchable-languages.perl
>@@ -0,0 +1,187 @@
>+$DBversion = 'XXX';  # will be replaced by the RM
>+if( CheckVersion( $DBversion ) ) {
>+
>+    # Standard Tibetan
>+    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'bo', 'language', 'Standard Tibetan', '2017-04-21')");
>+    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'bo', 'tib')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'bo', 'language', 'en', 'Standard Tibetan')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'bo', 'language', 'bo', 'à½£à¾·à¼à½¦à½ à½²à¼à½¦à¾à½à¼')");
>+    # Bosnian
>+    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'bs', 'language', 'Bosnian', '2017-04-21')");
>+    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'bs', 'bos')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'bs', 'language', 'en', 'Bosnian')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'bs', 'language', 'bn', 'Bosanski')");
>+    # Welsh
>+    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'cy', 'language', 'Welsh', '2017-04-21')");
>+    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'cy', 'wel')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'cy', 'language', 'en', 'Welsh')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'cy', 'language', 'cy', 'Cymraeg')");
>+    # Esperanto
>+    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'eo', 'language', 'Esperanto', '2017-04-21')");
>+    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'eo', 'epo')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'eo', 'language', 'en', 'Esperanto')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'eo', 'language', 'eo', 'Esperanto')");
>+    # Estonian
>+    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'et', 'language', 'Estonian', '2017-04-21')");
>+    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'et', 'est')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'et', 'language', 'et', 'Eesti')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'et', 'language', 'en', 'Estonian')");
>+    # Irish Gaelic
>+    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'ga', 'language', 'Irish', '2017-04-21')");
>+    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'ga', 'gle')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ga', 'language', 'en', 'Irish')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ga', 'language', 'ga', 'Gaeilge')");
>+    # Scottish Gaelic
>+    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'gd', 'language', 'Scottish Gaelic', '2017-04-21')");
>+    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'gd', 'gla')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'gd', 'language', 'en', 'Scottish Gaelic')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'gd', 'language', 'gd', 'GÃ idhlig')");
>+    # Ancient Greek
>+    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'grc', 'language', 'Greek, Ancient', '2017-04-21')");
>+    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'grc', 'grc')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'grc', 'language', 'en', 'Greek, Ancient')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'grc', 'language', 'grc', 'á¼Î»Î»Î·Î½Î¹ÎºÎ®')");
>+    # Kazakh
>+    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'kk', 'language', 'Kazakh', '2017-04-21')");
>+    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'kk', 'kaz')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'kk', 'language', 'en', 'Kazakh')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'kk', 'language', 'kk', 'ÒÐ°Ð·Ð°Ò ÑÑÐ»Ñ')");
>+    # Greenlandic
>+    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'kl', 'language', 'Greenlandic', '2017-04-21')");
>+    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'kl', 'kal')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'kl', 'language', 'en', 'Greenlandic')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'kl', 'language', 'kl', 'Kalaallisut')");
>+    # Karelian
>+    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'krl', 'language', 'Karelian', '2017-04-21')");
>+    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'krl', 'krl')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'krl', 'language', 'en', 'Karelian')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'krl', 'language', 'krl', 'Karjala')");
>+    # Cornish
>+    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'kw', 'language', 'Cornish', '2017-04-21')");
>+    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'kw', 'cor')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'kw', 'language', 'en', 'Cornish')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'kw', 'language', 'kw', 'Kernowek')");
>+    # Lithuanian
>+    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'lt', 'language', 'Lithuanian', '2017-04-21')");
>+    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'lt', 'lit')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'lt', 'language', 'en', 'Lithuanian')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'lt', 'language', 'lt', 'lietuviÅ³ kalba')");
>+    # Latvian
>+    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'lv', 'language', 'Latvian', '2017-04-21')");
>+    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'lv', 'lav')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'lv', 'language', 'en', 'Latvian')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'lv', 'language', 'lv', 'LatvieÅ¡u valoda')");
>+    # Burmese
>+    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'my', 'language', 'Burmese', '2017-04-21')");
>+    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'my', 'bur')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'my', 'language', 'en', 'Burmese')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'my', 'language', 'my', 'áá¼ááºáá¬áá¬')");
>+    # Punjabi
>+    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'pa', 'language', 'Punjabi', '2017-04-21')");
>+    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'pa', 'pan')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'pa', 'language', 'en', 'Punjabi')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'pa', 'language', 'pa', 'Ù¾ÙØ¬Ø§Ø¨Û')");
>+    # Pashto
>+    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'ps', 'language', 'Pashto', '2017-04-21')");
>+    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'ps', 'pus')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ps', 'language', 'en', 'Pashto')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ps', 'language', 'ps', 'Ù¾ÚØªÙ')");
>+    # Finnish Kalo
>+    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES( 'rmf', 'rmf')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'rmf', 'language', 'en', 'Finnish Kalo')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'rmf', 'language', 'fi', 'Suomen romanikieli')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'rmf', 'language', 'rmf', 'FÃntika RÃ³mma')");
>+    # Sanskrit
>+    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sa', 'language', 'Sanskrit', '2017-04-21')");
>+    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sa', 'san')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sa', 'language', 'en', 'Sanskrit')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sa', 'language', 'sa', 'saá¹ská¹tam')");
>+    # Akkala Sami
>+    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sia', 'language', 'Akkala Sami', '2017-04-21')");
>+    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sia', 'sia')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sia', 'language', 'en', 'Akkala Sami')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sia', 'language', 'sia', 'ÄuÂ´kksuÃ¢lis')");
>+    # Kildin Sami
>+    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sjd', 'language', 'Kildin Sami', '2017-04-21')");
>+    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sjd', 'sjd')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sjd', 'language', 'en', 'Kildin Sami')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sjd', 'language', 'sjd', 'ÐÓ£Ð»Ð»Ñ ÑÐ°ÌÐ¼Ñ ÐºÓ£Ð»Ð»')");
>+    # Ter Sami
>+    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sjt', 'language', 'Ter Sami', '2017-04-21')");
>+    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sjt', 'sjt')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sjt', 'language', 'en', 'Ter Sami')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sjt', 'language', 'sjt', 'saaÂ´mekiill')");
>+    # Pite Sami
>+    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sje', 'language', 'Pite Sami', '2017-04-21')");
>+    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sje', 'sje')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sje', 'language', 'en', 'Pite Sami')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sje', 'language', 'sje', 'BidumsÃ¡megiella')");
>+    # Kemi Sami
>+    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sjk', 'language', 'Kemi Sami', '2017-04-21')");
>+    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sjk', 'sjk')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sjk', 'language', 'en', 'Kemi Sami')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sjk', 'language', 'sjk', 'samÃ¤Ã¤Å¡kiela')");
>+    # Ume Sami
>+    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sju', 'language', 'Ume Sami', '2017-04-21')");
>+    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sju', 'sju')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sju', 'language', 'en', 'Ume Sami')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sju', 'language', 'sju', 'UbmejensÃ¡mien giella')");
>+    # Southern Sami
>+    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sma', 'language', 'Southern Sami', '2017-04-21')");
>+    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sma', 'sma')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sma', 'language', 'en', 'Southern Sami')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sma', 'language', 'sma', 'Ãarjelsaemien gÃ¯ele')");
>+    # Northern Sami
>+    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sme', 'language', 'Northern Sami', '2017-04-21')");
>+    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sme', 'sme')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sme', 'language', 'en', 'Northern Sami')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sme', 'language', 'fi', 'pohjoissaame')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sme', 'language', 'sv', 'Nordsamiska')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sme', 'language', 'sme', 'davvisÃ¡megiella')");
>+    # Sami languages
>+    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'smi', 'language', 'Sami languages', '2017-04-21')");
>+    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'smi', 'smi')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'smi', 'language', 'en', 'Sami languages')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'smi', 'language', 'fi', 'saamelaiskielet')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'smi', 'language', 'sv', 'Samiska')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'smi', 'language', 'smi', 'Saami')");
>+    # Lule Sami
>+    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'smj', 'language', 'Lule Sami', '2017-04-21')");
>+    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'smj', 'smj')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'smj', 'language', 'en', 'Lule Sami')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'smj', 'language', 'smj', 'julevsÃ¡megiella')");
>+    # Inari Sami
>+    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'smn', 'language', 'Inari Sami', '2017-04-21')");
>+    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'smn', 'smn')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'smn', 'language', 'en', 'Inari Sami')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'smn', 'language', 'smn', 'anarÃ¢Å¡kielÃ¢')");
>+    # Skolt Sami
>+    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sms', 'language', 'Skolt Sami', '2017-04-21')");
>+    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sms', 'sms')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sms', 'language', 'en', 'Skolt Sami')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sms', 'language', 'sms', 'sÃ¤Ã¤Ê¹mÇ©iÃµll')");
>+    # Somali
>+    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'so', 'language', 'Somali', '2017-04-21')");
>+    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'so', 'som')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'so', 'language', 'en', 'Somali')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'so', 'language', 'so', 'Af-Soomaali')");
>+    # Sotho
>+    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'st', 'language', 'Sotho', '2017-04-21')");
>+    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'st', 'sot')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'st', 'language', 'en', 'Sotho')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'st', 'language', 'st', 'Sesotho')");
>+    # Votic
>+    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'vot', 'language', 'Votic', '2017-04-21')");
>+    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'vot', 'vot')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'vot', 'language', 'en', 'Votic')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'vot', 'language', 'vot', 'vaÄÄa ceeli')");
>+    # Yiddish
>+    $dbh->do("INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'yi', 'language', 'Yiddish', '2017-04-21')");
>+    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'yi', 'yid')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'yi', 'language', 'en', 'Yiddish')");
>+    $dbh->do("INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'yi', 'language', 'yi', '×××××©')");
>+
>+    # Always end with this (adjust the bug info)
>+    SetVersion( $DBversion );
>+    print "Upgrade to $DBversion done (Bug XXXXX - description)\n";
>+}
>diff --git a/installer/data/mysql/mandatory/subtag_registry.sql b/installer/data/mysql/mandatory/subtag_registry.sql
>index e21577a..346eae1 100755
>--- a/installer/data/mysql/mandatory/subtag_registry.sql
>+++ b/installer/data/mysql/mandatory/subtag_registry.sql
>@@ -146,6 +146,32 @@ VALUES ( 'bg', 'language', 'fr', 'Bulgare');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES ( 'bg', 'language', 'de', 'Bulgarisch');
> 
>+-- Standard Tibetan
>+INSERT INTO language_subtag_registry( subtag, type, description, added)
>+VALUES ( 'bo', 'language', 'Standard Tibetan', '2017-04-21');
>+
>+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
>+VALUES ( 'bo', 'tib');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'bo', 'language', 'en', 'Standard Tibetan');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'bo', 'language', 'bo', 'à½£à¾·à¼à½¦à½ à½²à¼à½¦à¾à½à¼');
>+
>+-- Bosnian
>+INSERT INTO language_subtag_registry( subtag, type, description, added)
>+VALUES ( 'bs', 'language', 'Bosnian', '2017-04-21');
>+
>+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
>+VALUES ( 'bs', 'bos');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'bs', 'language', 'en', 'Bosnian');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'bs', 'language', 'bn', 'Bosanski');
>+
> -- Catalan
> INSERT INTO language_subtag_registry( subtag, type, description, added)
> VALUES ( 'ca', 'language', 'Catalan','2013-01-12' );
>@@ -187,6 +213,19 @@ VALUES ( 'cs', 'language', 'fr', 'TchÃ¨que');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES ( 'cs', 'language', 'de', 'Tschechisch');
> 
>+-- Welsh
>+INSERT INTO language_subtag_registry( subtag, type, description, added)
>+VALUES ( 'cy', 'language', 'Welsh', '2017-04-21');
>+
>+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
>+VALUES ( 'cy', 'wel');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'cy', 'language', 'en', 'Welsh');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'cy', 'language', 'cy', 'Cymraeg');
>+
> -- Danish
> INSERT INTO language_subtag_registry( subtag, type, description, added)
> VALUES ( 'da', 'language', 'Danish','2005-10-16' );
>@@ -257,6 +296,19 @@ VALUES ( 'en', 'language', 'fr', 'Anglais');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES ( 'en', 'language', 'de', 'Englisch');
> 
>+-- Esperanto
>+INSERT INTO language_subtag_registry( subtag, type, description, added)
>+VALUES ( 'eo', 'language', 'Esperanto', '2017-04-21');
>+
>+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
>+VALUES ( 'eo', 'epo');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'eo', 'language', 'en', 'Esperanto');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'eo', 'language', 'eo', 'Esperanto');
>+
> -- Spanish, Castilian
> INSERT INTO language_subtag_registry( subtag, type, description, added)
> VALUES ( 'es', 'language', 'Spanish','2005-10-16' );
>@@ -276,6 +328,19 @@ VALUES ( 'es', 'language', 'fr', 'Espagnol');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES ( 'es', 'language', 'de', 'Spanisch');
> 
>+-- Estonian
>+INSERT INTO language_subtag_registry( subtag, type, description, added)
>+VALUES ( 'et', 'language', 'Estonian', '2017-04-21');
>+
>+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
>+VALUES ( 'et', 'est');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'et', 'language', 'et', 'Eesti');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'et', 'language', 'en', 'Estonian');
>+
> -- Basque
> INSERT INTO language_subtag_registry( subtag, type, description, added)
> VALUES ( 'eu', 'language', 'Basque','2014-10-30');
>@@ -353,6 +418,32 @@ VALUES ( 'fr', 'language', 'fr', 'FranÃ§ais');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES ( 'fr', 'language', 'de', 'FranzÃ¶sisch');
> 
>+-- Irish Gaelic
>+INSERT INTO language_subtag_registry( subtag, type, description, added)
>+VALUES ( 'ga', 'language', 'Irish', '2017-04-21');
>+
>+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
>+VALUES ( 'ga', 'gle');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'ga', 'language', 'en', 'Irish');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'ga', 'language', 'ga', 'Gaeilge');
>+
>+-- Scottish Gaelic
>+INSERT INTO language_subtag_registry( subtag, type, description, added)
>+VALUES ( 'gd', 'language', 'Scottish Gaelic', '2017-04-21');
>+
>+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
>+VALUES ( 'gd', 'gla');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'gd', 'language', 'en', 'Scottish Gaelic');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'gd', 'language', 'gd', 'GÃ idhlig');
>+
> -- Galician
> INSERT INTO language_subtag_registry( subtag, type, description, added)
> VALUES ( 'gl', 'language', 'Galician','2005-10-16' );
>@@ -372,6 +463,19 @@ VALUES ( 'gl', 'language', 'fr', 'Galicien');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES ( 'gl', 'language', 'de', 'Galicisch');
> 
>+-- Ancient Greek
>+INSERT INTO language_subtag_registry( subtag, type, description, added)
>+VALUES ( 'grc', 'language', 'Greek, Ancient', '2017-04-21');
>+
>+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
>+VALUES ( 'grc', 'grc');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'grc', 'language', 'en', 'Greek, Ancient');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'grc', 'language', 'grc', 'á¼Î»Î»Î·Î½Î¹ÎºÎ®');
>+
> -- Hebrew
> INSERT INTO language_subtag_registry( subtag, type, description, added)
> VALUES ( 'he', 'language', 'Hebrew','2005-10-16');
>@@ -559,6 +663,32 @@ VALUES ( 'ka', 'language', 'de', 'Georgisch');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES ( 'ka', 'language', 'es', 'Georgiano');
> 
>+-- Kazakh
>+INSERT INTO language_subtag_registry( subtag, type, description, added)
>+VALUES ( 'kk', 'language', 'Kazakh', '2017-04-21');
>+
>+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
>+VALUES ( 'kk', 'kaz');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'kk', 'language', 'en', 'Kazakh');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'kk', 'language', 'kk', 'ÒÐ°Ð·Ð°Ò ÑÑÐ»Ñ');
>+
>+-- Greenlandic
>+INSERT INTO language_subtag_registry( subtag, type, description, added)
>+VALUES ( 'kl', 'language', 'Greenlandic', '2017-04-21');
>+
>+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
>+VALUES ( 'kl', 'kal');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'kl', 'language', 'en', 'Greenlandic');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'kl', 'language', 'kl', 'Kalaallisut');
>+
> -- Kannada
> INSERT INTO language_subtag_registry( subtag, type, description, added)
> VALUES ( 'kn', 'language', 'Kannada','2014-10-30');
>@@ -604,6 +734,19 @@ VALUES ( 'ko', 'language', 'fr', 'CorÃ©en');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES ( 'ko', 'language', 'de', 'Koreanisch');
> 
>+-- Karelian
>+INSERT INTO language_subtag_registry( subtag, type, description, added)
>+VALUES ( 'krl', 'language', 'Karelian', '2017-04-21');
>+
>+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
>+VALUES ( 'krl', 'krl');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'krl', 'language', 'en', 'Karelian');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'krl', 'language', 'krl', 'Karjala');
>+
> -- Kurdish
> INSERT INTO language_subtag_registry( subtag, type, description, added)
> VALUES ( 'ku', 'language', 'Kurdish','2014-05-13');
>@@ -626,6 +769,19 @@ VALUES ( 'ku', 'language', 'de', 'Kurdisch');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES ( 'ku', 'language', 'es', 'Kurdo');
> 
>+-- Cornish
>+INSERT INTO language_subtag_registry( subtag, type, description, added)
>+VALUES ( 'kw', 'language', 'Cornish', '2017-04-21');
>+
>+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
>+VALUES ( 'kw', 'cor');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'kw', 'language', 'en', 'Cornish');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'kw', 'language', 'kw', 'Kernowek');
>+
> -- Latin
> INSERT INTO language_subtag_registry( subtag, type, description, added)
> VALUES ( 'la', 'language', 'Latin','2005-10-16' );
>@@ -664,6 +820,32 @@ VALUES ( 'lo', 'language', 'fr', 'Laotien');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES ( 'lo', 'language', 'de', 'Laotisch');
> 
>+-- Lithuanian
>+INSERT INTO language_subtag_registry( subtag, type, description, added)
>+VALUES ( 'lt', 'language', 'Lithuanian', '2017-04-21');
>+
>+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
>+VALUES ( 'lt', 'lit');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'lt', 'language', 'en', 'Lithuanian');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'lt', 'language', 'lt', 'lietuviÅ³ kalba');
>+
>+-- Latvian
>+INSERT INTO language_subtag_registry( subtag, type, description, added)
>+VALUES ( 'lv', 'language', 'Latvian', '2017-04-21');
>+
>+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
>+VALUES ( 'lv', 'lav');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'lv', 'language', 'en', 'Latvian');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'lv', 'language', 'lv', 'LatvieÅ¡u valoda');
>+
> -- Maori
> INSERT INTO language_subtag_registry( subtag, type, description, added)
> VALUES ( 'mi', 'language', 'Maori','2014-10-30');
>@@ -716,6 +898,19 @@ VALUES ( 'ms', 'language', 'ms', 'Bahasa melayu');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES ( 'ms', 'language', 'en', 'Malay');
> 
>+-- Burmese
>+INSERT INTO language_subtag_registry( subtag, type, description, added)
>+VALUES ( 'my', 'language', 'Burmese', '2017-04-21');
>+
>+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
>+VALUES ( 'my', 'bur');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'my', 'language', 'en', 'Burmese');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'my', 'language', 'my', 'áá¼ááºáá¬áá¬');
>+
> -- Norwegian (bokmÃ¥l)
> INSERT INTO language_subtag_registry( subtag, type, description, added)
> VALUES ( 'nb', 'language', 'Norwegian bokmÃ¥l','2005-10-16' );
>@@ -789,6 +984,19 @@ VALUES ( 'nn', 'language', 'fr', 'NorvÃ©gien nynorsk');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES ( 'nn', 'language', 'de', 'Norwegisch nynorsk');
> 
>+-- Punjabi
>+INSERT INTO language_subtag_registry( subtag, type, description, added)
>+VALUES ( 'pa', 'language', 'Punjabi', '2017-04-21');
>+
>+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
>+VALUES ( 'pa', 'pan');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'pa', 'language', 'en', 'Punjabi');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'pa', 'language', 'pa', 'Ù¾ÙØ¬Ø§Ø¨Û');
>+
> -- Pangwa
> INSERT INTO language_subtag_registry( subtag, type, description, added)
> VALUES ( 'pbr', 'language', 'Pangwa','2014-10-30');
>@@ -834,6 +1042,19 @@ VALUES ( 'prs', 'language', 'prs', 'Ø¯Ø±Ù');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES ( 'prs', 'language', 'en', 'Dari');
> 
>+-- Pashto
>+INSERT INTO language_subtag_registry( subtag, type, description, added)
>+VALUES ( 'ps', 'language', 'Pashto', '2017-04-21');
>+
>+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
>+VALUES ( 'ps', 'pus');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'ps', 'language', 'en', 'Pashto');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'ps', 'language', 'ps', 'Ù¾ÚØªÙ');
>+
> -- Portuguese
> INSERT INTO language_subtag_registry( subtag, type, description, added)
> VALUES ( 'pt', 'language', 'Portuguese','2005-10-16' );
>@@ -853,6 +1074,19 @@ VALUES ( 'pt', 'language', 'fr', 'Portugais');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES ( 'pt', 'language', 'de', 'Portugiesisch');
> 
>+-- Finnish Kalo
>+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
>+VALUES( 'rmf', 'rmf');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES( 'rmf', 'language', 'en', 'Finnish Kalo');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES( 'rmf', 'language', 'fi', 'Suomen romanikieli');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES( 'rmf', 'language', 'rmf', 'FÃntika RÃ³mma');
>+
> -- Romanian
> INSERT INTO language_subtag_registry( subtag, type, description, added)
> VALUES ( 'ro', 'language', 'Romanian','2005-10-16' );
>@@ -904,6 +1138,19 @@ VALUES ( 'rw', 'language', 'rw', 'Ikinyarwanda');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES ( 'rw', 'language', 'en', 'Kinyarwanda');
> 
>+-- Sanskrit
>+INSERT INTO language_subtag_registry( subtag, type, description, added)
>+VALUES ( 'sa', 'language', 'Sanskrit', '2017-04-21');
>+
>+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
>+VALUES ( 'sa', 'san');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'sa', 'language', 'en', 'Sanskrit');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'sa', 'language', 'sa', 'saá¹ská¹tam');
>+
> -- Sindhi
> INSERT INTO language_subtag_registry( subtag, type, description, added)
> VALUES ( 'sd', 'language', 'Sindhi','2014-10-30');
>@@ -943,6 +1190,187 @@ VALUES ( 'sl', 'language', 'sl', 'SlovenÅ¡Äina');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES ( 'sl', 'language', 'en', 'Slovene');
> 
>+-- Akkala Sami
>+INSERT INTO language_subtag_registry( subtag, type, description, added)
>+VALUES ( 'sia', 'language', 'Akkala Sami', '2017-04-21');
>+
>+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
>+VALUES ( 'sia', 'sia');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'sia', 'language', 'en', 'Akkala Sami');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'sia', 'language', 'sia', 'ÄuÂ´kksuÃ¢lis');
>+
>+-- Kildin Sami
>+INSERT INTO language_subtag_registry( subtag, type, description, added)
>+VALUES ( 'sjd', 'language', 'Kildin Sami', '2017-04-21');
>+
>+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
>+VALUES ( 'sjd', 'sjd');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'sjd', 'language', 'en', 'Kildin Sami');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'sjd', 'language', 'sjd', 'ÐÓ£Ð»Ð»Ñ ÑÐ°ÌÐ¼Ñ ÐºÓ£Ð»Ð»');
>+
>+-- Ter Sami
>+INSERT INTO language_subtag_registry( subtag, type, description, added)
>+VALUES ( 'sjt', 'language', 'Ter Sami', '2017-04-21');
>+
>+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
>+VALUES ( 'sjt', 'sjt');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'sjt', 'language', 'en', 'Ter Sami');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'sjt', 'language', 'sjt', 'saaÂ´mekiill');
>+
>+-- Pite Sami
>+INSERT INTO language_subtag_registry( subtag, type, description, added)
>+VALUES ( 'sje', 'language', 'Pite Sami', '2017-04-21');
>+
>+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
>+VALUES ( 'sje', 'sje');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'sje', 'language', 'en', 'Pite Sami');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'sje', 'language', 'sje', 'BidumsÃ¡megiella');
>+
>+-- Kemi Sami
>+INSERT INTO language_subtag_registry( subtag, type, description, added)
>+VALUES ( 'sjk', 'language', 'Kemi Sami', '2017-04-21');
>+
>+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
>+VALUES ( 'sjk', 'sjk');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'sjk', 'language', 'en', 'Kemi Sami');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'sjk', 'language', 'sjk', 'samÃ¤Ã¤Å¡kiela');
>+
>+-- Ume Sami
>+INSERT INTO language_subtag_registry( subtag, type, description, added)
>+VALUES ( 'sju', 'language', 'Ume Sami', '2017-04-21');
>+
>+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
>+VALUES ( 'sju', 'sju');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'sju', 'language', 'en', 'Ume Sami');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'sju', 'language', 'sju', 'UbmejensÃ¡mien giella');
>+
>+-- Southern Sami
>+INSERT INTO language_subtag_registry( subtag, type, description, added)
>+VALUES ( 'sma', 'language', 'Southern Sami', '2017-04-21');
>+
>+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
>+VALUES ( 'sma', 'sma');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'sma', 'language', 'en', 'Southern Sami');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'sma', 'language', 'sma', 'Ãarjelsaemien gÃ¯ele');
>+
>+-- Northern Sami
>+INSERT INTO language_subtag_registry( subtag, type, description, added)
>+VALUES ( 'sme', 'language', 'Northern Sami', '2017-04-21');
>+
>+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
>+VALUES ( 'sme', 'sme');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'sme', 'language', 'en', 'Northern Sami');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'sme', 'language', 'fi', 'pohjoissaame');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'sme', 'language', 'sv', 'Nordsamiska');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'sme', 'language', 'sme', 'davvisÃ¡megiella');
>+
>+-- Sami languages
>+INSERT INTO language_subtag_registry( subtag, type, description, added)
>+VALUES ( 'smi', 'language', 'Sami languages', '2017-04-21');
>+
>+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
>+VALUES ( 'smi', 'smi');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'smi', 'language', 'en', 'Sami languages');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'smi', 'language', 'fi', 'saamelaiskielet');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'smi', 'language', 'sv', 'Samiska');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'smi', 'language', 'smi', 'Saami');
>+
>+-- Lule Sami
>+INSERT INTO language_subtag_registry( subtag, type, description, added)
>+VALUES ( 'smj', 'language', 'Lule Sami', '2017-04-21');
>+
>+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
>+VALUES ( 'smj', 'smj');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'smj', 'language', 'en', 'Lule Sami');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'smj', 'language', 'smj', 'julevsÃ¡megiella');
>+
>+-- Inari Sami
>+INSERT INTO language_subtag_registry( subtag, type, description, added)
>+VALUES ( 'smn', 'language', 'Inari Sami', '2017-04-21');
>+
>+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
>+VALUES ( 'smn', 'smn');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'smn', 'language', 'en', 'Inari Sami');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'smn', 'language', 'smn', 'anarÃ¢Å¡kielÃ¢');
>+
>+-- Skolt Sami
>+INSERT INTO language_subtag_registry( subtag, type, description, added)
>+VALUES ( 'sms', 'language', 'Skolt Sami', '2017-04-21');
>+
>+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
>+VALUES ( 'sms', 'sms');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'sms', 'language', 'en', 'Skolt Sami');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'sms', 'language', 'sms', 'sÃ¤Ã¤Ê¹mÇ©iÃµll');
>+
>+-- Somali
>+INSERT INTO language_subtag_registry( subtag, type, description, added)
>+VALUES ( 'so', 'language', 'Somali', '2017-04-21');
>+
>+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
>+VALUES ( 'so', 'som');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'so', 'language', 'en', 'Somali');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'so', 'language', 'so', 'Af-Soomaali');
>+
> -- Albanian
> INSERT INTO language_subtag_registry( subtag, type, description, added)
> VALUES ( 'sq', 'language', 'Albanian','2014-10-30');
>@@ -975,6 +1403,19 @@ VALUES ( 'sr', 'language', 'fr', 'Serbe');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES ( 'sr', 'language', 'de', 'Serbisch');
> 
>+-- Sotho
>+INSERT INTO language_subtag_registry( subtag, type, description, added)
>+VALUES ( 'st', 'language', 'Sotho', '2017-04-21');
>+
>+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
>+VALUES ( 'st', 'sot');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'st', 'language', 'en', 'Sotho');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'st', 'language', 'st', 'Sesotho');
>+
> -- Swedish
> INSERT INTO language_subtag_registry( subtag, type, description, added)
> VALUES ( 'sv', 'language', 'Swedish','2005-10-16' );
>@@ -1141,6 +1582,32 @@ VALUES ( 'vi', 'language', 'vi', 'ãè¶');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES ( 'vi', 'language', 'en', 'Vietnamese');
> 
>+-- Votic
>+INSERT INTO language_subtag_registry( subtag, type, description, added)
>+VALUES ( 'vot', 'language', 'Votic', '2017-04-21');
>+
>+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
>+VALUES ( 'vot', 'vot');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'vot', 'language', 'en', 'Votic');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'vot', 'language', 'vot', 'vaÄÄa ceeli');
>+
>+-- Yiddish
>+INSERT INTO language_subtag_registry( subtag, type, description, added)
>+VALUES ( 'yi', 'language', 'Yiddish', '2017-04-21');
>+
>+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
>+VALUES ( 'yi', 'yid');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'yi', 'language', 'en', 'Yiddish');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'yi', 'language', 'yi', '×××××©');
>+
> -- Chinese
> INSERT INTO language_subtag_registry( subtag, type, description, added)
> VALUES ( 'zh', 'language', 'Chinese','2005-10-16');
>-- 
>2.1.4

Actions: View | Diff | Splinter Review

Attachments on bug 18493: 62678 | 62679 | 63265 | 66688 | 167122 | 167123 | 167626