Bugzilla – Attachment 33127 Details for
Bug 12250
Update descriptions for languages, scripts and regions
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 12250: Update descriptions for languages, scripts and regions
Bug-12250-Update-descriptions-for-languages-script.patch (text/plain), 118.78 KB, created by
Bernardo Gonzalez Kriegel
on 2014-11-02 01:43:05 UTC
(
hide
)
Description:
Bug 12250: Update descriptions for languages, scripts and regions
Filename:
MIME Type:
Creator:
Bernardo Gonzalez Kriegel
Created:
2014-11-02 01:43:05 UTC
Size:
118.78 KB
patch
obsolete
>From f7d5c8cca06d027d6474631b5de1a57399bcbbfa Mon Sep 17 00:00:00 2001 >From: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com> >Date: Sat, 1 Nov 2014 20:04:49 -0300 >Subject: [PATCH] Bug 12250: Update descriptions for languages, scripts and > regions > >This patch adds/updates languages, scripts and regions to >reflect what we currently have on translation server. > >Languages, scripts and regions are ordered by respective code > >To test: >1. Apply the patch >2. run updatedatabase.pl, must run without errors >3. Go to advanced search (opac/staff), more options, and check >language pulldown (verify you have an empty AdvancedSearchLanguages >syspref) >4. Remove contents from language_descriptions, language_rfc4646_to_iso639, >language_script_bidi, language_script_mappin and language_subtag_registry >5. Load installer/data/mysql/mandatory/subtag_registry.sql, >must load without errors >6. Repeat 3 >--- > installer/data/mysql/mandatory/subtag_registry.sql | 1506 +++++++++++++++----- > installer/data/mysql/updatedatabase.pl | 382 +++++ > 2 files changed, 1544 insertions(+), 344 deletions(-) > >diff --git a/installer/data/mysql/mandatory/subtag_registry.sql b/installer/data/mysql/mandatory/subtag_registry.sql >index 1e642c0..ea396dd 100755 >--- a/installer/data/mysql/mandatory/subtag_registry.sql >+++ b/installer/data/mysql/mandatory/subtag_registry.sql >@@ -2,15 +2,15 @@ > > -- BIDI Stuff, Arabic and Hebrew > INSERT INTO language_script_bidi(rfc4646_subtag,bidi) >-VALUES( 'Arab', 'rtl'); >+VALUES ( 'Arab', 'rtl'); > INSERT INTO language_script_bidi(rfc4646_subtag,bidi) >-VALUES( 'Hebr', 'rtl'); >+VALUES ( 'Hebr', 'rtl'); > > -- Default mappings between script and language subcodes > INSERT INTO language_script_mapping(language_subtag,script_subtag) >-VALUES( 'ar', 'Arab'); >+VALUES ( 'ar', 'Arab'); > INSERT INTO language_script_mapping(language_subtag,script_subtag) >-VALUES( 'he', 'Hebr'); >+VALUES ( 'he', 'Hebr'); > > -- EXTENSIONS > -- Interface (i) >@@ -20,935 +20,1753 @@ INSERT INTO language_subtag_registry( subtag, type, description, added) > VALUES ( 'opac', 'i', 'OPAC','2005-10-16'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'opac', 'i', 'en', 'OPAC'); >+VALUES ( 'opac', 'i', 'en', 'OPAC'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'opac', 'i', 'fr', 'OPAC'); >+VALUES ( 'opac', 'i', 'fr', 'OPAC'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'opac', 'i', 'de', 'OPAC'); >+VALUES ( 'opac', 'i', 'de', 'OPAC'); > > -- Staff Client > INSERT INTO language_subtag_registry( subtag, type, description, added) > VALUES ( 'intranet', 'i', 'Staff Client','2005-10-16'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'intranet', 'i', 'en', 'Staff Client'); >+VALUES ( 'intranet', 'i', 'en', 'Staff Client'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'intranet', 'i', 'fr', '????'); >+VALUES ( 'intranet', 'i', 'fr', 'Client personnel'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'intranet', 'i', 'de', 'Dienstoberfläche'); >+VALUES ( 'intranet', 'i', 'de', 'Dienstoberfläche'); > > -- Theme (t) > INSERT INTO language_subtag_registry( subtag, type, description, added) > VALUES ( 'prog', 't', 'Prog','2005-10-16'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'prog', 't', 'en', 'Prog'); >+VALUES ( 'prog', 't', 'en', 'Prog'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'prog', 't', 'fr', 'Prog'); >+VALUES ( 'prog', 't', 'fr', 'Prog'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'prog', 't', 'de', 'Prog'); >+VALUES ( 'prog', 't', 'de', 'Prog'); > > -- LANGUAGES > >+-- Amharic >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'am', 'language', 'Amharic','2014-10-29'); >+ >+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >+VALUES ( 'am','amh'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'am', 'language', 'am', 'á ááá'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'am', 'language', 'en', 'Amharic'); >+ > -- Arabic > INSERT INTO language_subtag_registry( subtag, type, description, added) > VALUES ( 'ar', 'language', 'Arabic','2005-10-16'); > > INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >-VALUES( 'ar','ara'); >+VALUES ( 'ar','ara'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES ( 'ar', 'language', 'ar', 'العربية'); >+VALUES ( 'ar', 'language', 'ar', 'ÙعربÙØ©'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'ar', 'language', 'en', 'Arabic'); >+VALUES ( 'ar', 'language', 'en', 'Arabic'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'ar', 'language', 'fr', 'Arabe'); >+VALUES ( 'ar', 'language', 'fr', 'Arabe'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'ar', 'language', 'de', 'Arabisch'); >+VALUES ( 'ar', 'language', 'de', 'Arabisch'); > >--- Armenian >+-- Azerbaijani > INSERT INTO language_subtag_registry( subtag, type, description, added) >-VALUES ( 'hy', 'language', 'Armenian','2005-10-16'); >+VALUES ( 'az', 'language', 'Azerbaijani','2014-10-30'); > > INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >-VALUES( 'hy','arm'); >+VALUES ( 'az','aze'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES ( 'hy', 'language', 'hy', 'ÕÕ¡ÕµÕ¥ÖÕ¥Õ¶'); >+VALUES ( 'az', 'language', 'az', 'AzÉrbaycan dili'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'az', 'language', 'en', 'Azerbaijani'); >+ >+-- Byelorussian >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'be', 'language', 'Byelorussian','2014-10-30'); >+ >+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >+VALUES ( 'be','bel'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'be', 'language', 'be', 'ÐелаÑÑÑÐºÐ°Ñ Ð¼Ð¾Ð²Ð°'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'hy', 'language', 'en', 'Armenian'); >+VALUES ( 'be', 'language', 'en', 'Byelorussian'); >+ >+-- Bengali >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'bn', 'language', 'Bengali','2014-10-30'); >+ >+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >+VALUES ( 'bn','ben'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'hy', 'language', 'fr', 'Armenian'); >+VALUES ( 'bn', 'language', 'bn', 'বাà¦à¦²à¦¾'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'hy', 'language', 'de', 'Armenisch'); >+VALUES ( 'bn', 'language', 'en', 'Bengali'); > > -- Bulgarian > INSERT INTO language_subtag_registry( subtag, type, description, added) > VALUES ( 'bg', 'language', 'Bulgarian','2005-10-16'); > > INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >-VALUES( 'bg','bul'); >+VALUES ( 'bg','bul'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES ( 'bg', 'language', 'bg', 'Български'); >+VALUES ( 'bg', 'language', 'bg', 'ÐÑлгаÑÑки'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'bg', 'language', 'en', 'Bulgarian'); >+VALUES ( 'bg', 'language', 'en', 'Bulgarian'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'bg', 'language', 'fr', 'Bulgare'); >+VALUES ( 'bg', 'language', 'fr', 'Bulgare'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'bg', 'language', 'de', 'Bulgarisch'); >+VALUES ( 'bg', 'language', 'de', 'Bulgarisch'); > >--- Chinese >+-- Catalan > INSERT INTO language_subtag_registry( subtag, type, description, added) >-VALUES ( 'zh', 'language', 'Chinese','2005-10-16'); >+VALUES ( 'ca', 'language', 'Catalan','2013-01-12' ); > > INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >-VALUES( 'zh','chi'); >+VALUES ( 'ca','cat'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'ca', 'language', 'es', 'Catalán'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES ( 'zh', 'language', 'zh', '中文'); >+VALUES ( 'ca', 'language', 'en', 'Catalan'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'zh', 'language', 'en', 'Chinese'); >+VALUES ( 'ca', 'language', 'fr', 'Catalan'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'zh', 'language', 'fr', 'Chinois'); >+VALUES ( 'ca', 'language', 'ca', 'Català '); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'zh', 'language', 'de', 'Chinesisch'); >+VALUES ( 'ca', 'language', 'de', 'Katalanisch'); > > -- Czech > INSERT INTO language_subtag_registry( subtag, type, description, added) > VALUES ( 'cs', 'language', 'Czech','2005-10-16' ); > > INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >-VALUES( 'cs','cze'); >+VALUES ( 'cs','cze'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES ( 'cs', 'language', 'cs', 'čeština'); >+VALUES ( 'cs', 'language', 'cs', 'CeÅ¡tina'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'cs', 'language', 'en', 'Czech'); >+VALUES ( 'cs', 'language', 'en', 'Czech'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'cs', 'language', 'fr', 'Tchèque'); >+VALUES ( 'cs', 'language', 'fr', 'Tchèque'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'cs', 'language', 'de', 'Tschechisch'); >+VALUES ( 'cs', 'language', 'de', 'Tschechisch'); > > -- Danish > INSERT INTO language_subtag_registry( subtag, type, description, added) > VALUES ( 'da', 'language', 'Danish','2005-10-16' ); > > INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >-VALUES( 'da','dan'); >+VALUES ( 'da','dan'); > > INSERT INTO language_descriptions(subtag, type, lang, description) > VALUES ( 'da', 'language', 'da', 'Dansk'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'da', 'language', 'en', 'Danish'); >+VALUES ( 'da', 'language', 'en', 'Danish'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'da', 'language', 'fr', 'Danois'); >+VALUES ( 'da', 'language', 'fr', 'Danois'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'da', 'language', 'de', 'Dänisch'); >+VALUES ( 'da', 'language', 'de', 'Dänisch'); > >--- Dutch, Flemish >+-- German > INSERT INTO language_subtag_registry( subtag, type, description, added) >-VALUES ( 'nl', 'language', 'Dutch','2005-10-16' ); >+VALUES ( 'de', 'language', 'German','2005-10-16' ); > > INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >-VALUES( 'nl','dut'); >+VALUES ( 'de','ger'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES ( 'nl', 'language', 'nl', 'Nederlands'); >+VALUES ( 'de', 'language', 'de', 'Deutsch'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'nl', 'language', 'en', 'Dutch'); >+VALUES ( 'de', 'language', 'en', 'German'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'nl', 'language', 'fr', 'Néerlandais'); >+VALUES ( 'de', 'language', 'fr', 'Allemand'); >+ >+-- Greek >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'el', 'language', 'Greek, Modern [1453- ]','2005-10-16'); >+ >+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >+VALUES ( 'el','gre'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'el', 'language', 'el', 'Eλληνικά'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'nl', 'language', 'de', 'Niederländisch'); >+VALUES ( 'el', 'language', 'en', 'Greek, Modern [1453- ]'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'el', 'language', 'fr', 'Grec Moderne (Après 1453)'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'el', 'language', 'de', 'Griechisch (Moern [1453- ]'); > > -- English > INSERT INTO language_subtag_registry( subtag, type, description, added) > VALUES ( 'en', 'language', 'English','2005-10-16' ); > > INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >-VALUES( 'en','eng'); >+VALUES ( 'en','eng'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'en', 'language', 'en', 'English'); >+VALUES ( 'en', 'language', 'en', 'English'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'en', 'language', 'fr', 'Anglais'); >+VALUES ( 'en', 'language', 'fr', 'Anglais'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'en', 'language', 'de', 'Englisch'); >+VALUES ( 'en', 'language', 'de', 'Englisch'); > >--- Finnish >+-- Spanish, Castilian > INSERT INTO language_subtag_registry( subtag, type, description, added) >-VALUES ( 'fi', 'language', 'Finnish','2005-10-16' ); >+VALUES ( 'es', 'language', 'Spanish','2005-10-16' ); > > INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >-VALUES( 'fi','fin'); >+VALUES ( 'es','spa'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'fi', 'language', 'fi', 'suomi'); >+VALUES ( 'es', 'language', 'es', 'Español'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'fi', 'language', 'en', 'Finnish'); >+VALUES ( 'es', 'language', 'en', 'Spanish'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'fi', 'language', 'de', 'Finnisch'); >+VALUES ( 'es', 'language', 'fr', 'Espagnol'); > >--- French >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'es', 'language', 'de', 'Spanisch'); >+ >+-- Basque > INSERT INTO language_subtag_registry( subtag, type, description, added) >-VALUES ( 'fr', 'language', 'French','2005-10-16' ); >+VALUES ( 'eu', 'language', 'Basque','2014-10-30'); >+ >+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >+VALUES ( 'eu','eus'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'eu', 'language', 'eu', 'Euskera'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'eu', 'language', 'en', 'Basque'); >+ >+-- Persian >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'fa', 'language', 'Persian','2005-10-16'); > > INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >-VALUES( 'fr','fre'); >+VALUES ( 'fa','per'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'fr', 'language', 'en', 'French'); >+VALUES ( 'fa', 'language', 'fa', 'ÙارسÙ'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'fr', 'language', 'fr', 'Français'); >+VALUES ( 'fa', 'language', 'en', 'Persian'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'fr', 'language', 'de', 'Französisch'); >+VALUES ( 'fa', 'language', 'fr', 'Persan'); > >--- INSERT INTO language_descriptions(subtag, type, lang, description) >--- VALUES( 'fr-CA', 'language', 'fr-CA', 'français'); >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'fa', 'language', 'de', 'Persisch'); > >--- Lao >+-- Finnish > INSERT INTO language_subtag_registry( subtag, type, description, added) >-VALUES ( 'lo', 'language', 'Lao','2005-10-16' ); >+VALUES ( 'fi', 'language', 'Finnish','2005-10-16' ); > > INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >-VALUES( 'lo','lao'); >+VALUES ( 'fi','fin'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'lo', 'language', 'lo', 'ພາສາລາວ'); >+VALUES ( 'fi', 'language', 'fi', 'Suomi'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'lo', 'language', 'en', 'Lao'); >+VALUES ( 'fi', 'language', 'en', 'Finnish'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'lo', 'language', 'fr', 'Laotien'); >+VALUES ( 'fi', 'language', 'de', 'Finnisch'); >+ >+-- Faroese >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'fo', 'language', 'Faroese','2014-10-30'); >+ >+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >+VALUES ( 'fo','fao'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'lo', 'language', 'de', 'Laotisch'); >+VALUES ( 'fo', 'language', 'fo', 'Føroyskt'); > >--- German >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'fo', 'language', 'en', 'Faroese'); >+ >+-- French > INSERT INTO language_subtag_registry( subtag, type, description, added) >-VALUES ( 'de', 'language', 'German','2005-10-16' ); >+VALUES ( 'fr', 'language', 'French','2005-10-16' ); > > INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >-VALUES( 'de','ger'); >+VALUES ( 'fr','fre'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'de', 'language', 'de', 'Deutsch'); >+VALUES ( 'fr', 'language', 'en', 'French'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'de', 'language', 'en', 'German'); >+VALUES ( 'fr', 'language', 'fr', 'Français'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'de', 'language', 'fr', 'Allemand'); >+VALUES ( 'fr', 'language', 'de', 'Französisch'); > >--- Greek >+-- Galician > INSERT INTO language_subtag_registry( subtag, type, description, added) >-VALUES ( 'el', 'language', 'Greek, Modern [1453- ]','2005-10-16'); >+VALUES ( 'gl', 'language', 'Galician','2005-10-16' ); > > INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >-VALUES( 'el','gre'); >+VALUES ( 'gl','glg'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'el', 'language', 'el', 'ελληνικά'); >+VALUES ( 'gl', 'language', 'gl', 'Galego'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'el', 'language', 'en', 'Greek, Modern [1453- ]'); >+VALUES ( 'gl', 'language', 'en', 'Galician'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'el', 'language', 'fr', 'Grec Moderne (Après 1453)'); >+VALUES ( 'gl', 'language', 'fr', 'Galicien'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'el', 'language', 'de', 'Griechisch (Moern [1453- ]'); >+VALUES ( 'gl', 'language', 'de', 'Galicisch'); > > -- Hebrew > INSERT INTO language_subtag_registry( subtag, type, description, added) > VALUES ( 'he', 'language', 'Hebrew','2005-10-16'); > > INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >-VALUES( 'he','heb'); >+VALUES ( 'he','heb'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'he', 'language', 'he', 'עברית'); >+VALUES ( 'he', 'language', 'he', '×¢Ö´×ְרִ×ת'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'he', 'language', 'en', 'Hebrew'); >+VALUES ( 'he', 'language', 'en', 'Hebrew'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'he', 'language', 'fr', 'Hébreu'); >+VALUES ( 'he', 'language', 'fr', 'Hébreu'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'he', 'language', 'de', 'Hebräisch'); >+VALUES ( 'he', 'language', 'de', 'Hebräisch'); > > -- Hindi > INSERT INTO language_subtag_registry( subtag, type, description, added) > VALUES ( 'hi', 'language', 'Hindi','2005-10-16'); > > INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >-VALUES( 'hi','hin'); >+VALUES ( 'hi','hin'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'hi', 'language', 'hi', 'हिन्दी'); >+VALUES ( 'hi', 'language', 'hi', 'हिनà¥à¤¦à¥'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'hi', 'language', 'en', 'Hindi'); >+VALUES ( 'hi', 'language', 'en', 'Hindi'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'hi', 'language', 'fr', 'Hindi'); >+VALUES ( 'hi', 'language', 'fr', 'Hindi'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'hi', 'language', 'de', 'Hindi'); >+VALUES ( 'hi', 'language', 'de', 'Hindi'); > >--- Hungarian >+-- Croatian > INSERT INTO language_subtag_registry( subtag, type, description, added) >-VALUES ( 'hu', 'language', 'Hungarian','2005-10-16' ); >+VALUES ( 'hr', 'language', 'Croatian','2014-07-24' ); > > INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >-VALUES( 'hu','hun'); >+VALUES ( 'hr','hrv'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'hu', 'language', 'hu', 'Magyar'); >+VALUES ( 'hr', 'language', 'hr', 'Hrvatski'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'hu', 'language', 'en', 'Hungarian'); >+VALUES ( 'hr', 'language', 'en', 'Croatian'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'hu', 'language', 'fr', 'Hongrois'); >+VALUES ( 'hr', 'language', 'fr', 'Croate'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'hu', 'language', 'de', 'Ungarisch'); >+VALUES ( 'hr', 'language', 'de', 'Kroatisch'); > >--- Indonesian >+-- Hungarian > INSERT INTO language_subtag_registry( subtag, type, description, added) >-VALUES ( 'id', 'language', 'Indonesian','2005-10-16' ); >+VALUES ( 'hu', 'language', 'Hungarian','2005-10-16' ); > > INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >-VALUES( 'id','ind'); >+VALUES ( 'hu','hun'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'id', 'language', 'id', 'Bahasa Indonesia'); >+VALUES ( 'hu', 'language', 'hu', 'Magyar'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'id', 'language', 'en', 'Indonesian'); >+VALUES ( 'hu', 'language', 'en', 'Hungarian'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'id', 'language', 'fr', 'Indonésien'); >+VALUES ( 'hu', 'language', 'fr', 'Hongrois'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'id', 'language', 'de', 'Indonesisch'); >+VALUES ( 'hu', 'language', 'de', 'Ungarisch'); > >--- Italian >+-- Armenian > INSERT INTO language_subtag_registry( subtag, type, description, added) >-VALUES ( 'it', 'language', 'Italian','2005-10-16' ); >+VALUES ( 'hy', 'language', 'Armenian','2005-10-16'); > > INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >-VALUES( 'it','ita'); >+VALUES ( 'hy','arm'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'it', 'language', 'it', 'Italiano'); >+VALUES ( 'hy', 'language', 'hy', 'ÕÕ¡ÕµÕ¥ÖÕ¥Õ¶'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'it', 'language', 'en', 'Italian'); >+VALUES ( 'hy', 'language', 'en', 'Armenian'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'it', 'language', 'fr', 'Italien'); >+VALUES ( 'hy', 'language', 'fr', 'Armenian'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'it', 'language', 'de', 'Italienisch'); >+VALUES ( 'hy', 'language', 'de', 'Armenisch'); > >--- Japanese >+-- Indonesian > INSERT INTO language_subtag_registry( subtag, type, description, added) >-VALUES ( 'ja', 'language', 'Japanese','2005-10-16'); >+VALUES ( 'id', 'language', 'Indonesian','2005-10-16' ); > > INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >-VALUES( 'ja','jpn'); >+VALUES ( 'id','ind'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'ja', 'language', 'ja', '日本語'); >+VALUES ( 'id', 'language', 'id', 'Bahasa Indonesia'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'ja', 'language', 'en', 'Japanese'); >+VALUES ( 'id', 'language', 'en', 'Indonesian'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'ja', 'language', 'fr', 'Japonais'); >+VALUES ( 'id', 'language', 'fr', 'Indonésien'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'ja', 'language', 'de', 'Japanisch'); >+VALUES ( 'id', 'language', 'de', 'Indonesisch'); > >--- Korean >+-- Icelandic > INSERT INTO language_subtag_registry( subtag, type, description, added) >-VALUES ( 'ko', 'language', 'Korean','2005-10-16'); >+VALUES ( 'is', 'language', 'Icelandic','2014-10-30'); >+ >+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >+VALUES ( 'is','ice'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'is', 'language', 'is', 'Ãslenska'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'is', 'language', 'en', 'Icelandic'); >+ >+-- Italian >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'it', 'language', 'Italian','2005-10-16' ); > > INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >-VALUES( 'ko','kor'); >+VALUES ( 'it','ita'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'ko', 'language', 'ko', '한국어'); >+VALUES ( 'it', 'language', 'it', 'Italiano'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'ko', 'language', 'en', 'Korean'); >+VALUES ( 'it', 'language', 'en', 'Italian'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'ko', 'language', 'fr', 'Coréen'); >+VALUES ( 'it', 'language', 'fr', 'Italien'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'ko', 'language', 'de', 'Koreanisch'); >+VALUES ( 'it', 'language', 'de', 'Italienisch'); > >--- Latin >+-- Japanese > INSERT INTO language_subtag_registry( subtag, type, description, added) >-VALUES ( 'la', 'language', 'Latin','2005-10-16' ); >+VALUES ( 'ja', 'language', 'Japanese','2005-10-16'); > > INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >-VALUES( 'la','lat'); >+VALUES ( 'ja','jpn'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'la', 'language', 'la', 'Latina'); >+VALUES ( 'ja', 'language', 'ja', 'æ¥æ¬èª'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'la', 'language', 'en', 'Latin'); >+VALUES ( 'ja', 'language', 'en', 'Japanese'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'la', 'language', 'fr', 'Latin'); >+VALUES ( 'ja', 'language', 'fr', 'Japonais'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'la', 'language', 'de', 'Latein'); >- >--- Galician >+VALUES ( 'ja', 'language', 'de', 'Japanisch'); > >+-- Kannada > INSERT INTO language_subtag_registry( subtag, type, description, added) >-VALUES ( 'gl', 'language', 'Galician','2005-10-16' ); >+VALUES ( 'ka', 'language', 'Kannada','2014-10-30'); > > INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >-VALUES( 'gl','glg'); >+VALUES ( 'ka','kan'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'gl', 'language', 'gl', 'Galego'); >+VALUES ( 'ka', 'language', 'ka', 'à²à²¨à³à²¨à²¡'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'gl', 'language', 'en', 'Galician'); >+VALUES ( 'ka', 'language', 'en', 'Kannada'); > >-INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'gl', 'language', 'fr', 'Galicien'); >+-- Khmer >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'km', 'language', 'Khmer','2014-10-30'); >+ >+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >+VALUES( 'km','khm'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'gl', 'language', 'de', 'Galicisch'); >+VALUES ( 'km', 'language', 'km', 'áá¶áá¶ááááá'); > >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES( 'km', 'language', 'en', 'Khmer'); > >--- Norwegian (bokmÃ¥l) >+-- Korean > INSERT INTO language_subtag_registry( subtag, type, description, added) >-VALUES ( 'nb', 'language', 'Norwegian bokmål','2005-10-16' ); >- >-INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >-VALUES( 'nb','nor'); >+VALUES ( 'ko', 'language', 'Korean','2005-10-16'); > > INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >-VALUES( 'nb','nob'); >+VALUES ( 'ko','kor'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'nb', 'language', 'nb', 'Norsk bokmål'); >+VALUES ( 'ko', 'language', 'ko', 'íêµì´'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'nb', 'language', 'en', 'Norwegian bokmål'); >+VALUES ( 'ko', 'language', 'en', 'Korean'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'nb', 'language', 'fr', 'Norvégien bokmål'); >+VALUES ( 'ko', 'language', 'fr', 'Coréen'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'nb', 'language', 'de', 'Norwegisch bokmål'); >+VALUES ( 'ko', 'language', 'de', 'Koreanisch'); > >--- Norwegian (nynorsk) >+-- Kurdish > INSERT INTO language_subtag_registry( subtag, type, description, added) >-VALUES ( 'nn', 'language', 'Norwegian nynorsk','2011-02-14' ); >+VALUES ( 'ku', 'language', 'Kurdish','2014-05-13'); > > INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >-VALUES( 'nn','nno'); >+VALUES ( 'ku','kur'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'nn', 'language', 'nb', 'Norsk nynorsk'); >+VALUES ( 'ku', 'language', 'ku', 'Ú©ÙردÛ'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'nn', 'language', 'nn', 'Norsk nynorsk'); >+VALUES ( 'ku', 'language', 'en', 'Kurdish'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'nn', 'language', 'en', 'Norwegian nynorsk'); >+VALUES ( 'ku', 'language', 'fr', 'Kurde'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'nn', 'language', 'fr', 'Norvégien nynorsk'); >+VALUES ( 'ku', 'language', 'de', 'Kurdisch'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'nn', 'language', 'de', 'Norwegisch nynorsk'); >+VALUES ( 'ku', 'language', 'es', 'Kurdo'); > >--- Persian >+-- Latin > INSERT INTO language_subtag_registry( subtag, type, description, added) >-VALUES ( 'fa', 'language', 'Persian','2005-10-16'); >+VALUES ( 'la', 'language', 'Latin','2005-10-16' ); > > INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >-VALUES( 'fa','per'); >+VALUES ( 'la','lat'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'fa', 'language', 'fa', 'فارسى'); >+VALUES ( 'la', 'language', 'la', 'Latina'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'fa', 'language', 'en', 'Persian'); >+VALUES ( 'la', 'language', 'en', 'Latin'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'fa', 'language', 'fr', 'Persan'); >+VALUES ( 'la', 'language', 'fr', 'Latin'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'fa', 'language', 'de', 'Persisch'); >+VALUES ( 'la', 'language', 'de', 'Latein'); > >--- Polish >+-- Lao > INSERT INTO language_subtag_registry( subtag, type, description, added) >-VALUES ( 'pl', 'language', 'Polish','2005-10-16' ); >+VALUES ( 'lo', 'language', 'Lao','2005-10-16' ); > > INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >-VALUES( 'pl','pol'); >+VALUES ( 'lo','lao'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'pl', 'language', 'pl', 'Polski'); >+VALUES ( 'lo', 'language', 'lo', 'àºàº²àºªàº²àº¥àº²àº§'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'pl', 'language', 'en', 'Polish'); >+VALUES ( 'lo', 'language', 'en', 'Lao'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'pl', 'language', 'fr', 'Polonais'); >+VALUES ( 'lo', 'language', 'fr', 'Laotien'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'pl', 'language', 'de', 'Polnisch'); >+VALUES ( 'lo', 'language', 'de', 'Laotisch'); > >--- Portuguese >+-- Maori > INSERT INTO language_subtag_registry( subtag, type, description, added) >-VALUES ( 'pt', 'language', 'Portuguese','2005-10-16' ); >+VALUES ( 'mi', 'language', 'Maori','2014-10-30'); > > INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >-VALUES( 'pt','por'); >+VALUES ( 'mi','mri'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'pt', 'language', 'pt', 'Português'); >+VALUES ( 'mi', 'language', 'mi', 'Te Reo MÄori'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'pt', 'language', 'en', 'Portuguese'); >+VALUES ( 'mi', 'language', 'en', 'Maori'); >+ >+-- Mongolian >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'mn', 'language', 'Mongolian','2014-10-30'); >+ >+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >+VALUES ( 'mn','mon'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'pt', 'language', 'fr', 'Portugais'); >+VALUES ( 'mn', 'language', 'mn', 'Mонгол'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'pt', 'language', 'de', 'Portugiesisch'); >+VALUES ( 'mn', 'language', 'en', 'Mongolian'); > >--- Romanian >+-- Marathi > INSERT INTO language_subtag_registry( subtag, type, description, added) >-VALUES ( 'ro', 'language', 'Romanian','2005-10-16' ); >+VALUES ( 'mr', 'language', 'Marathi','2014-10-30'); > > INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >-VALUES( 'ro','rum'); >+VALUES ( 'mr','mar'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'ro', 'language', 'ro', 'Română'); >+VALUES ( 'mr', 'language', 'mr', 'मराठà¥'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'ro', 'language', 'en', 'Romanian'); >+VALUES ( 'mr', 'language', 'en', 'Marathi'); >+ >+-- Malay >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'ms', 'language', 'Malay','2014-10-30'); >+ >+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >+VALUES ( 'ms','may'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'ro', 'language', 'fr', 'Roumain'); >+VALUES ( 'ms', 'language', 'ms', 'Bahasa melayu'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'ro', 'language', 'de', 'Rumänisch'); >+VALUES ( 'ms', 'language', 'en', 'Malay'); > >--- Russian >+-- Norwegian (bokmÃ¥l) > INSERT INTO language_subtag_registry( subtag, type, description, added) >-VALUES ( 'ru', 'language', 'Russian','2005-10-16'); >+VALUES ( 'nb', 'language', 'Norwegian bokmÃ¥l','2005-10-16' ); > > INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >-VALUES( 'ru','rus'); >+VALUES ( 'nb','nob'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'ru', 'language', 'ru', 'Русский'); >+VALUES ( 'nb', 'language', 'nb', 'Norsk bokmÃ¥l'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'ru', 'language', 'en', 'Russian'); >+VALUES ( 'nb', 'language', 'en', 'Norwegian bokmÃ¥l'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'ru', 'language', 'fr', 'Russe'); >+VALUES ( 'nb', 'language', 'fr', 'Norvégien bokmÃ¥l'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'ru', 'language', 'de', 'Russisch'); >+VALUES ( 'nb', 'language', 'de', 'Norwegisch bokmÃ¥l'); > >--- Serbian >+-- Nepali > INSERT INTO language_subtag_registry( subtag, type, description, added) >-VALUES ( 'sr', 'language', 'Serbian','2005-10-16' ); >+VALUES ( 'ne', 'language', 'Nepali','2014-10-30'); > > INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >-VALUES( 'sr','srp'); >- >-INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'sr', 'language', 'sr', 'српски'); >+VALUES ( 'ne','nep'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'sr', 'language', 'en', 'Serbian'); >+VALUES ( 'ne', 'language', 'ne', 'नà¥à¤ªà¤¾à¤²à¥'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'sr', 'language', 'fr', 'Serbe'); >+VALUES ( 'ne', 'language', 'en', 'Nepali'); > >-INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'sr', 'language', 'de', 'Serbisch'); >- >--- Spanish, Castilian >+-- Dutch > INSERT INTO language_subtag_registry( subtag, type, description, added) >-VALUES ( 'es', 'language', 'Spanish','2005-10-16' ); >+VALUES ( 'nl', 'language', 'Dutch','2005-10-16' ); > > INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >-VALUES( 'es','spa'); >+VALUES ( 'nl','dut'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'es', 'language', 'es', 'Español'); >+VALUES ( 'nl', 'language', 'nl', 'Nederlands'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'es', 'language', 'en', 'Spanish'); >+VALUES ( 'nl', 'language', 'en', 'Dutch'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'es', 'language', 'fr', 'Espagnol'); >+VALUES ( 'nl', 'language', 'fr', 'Néerlandais'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'es', 'language', 'de', 'Spanisch'); >+VALUES ( 'nl', 'language', 'de', 'Niederländisch'); > >--- Spanish, Catalan >+-- Norwegian (nynorsk) > INSERT INTO language_subtag_registry( subtag, type, description, added) >-VALUES ( 'ca', 'language', 'Catalan','2013-01-12' ); >+VALUES ( 'nn', 'language', 'Norwegian nynorsk','2011-02-14' ); > > INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >-VALUES( 'ca','cat'); >+VALUES ( 'nn','nno'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'ca', 'language', 'es', 'Catalán'); >+VALUES ( 'nn', 'language', 'nb', 'Norsk nynorsk'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'ca', 'language', 'en', 'Catalan'); >+VALUES ( 'nn', 'language', 'nn', 'Norsk nynorsk'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'ca', 'language', 'fr', 'Catalan'); >+VALUES ( 'nn', 'language', 'en', 'Norwegian nynorsk'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'ca', 'language', 'ca', 'Català '); >+VALUES ( 'nn', 'language', 'fr', 'Norvégien nynorsk'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'ca', 'language', 'de', 'Katalanisch'); >+VALUES ( 'nn', 'language', 'de', 'Norwegisch nynorsk'); > >--- Swedish >+-- Pangwa > INSERT INTO language_subtag_registry( subtag, type, description, added) >-VALUES ( 'sv', 'language', 'Swedish','2005-10-16' ); >+VALUES ( 'pbr', 'language', 'Pangwa','2014-10-30'); > > INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >-VALUES( 'sv','swe'); >- >-INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'sv', 'language', 'sv', 'Svenska'); >- >-INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'sv', 'language', 'en', 'Swedish'); >+VALUES ( 'pbr','pbr'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'sv', 'language', 'fr', 'Suédois'); >+VALUES ( 'pbr', 'language', 'pbr', 'Ekipangwa'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'sv', 'language', 'de', 'Schwedisch'); >+VALUES ( 'pbr', 'language', 'en', 'Pangwa'); > >--- Tetum >+-- Polish > INSERT INTO language_subtag_registry( subtag, type, description, added) >-VALUES ( 'tet', 'language', 'Tetum','2005-10-16' ); >+VALUES ( 'pl', 'language', 'Polish','2005-10-16' ); > > INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >-VALUES( 'tet','tet'); >+VALUES ( 'pl','pol'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'tet', 'language', 'tet', 'tetun'); >+VALUES ( 'pl', 'language', 'pl', 'Polski'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'tet', 'language', 'en', 'Tetum'); >+VALUES ( 'pl', 'language', 'en', 'Polish'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'tet', 'language', 'fr', 'Tétoum'); >+VALUES ( 'pl', 'language', 'fr', 'Polonais'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'tet', 'language', 'de', 'Tetum'); >+VALUES ( 'pl', 'language', 'de', 'Polnisch'); > >--- Thai >+-- Dari > INSERT INTO language_subtag_registry( subtag, type, description, added) >-VALUES ( 'th', 'language', 'Thai','2005-10-16'); >+VALUES ( 'prs', 'language', 'Dari','2014-10-30'); > > INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >-VALUES( 'th','tha'); >- >-INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'th', 'language', 'th', 'ภาษาไทย'); >- >-INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'th', 'language', 'en', 'Thai'); >+VALUES ( 'prs','prs'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'th', 'language', 'fr', 'Thaï'); >+VALUES ( 'prs', 'language', 'prs', 'درÙ'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'th', 'language', 'de', 'Thailändisch'); >+VALUES ( 'prs', 'language', 'en', 'Dari'); > >--- Turkish >+-- Portuguese > INSERT INTO language_subtag_registry( subtag, type, description, added) >-VALUES ( 'tr', 'language', 'Turkish','2005-10-16' ); >+VALUES ( 'pt', 'language', 'Portuguese','2005-10-16' ); > > INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >-VALUES( 'tr','tur'); >+VALUES ( 'pt','por'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'tr', 'language', 'tr', 'Türkçe'); >+VALUES ( 'pt', 'language', 'pt', 'Português'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'tr', 'language', 'en', 'Turkish'); >+VALUES ( 'pt', 'language', 'en', 'Portuguese'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'tr', 'language', 'fr', 'Turc'); >+VALUES ( 'pt', 'language', 'fr', 'Portugais'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'tr', 'language', 'de', 'Türkisch'); >+VALUES ( 'pt', 'language', 'de', 'Portugiesisch'); > >--- Ukranian >+-- Romanian > INSERT INTO language_subtag_registry( subtag, type, description, added) >-VALUES ( 'uk', 'language', 'Ukranian','2005-10-16'); >+VALUES ( 'ro', 'language', 'Romanian','2005-10-16' ); > > INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >-VALUES( 'uk','ukr'); >+VALUES ( 'ro','rum'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'uk', 'language', 'uk', 'Українська'); >+VALUES ( 'ro', 'language', 'ro', 'Român'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'uk', 'language', 'en', 'Ukranian'); >+VALUES ( 'ro', 'language', 'en', 'Romanian'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'uk', 'language', 'fr', 'Ukrainien'); >+VALUES ( 'ro', 'language', 'fr', 'Roumain'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'uk', 'language', 'de', 'Ukrainisch'); >+VALUES ( 'ro', 'language', 'de', 'Rumänisch'); > >--- Urdu >+-- Russian > INSERT INTO language_subtag_registry( subtag, type, description, added) >-VALUES ( 'ur', 'language', 'Urdu','2005-10-16' ); >+VALUES ( 'ru', 'language', 'Russian','2005-10-16'); > > INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >-VALUES( 'ur','urd'); >+VALUES ( 'ru','rus'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'ur', 'language', 'en', 'Urdu'); >+VALUES ( 'ru', 'language', 'ru', 'Ð ÑÑÑкий'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'ur', 'language', 'ur', 'اردو'); >+VALUES ( 'ru', 'language', 'en', 'Russian'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'ur', 'language', 'fr', 'Ourdou'); >+VALUES ( 'ru', 'language', 'fr', 'Russe'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'ur', 'language', 'de', 'Urdu'); >+VALUES ( 'ru', 'language', 'de', 'Russisch'); > >--- SCRIPTS >--- Arabic >+-- Kinyarwanda > INSERT INTO language_subtag_registry( subtag, type, description, added) >-VALUES ( 'Arab', 'script', 'Arabic','2005-10-16'); >+VALUES ( 'rw', 'language', 'Kinyarwanda','2014-10-30'); >+ >+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >+VALUES ( 'rw','kin'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES ( 'Arab','script', 'Arab', 'العربية'); >+VALUES ( 'rw', 'language', 'rw', 'Ikinyarwanda'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'Arab', 'script','en', 'Arabic'); >+VALUES ( 'rw', 'language', 'en', 'Kinyarwanda'); >+ >+-- Sindhi >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'sd', 'language', 'Sindhi','2014-10-30'); >+ >+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >+VALUES ( 'sd','snd'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'Arab', 'script','fr', 'Arabic'); >+VALUES ( 'sd', 'language', 'sd', 'سÙÚÙ'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'Arab', 'script', 'de', 'Arabisch'); >+VALUES ( 'sd', 'language', 'en', 'Sindhi'); > >--- Cyrillic >+-- Slovak > INSERT INTO language_subtag_registry( subtag, type, description, added) >-VALUES ( 'Cyrl', 'script', 'Cyrillic','2005-10-16'); >+VALUES ( 'sk', 'language', 'Slovak','2014-10-30'); > >-INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES ( 'Cyrl', 'script', 'Cyrl', '????'); >+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >+VALUES ( 'sk','slk'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'Cyrl', 'script', 'en', 'Cyrillic'); >+VALUES ( 'sk', 'language', 'sk', 'SlovenÄina'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'Cyrl', 'script', 'fr', 'Cyrillic'); >+VALUES ( 'sk', 'language', 'en', 'Slovak'); >+ >+-- Slovene >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'sl', 'language', 'Slovene','2014-10-30'); >+ >+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >+VALUES ( 'sl','slv'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'Cyrl', 'script', 'de', 'Kyrillisch'); >+VALUES ( 'sl', 'language', 'sl', 'SlovenÅ¡Äina'); > >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'sl', 'language', 'en', 'Slovene'); > >--- Greek >+-- Albanian > INSERT INTO language_subtag_registry( subtag, type, description, added) >-VALUES ( 'Grek', 'script', 'Greek','2005-10-16'); >+VALUES ( 'sq', 'language', 'Albanian','2014-10-30'); >+ >+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >+VALUES ( 'sq','sqi'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES ( 'Grek', 'script', 'Grek', '????'); >+VALUES ( 'sq', 'language', 'sq', 'Shqip'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'Grek', 'script', 'en', 'Greek'); >+VALUES ( 'sq', 'language', 'en', 'Albanian'); >+ >+-- Serbian >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'sr', 'language', 'Serbian','2005-10-16' ); >+ >+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >+VALUES ( 'sr','srp'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'Grek', 'script', 'fr', 'Greek'); >+VALUES ( 'sr', 'language', 'sr', 'CÑпÑки'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'Grek', 'script', 'de', 'Griechisch'); >+VALUES ( 'sr', 'language', 'en', 'Serbian'); > >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'sr', 'language', 'fr', 'Serbe'); > >--- Han - Simplified >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'sr', 'language', 'de', 'Serbisch'); >+ >+-- Swedish > INSERT INTO language_subtag_registry( subtag, type, description, added) >-VALUES ( 'Hans', 'script', 'Han (Simplified variant)','2005-10-16'); >+VALUES ( 'sv', 'language', 'Swedish','2005-10-16' ); > >-INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES ( 'Hans', 'script', 'Hans', 'Han (Simplified variant)'); >+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >+VALUES ( 'sv','swe'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'Hans', 'script', 'en', 'Han (Simplified variant)'); >+VALUES ( 'sv', 'language', 'sv', 'Svenska'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'Hans', 'script', 'fr', 'Han (Simplified variant)'); >+VALUES ( 'sv', 'language', 'en', 'Swedish'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'Hans', 'script', 'de', 'Han (Vereinfachte Variante)'); >+VALUES ( 'sv', 'language', 'fr', 'Suédois'); > >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'sv', 'language', 'de', 'Schwedisch'); > >--- Han - Traditional >+-- Swahili > INSERT INTO language_subtag_registry( subtag, type, description, added) >-VALUES ( 'Hant', 'script', 'Han (Traditional variant)','2005-10-16'); >+VALUES ( 'sw', 'language', 'Swahili','2014-10-30'); > >-INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES ( 'Hant', 'script', 'Hant', 'Han (Traditional variant)'); >+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >+VALUES ( 'sw','swa'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'Hant', 'script', 'en', 'Han (Traditional variant)'); >+VALUES ( 'sw', 'language', 'sw', 'Kiswahili'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'Hant', 'script', 'de', 'Han (Traditionelle Variante)'); >+VALUES ( 'sw', 'language', 'en', 'Swahili'); > >--- Hebrew >+-- Tamil > INSERT INTO language_subtag_registry( subtag, type, description, added) >-VALUES ( 'Hebr', 'script', 'Hebrew','2005-10-16'); >+VALUES ( 'ta', 'language', 'Tamil','2014-10-30'); > >-INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES ( 'Hebr', 'script', 'Hebr', 'Hebrew'); >+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >+VALUES ( 'ta','tam'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'Hebr', 'script', 'en', 'Hebrew'); >+VALUES ( 'ta', 'language', 'ta', 'தமிழà¯'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'Hebr', 'script', 'de', 'Hebräisch'); >+VALUES ( 'ta', 'language', 'en', 'Tamil'); > >--- Lao >+-- Tetum > INSERT INTO language_subtag_registry( subtag, type, description, added) >-VALUES ( 'Laoo', 'script', 'Lao','2005-10-16'); >+VALUES ( 'tet', 'language', 'Tetum','2005-10-16' ); >+ >+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >+VALUES ( 'tet','tet'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES ( 'Laoo', 'script', 'lo', 'Lao'); >+VALUES ( 'tet', 'language', 'tet', 'Tetun'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'Laoo', 'script', 'en', 'Lao'); >+VALUES ( 'tet', 'language', 'en', 'Tetum'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'Laoo', 'script', 'de', 'Laotisch'); >+VALUES ( 'tet', 'language', 'fr', 'Tétoum'); > >--- Croatian >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'tet', 'language', 'de', 'Tetum'); >+ >+-- Thai > INSERT INTO language_subtag_registry( subtag, type, description, added) >-VALUES ( 'hr', 'language', 'Croatian','2014-07-24' ); >+VALUES ( 'th', 'language', 'Thai','2005-10-16'); > > INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >-VALUES( 'hr','hrv'); >+VALUES ( 'th','tha'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'hr', 'language', 'hr', 'Hrvatski'); >+VALUES ( 'th', 'language', 'th', 'ภาษาà¹à¸à¸¢'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'hr', 'language', 'en', 'Croatian'); >+VALUES ( 'th', 'language', 'en', 'Thai'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'hr', 'language', 'fr', 'Croate'); >+VALUES ( 'th', 'language', 'fr', 'Thaï'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'hr', 'language', 'de', 'Kroatisch'); >- >+VALUES ( 'th', 'language', 'de', 'Thailändisch'); > >--- REGIONS >--- Canada >+-- Tagalog > INSERT INTO language_subtag_registry( subtag, type, description, added) >-VALUES ( 'CA', 'region', 'Canada','2005-10-16'); >+VALUES ( 'tl', 'language', 'Tagalog','2014-10-30'); >+ >+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >+VALUES ( 'tl','tgl'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'CA', 'region', 'en', 'Canada'); >+VALUES ( 'tl', 'language', 'tl', 'Tagalog'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'tl', 'language', 'en', 'Tagalog'); >+ >+-- Turkish >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'tr', 'language', 'Turkish','2005-10-16' ); >+ >+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >+VALUES ( 'tr','tur'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'tr', 'language', 'tr', 'Türkçe'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'tr', 'language', 'en', 'Turkish'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'tr', 'language', 'fr', 'Turc'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'tr', 'language', 'de', 'Türkisch'); >+ >+-- Ukranian >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'uk', 'language', 'Ukranian','2005-10-16'); >+ >+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >+VALUES ( 'uk','ukr'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'uk', 'language', 'uk', 'УкÑаÑнÑÑка'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'uk', 'language', 'en', 'Ukranian'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'uk', 'language', 'fr', 'Ukrainien'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'uk', 'language', 'de', 'Ukrainisch'); >+ >+-- Urdu >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'ur', 'language', 'Urdu','2005-10-16' ); >+ >+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >+VALUES ( 'ur','urd'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'ur', 'language', 'en', 'Urdu'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'ur', 'language', 'ur', 'اردÙ'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'ur', 'language', 'fr', 'Ourdou'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'ur', 'language', 'de', 'Urdu'); >+ >+-- Vietnamese >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'vi', 'language', 'Vietnamese','2014-10-30'); >+ >+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >+VALUES ( 'vi','vie'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'vi', 'language', 'vi', 'ãè¶'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'vi', 'language', 'en', 'Vietnamese'); >+ >+-- Chinese >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'zh', 'language', 'Chinese','2005-10-16'); >+ >+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) >+VALUES ( 'zh','chi'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'zh', 'language', 'zh', 'ä¸æ'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'zh', 'language', 'en', 'Chinese'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'zh', 'language', 'fr', 'Chinois'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'zh', 'language', 'de', 'Chinesisch'); >+ >+-- SCRIPTS >+-- Arabic >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'Arab', 'script', 'Arabic','2005-10-16'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'Arab','script', 'Arab', 'اÙعربÙØ©'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'Arab', 'script','en', 'Arabic'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'Arab', 'script','fr', 'Arabic'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'Arab', 'script', 'de', 'Arabisch'); >+ >+-- Armenian >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'Armn', 'script', 'Armenian','2014-10-30'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'Armn', 'script', 'Armn', 'ÕÕ¡ÕµÕ¸Ö Õ¡ÕµÕ¢Õ¸ÖÕ¢Õ¥Õ¶'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES( 'Armn', 'script', 'en', 'Armenian'); >+ >+-- Cyrillic >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'Cyrl', 'script', 'Cyrillic','2005-10-16'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'Cyrl', 'script', 'Cyrl', 'ÐиÑилиÑа'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'Cyrl', 'script', 'en', 'Cyrillic'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'Cyrl', 'script', 'fr', 'Cyrillic'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'Cyrl', 'script', 'de', 'Kyrillisch'); >+ >+-- Ethiopic >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'Ethi', 'script', 'Ethiopic','2014-10-30'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'Ethi', 'script', 'Ethi', 'ááá'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES( 'Ethi', 'script', 'en', 'Ethiopic'); >+ >+-- Greek >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'Grek', 'script', 'Greek','2005-10-16'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'Grek', 'script', 'Grek', 'ÎÎ»Î»Î·Î½Î¹ÎºÏ Î±Î»ÏάβηÏο'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'Grek', 'script', 'en', 'Greek'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'Grek', 'script', 'fr', 'Greek'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'Grek', 'script', 'de', 'Griechisch'); >+ >+ >+-- Han - Simplified >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'Hans', 'script', 'Han (Simplified variant)','2005-10-16'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'Hans', 'script', 'Hans', 'ç®ä½å'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'Hans', 'script', 'en', 'Han (Simplified variant)'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'Hans', 'script', 'fr', 'Han (Simplified variant)'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'Hans', 'script', 'de', 'Han (Vereinfachte Variante)'); >+ >+ >+-- Han - Traditional >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'Hant', 'script', 'Han (Traditional variant)','2005-10-16'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'Hant', 'script', 'Hant', 'ç¹é«å'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'Hant', 'script', 'en', 'Han (Traditional variant)'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'Hant', 'script', 'de', 'Han (Traditionelle Variante)'); >+ >+-- Hebrew >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'Hebr', 'script', 'Hebrew','2005-10-16'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'Hebr', 'script', 'Hebr', '×Ö¸×ֶף־×ÖµÖ¼×ת ×¢Ö´×ְרִ×'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'Hebr', 'script', 'en', 'Hebrew'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'Hebr', 'script', 'de', 'Hebräisch'); >+ >+-- Japanese >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'Jpan', 'script', 'Japanese','2014-10-30'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'Jpan', 'script', 'Jpan', 'æ¼¢å'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES( 'Jpan', 'script', 'en', 'Japanese'); >+ >+-- Kannada >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'Knda', 'script', 'Kannada','2014-10-30'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'Knda', 'script', 'Knda', 'à²à²¨à³à²¨à²¡ ಲಿಪಿ'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES( 'Knda', 'script', 'en', 'Kannada'); >+ >+-- Korean >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'Kore', 'script', 'Korean','2014-10-30'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'Kore', 'script', 'Kore', 'íê¸'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES( 'Kore', 'script', 'en', 'Korean'); >+ >+-- Lao >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'Laoo', 'script', 'Lao','2005-10-16'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'Laoo', 'script', 'Laoo', 'àºàº±àºàºªàºàºàº¥àº²àº§'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'Laoo', 'script', 'en', 'Lao'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'Laoo', 'script', 'de', 'Laotisch'); >+ >+ >+-- REGIONS - Order by country code >+-- Albania >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'AL', 'region', 'Albania','2014-10-30'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'AL', 'region', 'en', 'Albania'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'AL', 'region', 'sq', 'Shqipërisë'); >+ >+-- Azerbaijan >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'AZ', 'region', 'Azerbaijan','2014-10-30'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'AZ', 'region', 'en', 'Azerbaijan'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'AZ', 'region', 'az', 'AzÉrbaycan'); >+ >+-- Belgium >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'BE', 'region', 'Belgium','2014-10-30'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'BE', 'region', 'en', 'Belgium'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'BE', 'region', 'nl', 'België'); >+ >+-- Brazil >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'BR', 'region', 'Brazil','2014-10-30'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'BR', 'region', 'en', 'Brazil'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'BR', 'region', 'pt', 'Brasil'); >+ >+-- Belarus >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'BY', 'region', 'Belarus','2014-10-30'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'BY', 'region', 'en', 'Belarus'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'BY', 'region', 'be', 'ÐелаÑÑÑÑ'); >+ >+-- Canada >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'CA', 'region', 'Canada','2005-10-16'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'CA', 'region', 'en', 'Canada'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'CA', 'region', 'fr', 'Canada'); >+ >+-- Switzerland >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'CH', 'region', 'Switzerland','2014-10-30'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'CH', 'region', 'en', 'Switzerland'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'CH', 'region', 'de', 'Schweiz'); >+ >+-- China >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'CN', 'region', 'China','2014-10-30'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'CN', 'region', 'en', 'China'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'CN', 'region', 'zh', 'ä¸å½'); >+ >+-- Czech Republic >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'CZ', 'region', 'Czech Republic','2014-10-30'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'CZ', 'region', 'en', 'Czech Republic'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'CZ', 'region', 'cs', 'Äeská republika'); >+ >+-- Germany >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'DE', 'region', 'Germany','2014-10-30'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'DE', 'region', 'en', 'Germany'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'DE', 'region', 'de', 'Deutschland'); > > -- Denmark > INSERT INTO language_subtag_registry( subtag, type, description, added) > VALUES ( 'DK', 'region', 'Denmark','2005-10-16'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'DK', 'region', 'dk', 'Danmark'); >+VALUES ( 'DK', 'region', 'en', 'Denmark'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'DK', 'region', 'dk', 'Danmark'); >+ >+-- Spain >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'ES', 'region', 'Spain','2014-10-30'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'ES', 'region', 'en', 'Spain'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'ES', 'region', 'es', 'España'); >+ >+-- Finland >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'FI', 'region', 'Finland','2014-10-30'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'FI', 'region', 'en', 'Finland'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'FI', 'region', 'fi', 'Suomi'); >+ >+-- Faroe Islands >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'FO', 'region', 'Faroe Islands','2014-10-30'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'FO', 'region', 'en', 'Faroe Islands'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'FO', 'region', 'fo', 'Føroyar'); > > -- France > INSERT INTO language_subtag_registry( subtag, type, description, added) > VALUES ( 'FR', 'region', 'France','2005-10-16'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'FR', 'region', 'en', 'France'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) > VALUES ( 'FR', 'region', 'fr', 'France'); > >+-- United Kingdom >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'GB', 'region', 'United Kingdom','2005-10-16'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'GB', 'region', 'en', 'United Kingdom'); >+ >+-- Greece >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'GR', 'region', 'Greece','2014-10-30'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'GR', 'region', 'en', 'Greece'); >+ > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'FR', 'region', 'en', 'France'); >+VALUES ( 'GR', 'region', 'el', 'Îλλάδα'); >+ >+-- Croatia >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'HR', 'region', 'Croatia','2014-10-30'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'HR', 'region', 'en', 'Croatia'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'HR', 'region', 'hr', 'Hrvatska'); >+ >+-- Hungary >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'HU', 'region', 'Hungary','2014-10-30'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'HU', 'region', 'en', 'Hungary'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'HU', 'region', 'hu', 'Magyarország'); >+ >+-- Indonesia >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'ID', 'region', 'Indonesia','2014-10-30'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'ID', 'region', 'en', 'Indonesia'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'ID', 'region', 'id', 'Indonesia'); >+ >+-- Iceland >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'IS', 'region', 'Iceland','2014-10-30'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'IS', 'region', 'en', 'Iceland'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'IS', 'region', 'is', 'Ãsland'); >+ >+-- Italy >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'IT', 'region', 'Italy','2014-10-30'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'IT', 'region', 'en', 'Italy'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'IT', 'region', 'it', 'Italia'); >+ >+-- Japan >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'JP', 'region', 'Japan','2014-10-30'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'JP', 'region', 'en', 'Japan'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'JP', 'region', 'ja', 'æ¥æ¬'); >+ >+-- Kenya >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'KE', 'region', 'Kenya','2014-10-30'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'KE', 'region', 'en', 'Kenya'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'KE', 'region', 'rw', 'Kenya'); >+ >+-- Cambodia >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'KH', 'region', 'Cambodia','2014-10-30'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'KH', 'region', 'en', 'Cambodia'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'KH', 'region', 'km', 'ááááá»áá¶'); >+ >+-- North Korea >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'KP', 'region', 'North Korea','2014-10-30'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'KP', 'region', 'en', 'North Korea'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'KP', 'region', 'ko', 'ì¡°ì 민주주ìì¸ë¯¼ê³µíêµ'); >+ >+-- Sri Lanka >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'LK', 'region', 'Sri Lanka','2014-10-30'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'LK', 'region', 'en', 'Sri Lanka'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'LK', 'region', 'ta', 'à®à®²à®à¯à®à¯'); >+ >+-- Malaysia >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'MY', 'region', 'Malaysia','2014-10-30'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'MY', 'region', 'en', 'Malaysia'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'MY', 'region', 'ms', 'Malaysia'); >+ >+-- Niger >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'NE', 'region', 'Niger','2014-10-30'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'NE', 'region', 'en', 'Niger'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'NE', 'region', 'ne', 'Niger'); >+ >+-- Netherlands >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'NL', 'region', 'Netherlands','2014-10-30'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'NL', 'region', 'en', 'Netherlands'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'NL', 'region', 'nl', 'Nederland'); >+ >+-- Norway >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'NO', 'region', 'Norway','2014-10-30'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'NO', 'region', 'en', 'Norway'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'NO', 'region', 'ne', 'Noreg'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'NO', 'region', 'nn', 'Noreg'); > > -- New Zealand > INSERT INTO language_subtag_registry( subtag, type, description, added) > VALUES ( 'NZ', 'region', 'New Zealand','2005-10-16'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'NZ', 'region', 'en', 'New Zealand'); >+VALUES ( 'NZ', 'region', 'en', 'New Zealand'); > >--- United Kingdom >+-- Philippines > INSERT INTO language_subtag_registry( subtag, type, description, added) >-VALUES ( 'GB', 'region', 'United Kingdom','2005-10-16'); >+VALUES ( 'PH', 'region', 'Philippines','2014-10-30'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'PH', 'region', 'en', 'Philippines'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'PH', 'region', 'tl', 'Pilipinas'); >+ >+-- Pakistan >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'PK', 'region', 'Pakistan','2014-10-30'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'PK', 'region', 'en', 'Pakistan'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'PK', 'region', 'sd', 'پاÙستاÙ'); >+ >+-- Poland >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'PL', 'region', 'Poland','2014-10-30'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'PL', 'region', 'en', 'Poland'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'PL', 'region', 'pl', 'Polska'); >+ >+-- Portugal >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'PT', 'region', 'Portugal','2014-10-30'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'PT', 'region', 'en', 'Portugal'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'PT', 'region', 'pt', 'Portugal'); >+ >+-- Romania >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'RO', 'region', 'Romania','2014-10-30'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'RO', 'region', 'en', 'Romania'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'RO', 'region', 'ro', 'România'); >+ >+-- Russia >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'RU', 'region', 'Russia','2014-10-30'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'RU', 'region', 'en', 'Russia'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'RU', 'region', 'ru', 'РоÑÑиÑ'); >+ >+-- Rwanda >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'RW', 'region', 'Rwanda','2014-10-30'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'RW', 'region', 'en', 'Rwanda'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'RW', 'region', 'rw', 'Rwanda'); >+ >+-- Sweden >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'SE', 'region', 'Sweden','2014-10-30'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'SE', 'region', 'en', 'Sweden'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'SE', 'region', 'sv', 'Sverige'); >+ >+-- Slovenia >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'SI', 'region', 'Slovenia','2014-10-30'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'SI', 'region', 'en', 'Slovenia'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'SI', 'region', 'sl', 'Slovenija'); >+ >+-- Slovakia >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'SK', 'region', 'Slovakia','2014-10-30'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'SK', 'region', 'en', 'Slovakia'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'SK', 'region', 'sk', 'Slovensko'); >+ >+-- Thailand >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'TH', 'region', 'Thailand','2014-10-30'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'TH', 'region', 'en', 'Thailand'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'TH', 'region', 'th', 'à¸à¸£à¸°à¹à¸à¸¨à¹à¸à¸¢'); >+ >+-- Turkey >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'TR', 'region', 'Turkey','2014-10-30'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'TR', 'region', 'en', 'Turkey'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'TR', 'region', 'tr', 'Türkiye'); >+ >+-- Taiwan >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'TW', 'region', 'Taiwan','2014-10-30'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'TW', 'region', 'en', 'Taiwan'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'TW', 'region', 'zh', 'å°ç£'); >+ >+-- Ukraine >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'UA', 'region', 'Ukraine','2014-10-30'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'UA', 'region', 'en', 'Ukraine'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'GB', 'region', 'en', 'United Kingdom'); >+VALUES ( 'UA', 'region', 'uk', 'УкÑаÑна'); > > -- United States > INSERT INTO language_subtag_registry( subtag, type, description, added) > VALUES ( 'US', 'region', 'United States','2005-10-16'); > > INSERT INTO language_descriptions(subtag, type, lang, description) >-VALUES( 'US', 'region', 'en', 'United States'); >+VALUES ( 'US', 'region', 'en', 'United States'); >+ >+-- Vietnam >+INSERT INTO language_subtag_registry( subtag, type, description, added) >+VALUES ( 'VN', 'region', 'Vietnam','2014-10-30'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'VN', 'region', 'en', 'Vietnam'); >+ >+INSERT INTO language_descriptions(subtag, type, lang, description) >+VALUES ( 'VN', 'region', 'vi', 'Viá»t Nam'); >+ >diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl >index 7e54990..3e8f880 100755 >--- a/installer/data/mysql/updatedatabase.pl >+++ b/installer/data/mysql/updatedatabase.pl >@@ -8952,6 +8952,388 @@ if ( CheckVersion($DBversion) ) { > SetVersion($DBversion); > } > >+$DBversion = "3.17.00.XXX"; >+if ( CheckVersion($DBversion) ) { >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'am', 'language', 'Amharic','2014-10-29')"); >+ $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'am','amh')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'am', 'language', 'am', 'á ááá')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'am', 'language', 'en', 'Amharic')"); >+ >+ $dbh->do("UPDATE language_descriptions SET description = 'ÙعربÙØ©' WHERE subtag = 'ar' AND type = 'language' AND lang = 'ar'"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'az', 'language', 'Azerbaijani','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'az','aze')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'az', 'language', 'az', 'AzÉrbaycan dili')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'az', 'language', 'en', 'Azerbaijani')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'be', 'language', 'Byelorussian','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'be','bel')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'be', 'language', 'be', 'ÐелаÑÑÑÐºÐ°Ñ Ð¼Ð¾Ð²Ð°')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'be', 'language', 'en', 'Byelorussian')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'bn', 'language', 'Bengali','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'bn','ben')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'bn', 'language', 'bn', 'বাà¦à¦²à¦¾')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'bn', 'language', 'en', 'Bengali')"); >+ >+ $dbh->do("UPDATE language_descriptions SET description = 'ÐÑлгаÑÑки' WHERE subtag = 'bg' AND type = 'language' AND lang = 'bg'"); >+ $dbh->do("UPDATE language_descriptions SET description = 'CeÅ¡tina' WHERE subtag = 'cs' AND type = 'language' AND lang = 'cs'"); >+ $dbh->do("UPDATE language_descriptions SET description = 'Îλληνικά' WHERE subtag = 'el' AND type = 'language' AND lang = 'el'"); >+ $dbh->do("UPDATE language_descriptions SET description = 'Español' WHERE subtag = 'es' AND type = 'language' AND lang = 'es'"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'eu', 'language', 'Basque','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'eu','eus')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'eu', 'language', 'eu', 'Euskera')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'eu', 'language', 'en', 'Basque')"); >+ >+ $dbh->do("UPDATE language_descriptions SET description = 'ÙارسÙ' WHERE subtag = 'fa' AND type = 'language' AND lang = 'fa'"); >+ $dbh->do("UPDATE language_descriptions SET description = 'Suomi' WHERE subtag = 'fi' AND type = 'language' AND lang = 'fi'"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'fo', 'language', 'Faroese','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'fo','fao')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'fo', 'language', 'fo', 'Føroyskt')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'fo', 'language', 'en', 'Faroese')"); >+ >+ $dbh->do("UPDATE language_descriptions SET description = 'Français' WHERE subtag = 'fr' AND type = 'language' AND lang = 'fr'"); >+ $dbh->do("UPDATE language_descriptions SET description = '×¢Ö´×ְרִ×ת' WHERE subtag = 'he' AND type = 'language' AND lang = 'he'"); >+ $dbh->do("UPDATE language_descriptions SET description = 'हिनà¥à¤¦à¥' WHERE subtag = 'hi' AND type = 'language' AND lang = 'hi'"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'is', 'language', 'Icelandic','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'is','ice')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'is', 'language', 'is', 'Ãslenska')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'is', 'language', 'en', 'Icelandic')"); >+ >+ $dbh->do("UPDATE language_descriptions SET description = 'æ¥æ¬èª' WHERE subtag = 'ja' AND type = 'language' AND lang = 'ja'"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'ka', 'language', 'Kannada','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'ka','kan')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ka', 'language', 'ka', 'à²à²¨à³à²¨à²¡')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ka', 'language', 'en', 'Kannada')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'km', 'language', 'Khmer','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES( 'km','khm')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'km', 'language', 'km', 'áá¶áá¶ááááá')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES( 'km', 'language', 'en', 'Khmer')"); >+ >+ $dbh->do("UPDATE language_descriptions SET description = 'íêµì´' WHERE subtag = 'ko' AND type = 'language' AND lang = 'ko'"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'ku', 'language', 'Kurdish','2014-05-13')"); >+ $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'ku','kur')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ku', 'language', 'ku', 'Ú©ÙردÛ')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ku', 'language', 'en', 'Kurdish')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ku', 'language', 'fr', 'Kurde')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ku', 'language', 'de', 'Kurdisch')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ku', 'language', 'es', 'Kurdo')"); >+ >+ $dbh->do("UPDATE language_descriptions SET description = 'àºàº²àºªàº²àº¥àº²àº§' WHERE subtag = 'lo' AND type = 'language' AND lang = 'lo'"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'mi', 'language', 'Maori','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'mi','mri')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'mi', 'language', 'mi', 'Te Reo MÄori')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'mi', 'language', 'en', 'Maori')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'mn', 'language', 'Mongolian','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'mn','mon')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'mn', 'language', 'mn', 'Mонгол')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'mn', 'language', 'en', 'Mongolian')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'mr', 'language', 'Marathi','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'mr','mar')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'mr', 'language', 'mr', 'मराठà¥')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'mr', 'language', 'en', 'Marathi')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'ms', 'language', 'Malay','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'ms','may')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ms', 'language', 'ms', 'Bahasa melayu')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ms', 'language', 'en', 'Malay')"); >+ >+ $dbh->do("UPDATE language_descriptions SET description = 'Norsk bokmÃ¥l' WHERE subtag = 'nb' AND type = 'language' AND lang = 'nb'"); >+ $dbh->do("UPDATE language_descriptions SET description = 'Norwegian bokmÃ¥l' WHERE subtag = 'nb' AND type = 'language' AND lang = 'en'"); >+ $dbh->do("UPDATE language_descriptions SET description = 'Norvégien bokmÃ¥l' WHERE subtag = 'nb' AND type = 'language' AND lang = 'fr'"); >+ $dbh->do("UPDATE language_descriptions SET description = 'Norwegisch bokmÃ¥l' WHERE subtag = 'nb' AND type = 'language' AND lang = 'de'"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'ne', 'language', 'Nepali','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'ne','nep')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description)VALUES ( 'ne', 'language', 'ne', 'नà¥à¤ªà¤¾à¤²à¥')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ne', 'language', 'en', 'Nepali')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'pbr', 'language', 'Pangwa','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'pbr','pbr')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'pbr', 'language', 'pbr', 'Ekipangwa')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'pbr', 'language', 'en', 'Pangwa')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'prs', 'language', 'Dari','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'prs','prs')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'prs', 'language', 'prs', 'درÙ')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'prs', 'language', 'en', 'Dari')"); >+ >+ $dbh->do("UPDATE language_descriptions SET description = 'Português' WHERE subtag = 'pt' AND type = 'language' AND lang = 'pt'"); >+ $dbh->do("UPDATE language_descriptions SET description = 'Român' WHERE subtag = 'ro' AND type = 'language' AND lang = 'ro'"); >+ $dbh->do("UPDATE language_descriptions SET description = 'Ð ÑÑÑкий' WHERE subtag = 'ru' AND type = 'language' AND lang = 'ru'"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'rw', 'language', 'Kinyarwanda','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'rw','kin')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'rw', 'language', 'rw', 'Ikinyarwanda')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'rw', 'language', 'en', 'Kinyarwanda')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sd', 'language', 'Sindhi','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sd','snd')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sd', 'language', 'sd', 'سÙÚÙ')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sd', 'language', 'en', 'Sindhi')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sk', 'language', 'Slovak','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sk','slk')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sk', 'language', 'sk', 'SlovenÄina')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sk', 'language', 'en', 'Slovak')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sl', 'language', 'Slovene','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sl','slv')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sl', 'language', 'sl', 'SlovenÅ¡Äina')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sl', 'language', 'en', 'Slovene')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sq', 'language', 'Albanian','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sq','sqi')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sq', 'language', 'sq', 'Shqip')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sq', 'language', 'en', 'Albanian')"); >+ >+ $dbh->do("UPDATE language_descriptions SET description = 'CÑпÑки' WHERE subtag = 'sr' AND type = 'language' AND lang = 'sr'"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sw', 'language', 'Swahili','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'sw','swa')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sw', 'language', 'sw', 'Kiswahili')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sw', 'language', 'en', 'Swahili')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'ta', 'language', 'Tamil','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'ta','tam')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ta', 'language', 'ta', 'தமிழà¯')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ta', 'language', 'en', 'Tamil')"); >+ >+ $dbh->do("UPDATE language_descriptions SET description = 'Tetun' WHERE subtag = 'tet' AND type = 'language' AND lang = 'tet'"); >+ $dbh->do("UPDATE language_descriptions SET description = 'ภาษาà¹à¸à¸¢' WHERE subtag = 'th' AND type = 'language' AND lang = 'th'"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'tl', 'language', 'Tagalog','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'tl','tgl')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'tl', 'language', 'tl', 'Tagalog')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'tl', 'language', 'en', 'Tagalog')"); >+ >+ $dbh->do("UPDATE language_descriptions SET description = 'Türkçe' WHERE subtag = 'tr' AND type = 'language' AND lang = 'tr'"); >+ $dbh->do("UPDATE language_descriptions SET description = 'УкÑаÑнÑÑка' WHERE subtag = 'uk' AND type = 'language' AND lang = 'uk'"); >+ $dbh->do("UPDATE language_descriptions SET description = 'اردÙ' WHERE subtag = 'ur' AND type = 'language' AND lang = 'ur'"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'vi', 'language', 'Vietnamese','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'vi','vie')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'vi', 'language', 'vi', 'ãè¶')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'vi', 'language', 'en', 'Vietnamese')"); >+ >+ $dbh->do("UPDATE language_descriptions SET description = 'ä¸æ' WHERE subtag = 'zh' AND type = 'language' AND lang = 'zh'"); >+ $dbh->do("UPDATE language_descriptions SET description = '' WHERE subtag = 'Arab,script' AND type = 'Arab' AND lang = 'اÙعربÙØ©'"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'Armn', 'script', 'Armenian','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'Armn', 'script', 'Armn', 'ÕÕ¡ÕµÕ¸Ö Õ¡ÕµÕ¢Õ¸ÖÕ¢Õ¥Õ¶')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES( 'Armn', 'script', 'en', 'Armenian')"); >+ >+ $dbh->do("UPDATE language_descriptions SET description = 'ÐиÑилиÑа' WHERE subtag = 'Cyrl' AND type = 'script' AND lang = 'Cyrl'"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'Ethi', 'script', 'Ethiopic','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'Ethi', 'script', 'Ethi', 'ááá')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES( 'Ethi', 'script', 'en', 'Ethiopic')"); >+ >+ $dbh->do("UPDATE language_descriptions SET description = 'ÎÎ»Î»Î·Î½Î¹ÎºÏ Î±Î»ÏάβηÏο' WHERE subtag = 'Grek' AND type = 'script' AND lang = 'Grek'"); >+ $dbh->do("UPDATE language_descriptions SET description = 'ç®ä½å' WHERE subtag = 'Hans' AND type = 'script' AND lang = 'Hans'"); >+ $dbh->do("UPDATE language_descriptions SET description = 'ç¹é«å' WHERE subtag = 'Hant' AND type = 'script' AND lang = 'Hant'"); >+ $dbh->do("UPDATE language_descriptions SET description = '×Ö¸×ֶף־×ÖµÖ¼×ת ×¢Ö´×ְרִ×' WHERE subtag = 'Hebr' AND type = 'script' AND lang = 'Hebr'"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'Jpan', 'script', 'Japanese','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'Jpan', 'script', 'Jpan', 'æ¼¢å')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES( 'Jpan', 'script', 'en', 'Japanese')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'Knda', 'script', 'Kannada','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'Knda', 'script', 'Knda', 'à²à²¨à³à²¨à²¡ ಲಿಪಿ')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES( 'Knda', 'script', 'en', 'Kannada')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'Kore', 'script', 'Korean','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'Kore', 'script', 'Kore', 'íê¸')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES( 'Kore', 'script', 'en', 'Korean')"); >+ >+ $dbh->do("UPDATE language_descriptions SET description = 'àºàº±àºàºªàºàºàº¥àº²àº§' WHERE subtag = 'Laoo' AND type = 'script' AND lang = 'Laoo'"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'AL', 'region', 'Albania','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'AL', 'region', 'en', 'Albania')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'AL', 'region', 'sq', 'Shqipërisë')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'AZ', 'region', 'Azerbaijan','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'AZ', 'region', 'en', 'Azerbaijan')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'AZ', 'region', 'az', 'AzÉrbaycan')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'BE', 'region', 'Belgium','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'BE', 'region', 'en', 'Belgium')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'BE', 'region', 'nl', 'België')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'BR', 'region', 'Brazil','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'BR', 'region', 'en', 'Brazil')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'BR', 'region', 'pt', 'Brasil')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'BY', 'region', 'Belarus','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'BY', 'region', 'en', 'Belarus')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'BY', 'region', 'be', 'ÐелаÑÑÑÑ')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'CA', 'region', 'fr', 'Canada')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'CH', 'region', 'Switzerland','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'CH', 'region', 'en', 'Switzerland')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'CH', 'region', 'de', 'Schweiz')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'CN', 'region', 'China','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'CN', 'region', 'en', 'China')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'CN', 'region', 'zh', 'ä¸å½')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'CZ', 'region', 'Czech Republic','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'CZ', 'region', 'en', 'Czech Republic')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'CZ', 'region', 'cs', 'Äeská republika')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'DE', 'region', 'Germany','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'DE', 'region', 'en', 'Germany')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'DE', 'region', 'de', 'Deutschland')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'DK', 'region', 'en', 'Denmark')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'ES', 'region', 'Spain','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ES', 'region', 'en', 'Spain')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ES', 'region', 'es', 'España')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'FI', 'region', 'Finland','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'FI', 'region', 'en', 'Finland')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'FI', 'region', 'fi', 'Suomi')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'FO', 'region', 'Faroe Islands','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'FO', 'region', 'en', 'Faroe Islands')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'FO', 'region', 'fo', 'Føroyar')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'GR', 'region', 'Greece','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'GR', 'region', 'en', 'Greece')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'GR', 'region', 'el', 'Îλλάδα')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'HR', 'region', 'Croatia','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'HR', 'region', 'en', 'Croatia')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'HR', 'region', 'hr', 'Hrvatska')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'HU', 'region', 'Hungary','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'HU', 'region', 'en', 'Hungary')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'HU', 'region', 'hu', 'Magyarország')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'ID', 'region', 'Indonesia','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ID', 'region', 'en', 'Indonesia')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ID', 'region', 'id', 'Indonesia')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'IS', 'region', 'Iceland','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'IS', 'region', 'en', 'Iceland')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'IS', 'region', 'is', 'Ãsland')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'IT', 'region', 'Italy','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'IT', 'region', 'en', 'Italy')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'IT', 'region', 'it', 'Italia')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'JP', 'region', 'Japan','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'JP', 'region', 'en', 'Japan')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'JP', 'region', 'ja', 'æ¥æ¬')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'KE', 'region', 'Kenya','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'KE', 'region', 'en', 'Kenya')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'KE', 'region', 'rw', 'Kenya')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'KH', 'region', 'Cambodia','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'KH', 'region', 'en', 'Cambodia')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'KH', 'region', 'km', 'ááááá»áá¶')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'KP', 'region', 'North Korea','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'KP', 'region', 'en', 'North Korea')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'KP', 'region', 'ko', 'ì¡°ì 민주주ìì¸ë¯¼ê³µíêµ')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'LK', 'region', 'Sri Lanka','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'LK', 'region', 'en', 'Sri Lanka')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'LK', 'region', 'ta', 'à®à®²à®à¯à®à¯')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'MY', 'region', 'Malaysia','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'MY', 'region', 'en', 'Malaysia')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'MY', 'region', 'ms', 'Malaysia')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'NE', 'region', 'Niger','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'NE', 'region', 'en', 'Niger')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'NE', 'region', 'ne', 'Niger')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'NL', 'region', 'Netherlands','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'NL', 'region', 'en', 'Netherlands')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'NL', 'region', 'nl', 'Nederland')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'NO', 'region', 'Norway','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'NO', 'region', 'en', 'Norway')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'NO', 'region', 'ne', 'Noreg')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'NO', 'region', 'nn', 'Noreg')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'PH', 'region', 'Philippines','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'PH', 'region', 'en', 'Philippines')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'PH', 'region', 'tl', 'Pilipinas')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'PK', 'region', 'Pakistan','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'PK', 'region', 'en', 'Pakistan')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'PK', 'region', 'sd', 'پاÙستاÙ')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'PL', 'region', 'Poland','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'PL', 'region', 'en', 'Poland')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'PL', 'region', 'pl', 'Polska')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'PT', 'region', 'Portugal','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'PT', 'region', 'en', 'Portugal')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'PT', 'region', 'pt', 'Portugal')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'RO', 'region', 'Romania','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'RO', 'region', 'en', 'Romania')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'RO', 'region', 'ro', 'România')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'RU', 'region', 'Russia','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'RU', 'region', 'en', 'Russia')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'RU', 'region', 'ru', 'РоÑÑиÑ')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'RW', 'region', 'Rwanda','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'RW', 'region', 'en', 'Rwanda')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'RW', 'region', 'rw', 'Rwanda')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'SE', 'region', 'Sweden','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'SE', 'region', 'en', 'Sweden')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'SE', 'region', 'sv', 'Sverige')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'SI', 'region', 'Slovenia','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'SI', 'region', 'en', 'Slovenia')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'SI', 'region', 'sl', 'Slovenija')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'SK', 'region', 'Slovakia','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'SK', 'region', 'en', 'Slovakia')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'SK', 'region', 'sk', 'Slovensko')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'TH', 'region', 'Thailand','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'TH', 'region', 'en', 'Thailand')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'TH', 'region', 'th', 'à¸à¸£à¸°à¹à¸à¸¨à¹à¸à¸¢')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'TR', 'region', 'Turkey','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'TR', 'region', 'en', 'Turkey')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'TR', 'region', 'tr', 'Türkiye')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'TW', 'region', 'Taiwan','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'TW', 'region', 'en', 'Taiwan')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'TW', 'region', 'zh', 'å°ç£')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'UA', 'region', 'Ukraine','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'UA', 'region', 'en', 'Ukraine')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'UA', 'region', 'uk', 'УкÑаÑна')"); >+ >+ $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'VN', 'region', 'Vietnam','2014-10-30')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'VN', 'region', 'en', 'Vietnam')"); >+ $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'VN', 'region', 'vi', 'Viá»t Nam')"); >+ >+ print "Upgrade to $DBversion done (Bug 12250: Update descriptions for languages, scripts and regions)\n"; >+ SetVersion($DBversion); >+} >+ > =head1 FUNCTIONS > > =head2 TableExists($table) >-- >1.7.9.5
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 12250
:
28217
|
33127
|
33329
|
33348