From 3eb293e9dac6267065f7cd8279ffded3a95e1b88 Mon Sep 17 00:00:00 2001 From: Bernardo Gonzalez Kriegel 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 Signed-off-by: Tomas Cohen Arazi Signed-off-by: Katrin Fischer Tested the SQL, no problems found. Signed-off-by: Tomas Cohen Arazi --- .../data/mysql/mandatory/subtag_registry.sql | 1505 +++++++++++++---- installer/data/mysql/updatedatabase.pl | 382 +++++ 2 files changed, 1543 insertions(+), 344 deletions(-) diff --git a/installer/data/mysql/mandatory/subtag_registry.sql b/installer/data/mysql/mandatory/subtag_registry.sql index 1e642c04db..6001fffb07 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,1752 @@ 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 ( '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( 'FR', 'region', 'en', 'France'); +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( 'GB', 'region', 'en', 'United Kingdom'); +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 ( '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 4c19eae87f..51adc83cf9 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -9026,6 +9026,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) -- 2.39.5