From 6f5d61d14add144bc2765f74a4750f62859cb6d8 Mon Sep 17 00:00:00 2001 From: Bernardo Gonzalez Kriegel Date: Wed, 2 Apr 2014 17:49:48 -0300 Subject: [PATCH] Bug 11593 - subtag_registry.sql files contain the same information for each language This patch removes subtag_registry.sql from lang dirs, and put it on a new mandatory dir In that way we need to update only one file. All similar files are removed. To test: 1) Try a new install, or simply create a new database, grant permissions on it, change koha-conf.xml to use this database and go to staff page 2) Go step by step until all mandatory or optional sql files are loaded. Check that subtag_registry.sql is loaded. 3) Do it again but on other language. First install translation and repeat 2), could use de-DE or fr-FR Signed-off-by: Chris Cormack --- C4/Installer.pm | 3 + .../data/mysql/de-DE/mandatory/subtag_registry.sql | 954 --------------------- .../data/mysql/de-DE/mandatory/subtag_registry.txt | 4 - .../data/mysql/es-ES/mandatory/subtag_registry.sql | 798 ----------------- .../data/mysql/es-ES/mandatory/subtag_registry.txt | 5 - .../mysql/fr-FR/1-Obligatoire/subtag_registry.sql | 685 --------------- .../mysql/fr-FR/1-Obligatoire/subtag_registry.txt | 4 - .../data/mysql/it-IT/necessari/subtag_registry.sql | 790 ----------------- .../data/mysql/it-IT/necessari/subtag_registry.txt | 5 - .../mysql/{en => }/mandatory/subtag_registry.sql | 0 .../mysql/{en => }/mandatory/subtag_registry.txt | 0 .../mysql/nb-NO/1-Obligatorisk/subtag_registry.sql | 819 ------------------ .../mysql/nb-NO/1-Obligatorisk/subtag_registry.txt | 1 - .../data/mysql/pl-PL/mandatory/subtag_registry.sql | 786 ----------------- .../data/mysql/pl-PL/mandatory/subtag_registry.txt | 5 - .../data/mysql/ru-RU/mandatory/subtag_registry.sql | 786 ----------------- .../data/mysql/ru-RU/mandatory/subtag_registry.txt | 4 - .../data/mysql/uk-UA/mandatory/subtag_registry.sql | 786 ----------------- .../data/mysql/uk-UA/mandatory/subtag_registry.txt | 4 - 19 files changed, 3 insertions(+), 6436 deletions(-) delete mode 100755 installer/data/mysql/de-DE/mandatory/subtag_registry.sql delete mode 100644 installer/data/mysql/de-DE/mandatory/subtag_registry.txt delete mode 100644 installer/data/mysql/es-ES/mandatory/subtag_registry.sql delete mode 100644 installer/data/mysql/es-ES/mandatory/subtag_registry.txt delete mode 100644 installer/data/mysql/fr-FR/1-Obligatoire/subtag_registry.sql delete mode 100644 installer/data/mysql/fr-FR/1-Obligatoire/subtag_registry.txt delete mode 100644 installer/data/mysql/it-IT/necessari/subtag_registry.sql delete mode 100644 installer/data/mysql/it-IT/necessari/subtag_registry.txt rename installer/data/mysql/{en => }/mandatory/subtag_registry.sql (100%) rename installer/data/mysql/{en => }/mandatory/subtag_registry.txt (100%) delete mode 100644 installer/data/mysql/nb-NO/1-Obligatorisk/subtag_registry.sql delete mode 100644 installer/data/mysql/nb-NO/1-Obligatorisk/subtag_registry.txt delete mode 100644 installer/data/mysql/pl-PL/mandatory/subtag_registry.sql delete mode 100644 installer/data/mysql/pl-PL/mandatory/subtag_registry.txt delete mode 100644 installer/data/mysql/ru-RU/mandatory/subtag_registry.sql delete mode 100644 installer/data/mysql/ru-RU/mandatory/subtag_registry.txt delete mode 100644 installer/data/mysql/uk-UA/mandatory/subtag_registry.sql delete mode 100644 installer/data/mysql/uk-UA/mandatory/subtag_registry.txt diff --git a/C4/Installer.pm b/C4/Installer.pm index 2add0e8..300697a 100644 --- a/C4/Installer.pm +++ b/C4/Installer.pm @@ -298,6 +298,9 @@ sub load_sql_in_order { $request->execute; my ($systempreference) = $request->fetchrow; $systempreference = '' unless defined $systempreference; # avoid warning + # Make sure subtag_registry.sql is loaded second + my $subtag_registry = C4::Context->config('intranetdir') . "/installer/data/$self->{dbms}/mandatory/subtag_registry.sql"; + unshift(@fnames, $subtag_registry); # Make sure the global sysprefs.sql file is loaded first my $globalsysprefs = C4::Context->config('intranetdir') . "/installer/data/$self->{dbms}/sysprefs.sql"; unshift(@fnames, $globalsysprefs); diff --git a/installer/data/mysql/de-DE/mandatory/subtag_registry.sql b/installer/data/mysql/de-DE/mandatory/subtag_registry.sql deleted file mode 100755 index 1e642c0..0000000 --- a/installer/data/mysql/de-DE/mandatory/subtag_registry.sql +++ /dev/null @@ -1,954 +0,0 @@ --- http://www.w3.org/International/articles/language-tags/ - --- BIDI Stuff, Arabic and Hebrew -INSERT INTO language_script_bidi(rfc4646_subtag,bidi) -VALUES( 'Arab', 'rtl'); -INSERT INTO language_script_bidi(rfc4646_subtag,bidi) -VALUES( 'Hebr', 'rtl'); - --- Default mappings between script and language subcodes -INSERT INTO language_script_mapping(language_subtag,script_subtag) -VALUES( 'ar', 'Arab'); -INSERT INTO language_script_mapping(language_subtag,script_subtag) -VALUES( 'he', 'Hebr'); - --- EXTENSIONS --- Interface (i) --- SELECT * FROM language_subtag_registry WHERE type='i'; --- OPAC -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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'opac', 'i', 'fr', 'OPAC'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'intranet', 'i', 'fr', '????'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'prog', 't', 'fr', 'Prog'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'prog', 't', 'de', 'Prog'); - --- LANGUAGES - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'ar', 'language', 'ar', 'العربية'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ar', 'language', 'en', 'Arabic'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ar', 'language', 'fr', 'Arabe'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ar', 'language', 'de', 'Arabisch'); - --- Armenian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'hy', 'language', 'Armenian','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'hy','arm'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'hy', 'language', 'hy', 'Հայերեն'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hy', 'language', 'en', 'Armenian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hy', 'language', 'fr', 'Armenian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hy', 'language', 'de', 'Armenisch'); - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'bg', 'language', 'bg', 'Български'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'bg', 'language', 'en', 'Bulgarian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'bg', 'language', 'fr', 'Bulgare'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'bg', 'language', 'de', 'Bulgarisch'); - --- 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'); - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'cs', 'language', 'cs', 'čeština'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'cs', 'language', 'en', 'Czech'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'cs', 'language', 'fr', 'Tchèque'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -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'); - -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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'da', 'language', 'fr', 'Danois'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'da', 'language', 'de', 'Dänisch'); - --- Dutch, Flemish -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'nl', 'language', 'Dutch','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'nl','dut'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'nl', 'language', 'nl', 'Nederlands'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nl', 'language', 'en', 'Dutch'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nl', 'language', 'fr', 'Néerlandais'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nl', 'language', 'de', 'Niederländisch'); - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'en', 'language', 'en', 'English'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'en', 'language', 'fr', 'Anglais'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'en', 'language', 'de', 'Englisch'); - --- Finnish -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'fi', 'language', 'Finnish','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'fi','fin'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fi', 'language', 'fi', 'suomi'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fi', 'language', 'en', 'Finnish'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fi', 'language', 'de', 'Finnisch'); - --- French -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'fr', 'language', 'French','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'fr','fre'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fr', 'language', 'en', 'French'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fr', 'language', 'fr', 'Français'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fr', 'language', 'de', 'Französisch'); - --- INSERT INTO language_descriptions(subtag, type, lang, description) --- VALUES( 'fr-CA', 'language', 'fr-CA', 'français'); - --- Lao -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'lo', 'language', 'Lao','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'lo','lao'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'lo', 'language', 'lo', 'ພາສາລາວ'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'lo', 'language', 'en', 'Lao'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'lo', 'language', 'fr', 'Laotien'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'lo', 'language', 'de', 'Laotisch'); - --- German -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'de', 'language', 'German','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'de','ger'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'de', 'language', 'de', 'Deutsch'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'de', 'language', 'en', 'German'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -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', 'ελληνικά'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -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- ]'); - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'he', 'language', 'he', 'עברית'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'he', 'language', 'en', 'Hebrew'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'he', 'language', 'fr', 'Hébreu'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hi', 'language', 'hi', 'हिन्दी'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hi', 'language', 'en', 'Hindi'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hi', 'language', 'fr', 'Hindi'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hi', 'language', 'de', 'Hindi'); - --- Hungarian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'hu', 'language', 'Hungarian','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'hu','hun'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hu', 'language', 'hu', 'Magyar'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hu', 'language', 'en', 'Hungarian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hu', 'language', 'fr', 'Hongrois'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hu', 'language', 'de', 'Ungarisch'); - --- Indonesian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'id', 'language', 'Indonesian','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'id','ind'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'id', 'language', 'id', 'Bahasa Indonesia'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'id', 'language', 'en', 'Indonesian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'id', 'language', 'fr', 'Indonésien'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'id', 'language', 'de', 'Indonesisch'); - --- 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( 'it','ita'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'it', 'language', 'it', 'Italiano'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'it', 'language', 'en', 'Italian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'it', 'language', 'fr', 'Italien'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'it', 'language', 'de', 'Italienisch'); - --- Japanese -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ja', 'language', 'Japanese','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ja','jpn'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ja', 'language', 'ja', '日本語'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ja', 'language', 'en', 'Japanese'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ja', 'language', 'fr', 'Japonais'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ja', 'language', 'de', 'Japanisch'); - --- Korean -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ko', 'language', 'Korean','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ko','kor'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ko', 'language', 'ko', '한국어'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ko', 'language', 'en', 'Korean'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ko', 'language', 'fr', 'Coréen'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ko', 'language', 'de', 'Koreanisch'); - --- Latin -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'la', 'language', 'Latin','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'la','lat'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'la', 'language', 'la', 'Latina'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'la', 'language', 'en', 'Latin'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'la', 'language', 'fr', 'Latin'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'la', 'language', 'de', 'Latein'); - --- Galician - -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'gl', 'language', 'Galician','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'gl','glg'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'gl', 'language', 'gl', 'Galego'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'gl', 'language', 'en', 'Galician'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'gl', 'language', 'fr', 'Galicien'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'gl', 'language', 'de', 'Galicisch'); - - --- Norwegian (bokmål) -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'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'nb','nob'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nb', 'language', 'nb', 'Norsk bokmål'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nb', 'language', 'en', 'Norwegian bokmål'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nb', 'language', 'fr', 'Norvégien bokmål'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nb', 'language', 'de', 'Norwegisch bokmål'); - --- Norwegian (nynorsk) -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'nn', 'language', 'Norwegian nynorsk','2011-02-14' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'nn','nno'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'nb', 'Norsk nynorsk'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'nn', 'Norsk nynorsk'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'en', 'Norwegian nynorsk'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'fr', 'Norvégien nynorsk'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'de', 'Norwegisch nynorsk'); - --- 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( 'fa','per'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fa', 'language', 'fa', 'فارسى'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fa', 'language', 'en', 'Persian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fa', 'language', 'fr', 'Persan'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fa', 'language', 'de', 'Persisch'); - --- Polish -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'pl', 'language', 'Polish','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'pl','pol'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pl', 'language', 'pl', 'Polski'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pl', 'language', 'en', 'Polish'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pl', 'language', 'fr', 'Polonais'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pl', 'language', 'de', 'Polnisch'); - --- Portuguese -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'pt', 'language', 'Portuguese','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'pt','por'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pt', 'language', 'pt', 'Português'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pt', 'language', 'en', 'Portuguese'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pt', 'language', 'fr', 'Portugais'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pt', 'language', 'de', 'Portugiesisch'); - --- Romanian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ro', 'language', 'Romanian','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ro','rum'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ro', 'language', 'ro', 'Română'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ro', 'language', 'en', 'Romanian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ro', 'language', 'fr', 'Roumain'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ro', 'language', 'de', 'Rumänisch'); - --- Russian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ru', 'language', 'Russian','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ru','rus'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ru', 'language', 'ru', 'Русский'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ru', 'language', 'en', 'Russian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ru', 'language', 'fr', 'Russe'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ru', 'language', 'de', 'Russisch'); - --- 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( 'sr', 'language', 'sr', 'српски'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'sr', 'language', 'en', 'Serbian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'sr', 'language', 'fr', 'Serbe'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'sr', 'language', 'de', 'Serbisch'); - --- Spanish, Castilian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'es', 'language', 'Spanish','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'es','spa'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'es', 'language', 'es', 'Español'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'es', 'language', 'en', 'Spanish'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'es', 'language', 'fr', 'Espagnol'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'es', 'language', 'de', 'Spanisch'); - --- Spanish, Catalan -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ca', 'language', 'Catalan','2013-01-12' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -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( 'ca', 'language', 'en', 'Catalan'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ca', 'language', 'fr', 'Catalan'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ca', 'language', 'ca', 'Català'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ca', 'language', 'de', 'Katalanisch'); - --- Swedish -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'sv', 'language', 'Swedish','2005-10-16' ); - -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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'sv', 'language', 'fr', 'Suédois'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'sv', 'language', 'de', 'Schwedisch'); - --- Tetum -INSERT INTO language_subtag_registry( subtag, type, description, added) -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( 'tet', 'language', 'tet', 'tetun'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'tet', 'language', 'en', 'Tetum'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'tet', 'language', 'fr', 'Tétoum'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'tet', 'language', 'de', 'Tetum'); - --- Thai -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'th', 'language', 'Thai','2005-10-16'); - -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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'th', 'language', 'fr', 'Thaï'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'th', 'language', 'de', 'Thailändisch'); - --- 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'); - --- 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'); - --- 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'); - - --- 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', 'Han (Simplified variant)'); - -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', 'Han (Traditional variant)'); - -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', 'Hebrew'); - -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'); - --- 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', 'lo', 'Lao'); - -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'); - --- Croatian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'hr', 'language', 'Croatian','2014-07-24' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'hr','hrv'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hr', 'language', 'hr', 'Hrvatski'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hr', 'language', 'en', 'Croatian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hr', 'language', 'fr', 'Croate'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hr', 'language', 'de', 'Kroatisch'); - - --- REGIONS --- 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'); - --- 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'); - --- 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', 'fr', 'France'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'FR', 'region', 'en', 'France'); - --- 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'); - --- 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'); - --- 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'); diff --git a/installer/data/mysql/de-DE/mandatory/subtag_registry.txt b/installer/data/mysql/de-DE/mandatory/subtag_registry.txt deleted file mode 100644 index e28a15c..0000000 --- a/installer/data/mysql/de-DE/mandatory/subtag_registry.txt +++ /dev/null @@ -1,4 +0,0 @@ -I18N-Unterstützung in Koha -Erweiterung für bidirektionale Schriften, Arabisch und Hebräisch, -Standardmappings zwischen Schrift- und Sprachcodes, -weitere Spracherweiterungen diff --git a/installer/data/mysql/es-ES/mandatory/subtag_registry.sql b/installer/data/mysql/es-ES/mandatory/subtag_registry.sql deleted file mode 100644 index 62b97ab..0000000 --- a/installer/data/mysql/es-ES/mandatory/subtag_registry.sql +++ /dev/null @@ -1,798 +0,0 @@ --- http://www.w3.org/International/articles/language-tags/ - --- BIDI Stuff, Arabic and Hebrew -INSERT INTO language_script_bidi(rfc4646_subtag,bidi) -VALUES( 'Arab', 'rtl'); -INSERT INTO language_script_bidi(rfc4646_subtag,bidi) -VALUES( 'Hebr', 'rtl'); - --- Default mappings between script and language subcodes -INSERT INTO language_script_mapping(language_subtag,script_subtag) -VALUES( 'ar', 'Arab'); -INSERT INTO language_script_mapping(language_subtag,script_subtag) -VALUES( 'he', 'Hebr'); - --- EXTENSIONS --- Interface (i) --- SELECT * FROM language_subtag_registry WHERE type='i'; --- OPAC -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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'opac', 'i', 'fr', '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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'intranet', 'i', 'fr', '????'); - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'prog', 't', 'fr', 'Prog'); - --- LANGUAGES - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'ar', 'language', 'ar', 'العربية'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ar', 'language', 'en', 'Arabic'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ar', 'language', 'fr', 'Arabe'); - --- Armenian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'hy', 'language', 'Armenian','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'hy','arm'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'hy', 'language', 'hy', 'Հայերէն'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hy', 'language', 'en', 'Armenian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hy', 'language', 'fr', 'Armenian'); - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'bg', 'language', 'bg', 'Български'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'bg', 'language', 'en', 'Bulgarian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'bg', 'language', 'fr', 'Bulgare'); - --- 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'); - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'cs', 'language', 'cs', 'čeština'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'cs', 'language', 'en', 'Czech'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'cs', 'language', 'fr', 'Tchèque'); - --- 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'); - -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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'da', 'language', 'fr', 'Danois'); - --- Dutch, Flemish -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'nl', 'language', 'Dutch','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'nl','dut'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'nl', 'language', 'nl', 'Nederlands'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nl', 'language', 'en', 'Dutch'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nl', 'language', 'fr', 'Néerlandais'); - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'en', 'language', 'en', 'English'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'en', 'language', 'fr', 'Anglais'); - --- Finnish -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'fi', 'language', 'Finnish','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'fi','fin'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fi', 'language', 'fi', 'suomi'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fi', 'language', 'en', 'Finnish'); - --- French -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'fr', 'language', 'French','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'fr','fre'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fr', 'language', 'en', 'French'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fr', 'language', 'fr', 'Français'); - --- INSERT INTO language_descriptions(subtag, type, lang, description) --- VALUES( 'fr-CA', 'language', 'fr-CA', 'français'); - --- Lao -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'lo', 'language', 'Lao','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'lo','lao'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'lo', 'language', 'lo', 'ພາສາລາວ'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'lo', 'language', 'en', 'Lao'); - --- German -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'de', 'language', 'German','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'de','ger'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'de', 'language', 'de', 'Deutsch'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'de', 'language', 'en', 'German'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -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', 'ελληνικά'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'el', 'language', 'en', 'Greek, Modern [1453- ]'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'el', 'language', 'fr', 'Grec Moderne (Après 1453)'); - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'he', 'language', 'he', 'עברית'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'he', 'language', 'en', 'Hebrew'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'he', 'language', 'fr', 'Hébreu'); - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hi', 'language', 'hi', 'हिन्दी'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hi', 'language', 'en', 'Hindi'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hi', 'language', 'fr', 'Hindi'); - --- Hungarian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'hu', 'language', 'Hungarian','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'hu','hun'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hu', 'language', 'hu', 'Magyar'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hu', 'language', 'en', 'Hungarian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hu', 'language', 'fr', 'Hongrois'); - --- Indonesian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'id', 'language', 'Indonesian','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'id','ind'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'id', 'language', 'id', 'Bahasa Indonesia'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'id', 'language', 'en', 'Indonesian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'id', 'language', 'fr', 'Indonésien'); - --- 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( 'it','ita'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'it', 'language', 'it', 'Italiano'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'it', 'language', 'en', 'Italian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'it', 'language', 'fr', 'Italien'); - --- Japanese -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ja', 'language', 'Japanese','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ja','jpn'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ja', 'language', 'ja', '日本語'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ja', 'language', 'en', 'Japanese'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ja', 'language', 'fr', 'Japonais'); - --- Korean -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ko', 'language', 'Korean','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ko','kor'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ko', 'language', 'ko', '한국어'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ko', 'language', 'en', 'Korean'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ko', 'language', 'fr', 'Coréen'); - --- Latin -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'la', 'language', 'Latin','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'la','lat'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'la', 'language', 'la', 'Latina'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'la', 'language', 'en', 'Latin'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'la', 'language', 'fr', 'Latin'); - --- Galician - -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'gl', 'language', 'Galician','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'gl','glg'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'gl', 'language', 'gl', 'Galego'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'gl', 'language', 'en', 'Galician'); - --- Norwegian (bokmål) -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'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'nb','nob'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nb', 'language', 'nb', 'Norsk bokmål'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nb', 'language', 'en', 'Norwegian bokmål'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nb', 'language', 'fr', 'Norvégien bokmål'); - --- Norwegian (nynorsk) -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'nn', 'language', 'Norwegian nynorsk','2011-02-14' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'nn','nno'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'nb', 'Norsk nynorsk'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'nn', 'Norsk nynorsk'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'en', 'Norwegian nynorsk'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'fr', 'Norvégien nynorsk'); - --- 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( 'fa','per'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fa', 'language', 'fa', 'فارسى'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fa', 'language', 'en', 'Persian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fa', 'language', 'fr', 'Persan'); - --- Polish -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'pl', 'language', 'Polish','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'pl','pol'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pl', 'language', 'pl', 'Polski'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pl', 'language', 'en', 'Polish'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pl', 'language', 'fr', 'Polonais'); - --- Portuguese -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'pt', 'language', 'Portuguese','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'pt','por'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pt', 'language', 'pt', 'Português'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pt', 'language', 'en', 'Portuguese'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pt', 'language', 'fr', 'Portugais'); - --- Romanian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ro', 'language', 'Romanian','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ro','rum'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ro', 'language', 'ro', 'Română'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ro', 'language', 'en', 'Romanian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ro', 'language', 'fr', 'Roumain'); - --- Russian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ru', 'language', 'Russian','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ru','rus'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ru', 'language', 'ru', 'Русский'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ru', 'language', 'en', 'Russian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ru', 'language', 'fr', 'Russe'); - --- 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( 'sr', 'language', 'sr', 'српски'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'sr', 'language', 'en', 'Serbian'); - --- Spanish, Castilian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'es', 'language', 'Spanish','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'es','spa'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'es', 'language', 'es', 'Español'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'es', 'language', 'en', 'Spanish'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'es', 'language', 'fr', 'Espagnol'); - --- Spanish, Catalan -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ca', 'language', 'Catalan','2013-01-12' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -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( 'ca', 'language', 'en', 'Catalan'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ca', 'language', 'fr', 'Catalan'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ca', 'language', 'ca', 'Català'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ca', 'language', 'de', 'Katalanisch'); - --- Swedish -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'sv', 'language', 'Swedish','2005-10-16' ); - -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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'sv', 'language', 'fr', 'Suédois'); - --- Tetum -INSERT INTO language_subtag_registry( subtag, type, description, added) -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( 'tet', 'language', 'tet', 'tetun'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'tet', 'language', 'en', 'Tetum'); - --- Thai -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'th', 'language', 'Thai','2005-10-16'); - -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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'th', 'language', 'fr', 'Thaï'); - --- 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'); - - --- 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'); - --- 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', 'اردو'); - --- 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'); - --- 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'); - --- 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'); - --- 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', 'Han (Simplified variant)'); - -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)'); - --- 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', 'Han (Traditional variant)'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Hant', 'script', 'en', 'Han (Traditional variant)'); - --- 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', 'Hebrew'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Hebr', 'script', 'en', 'Hebrew'); - --- 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', 'lo', 'Lao'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Laoo', 'script', 'en', 'Lao'); - --- Croatian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'hr', 'language', 'Croatian','2014-07-24' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'hr','hrv'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hr', 'language', 'hr', 'Hrvatski'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hr', 'language', 'en', 'Croatian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hr', 'language', 'fr', 'Croate'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hr', 'language', 'de', 'Kroatisch'); - - --- REGIONS --- 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'); - --- 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'); - --- 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', 'fr', 'France'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'FR', 'region', 'en', 'France'); - --- 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'); - --- 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'); - --- 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'); diff --git a/installer/data/mysql/es-ES/mandatory/subtag_registry.txt b/installer/data/mysql/es-ES/mandatory/subtag_registry.txt deleted file mode 100644 index cd4893d..0000000 --- a/installer/data/mysql/es-ES/mandatory/subtag_registry.txt +++ /dev/null @@ -1,5 +0,0 @@ -Soporte I18N - -BIDI Stuff, Arabic and Hebrew -Mapeos predeterminados entre subcódigos de script e idiomas -Extensión de idiomas diff --git a/installer/data/mysql/fr-FR/1-Obligatoire/subtag_registry.sql b/installer/data/mysql/fr-FR/1-Obligatoire/subtag_registry.sql deleted file mode 100644 index 829a381..0000000 --- a/installer/data/mysql/fr-FR/1-Obligatoire/subtag_registry.sql +++ /dev/null @@ -1,685 +0,0 @@ --- http://www.w3.org/International/articles/language-tags/ - --- BIDI Stuff, Arabic and Hebrew -INSERT INTO language_script_bidi(rfc4646_subtag,bidi) -VALUES( 'Arab', 'rtl'); -INSERT INTO language_script_bidi(rfc4646_subtag,bidi) -VALUES( 'Hebr', 'rtl'); - --- Default mappings between script and language subcodes -INSERT INTO language_script_mapping(language_subtag,script_subtag) -VALUES( 'ar', 'Arab'); -INSERT INTO language_script_mapping(language_subtag,script_subtag) -VALUES( 'he', 'Hebr'); - --- EXTENSIONS --- Interface (i) --- SELECT * FROM language_subtag_registry WHERE type='i'; --- OPAC -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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'opac', 'i', 'fr', '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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'intranet', 'i', 'fr', 'Français'); - --- Theme (t) -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'prog', 't', 'United Kingdom','2005-10-16'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'prog', 'i', 'en', 'Prog'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'prog', 'i', 'fr', 'Prog'); - --- LANGUAGES - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'ar', 'language', 'ar', 'العربية'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ar', 'language', 'en', 'Arabic'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ar', 'language', 'fr', 'Arabe'); - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'bg', 'language', 'bg', 'Български'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'bg', 'language', 'en', 'Bulgarian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'bg', 'language', 'fr', 'Bulgare'); - --- 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'); - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'cs', 'language', 'cs', 'čeština'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'cs', 'language', 'en', 'Czech'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'cs', 'language', 'fr', 'Tchèque'); - --- 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'); - -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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'da', 'language', 'fr', 'Danois'); - --- Dutch, Flemish -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'nl', 'language', 'Dutch','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'nl','dut'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'nl', 'language', 'nl', 'Nederlands'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nl', 'language', 'en', 'Dutch'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nl', 'language', 'fr', 'Néerlandais'); - --- 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','en'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'en', 'language', 'en', 'English'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'en', 'language', 'fr', 'Anglais'); - --- French -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'fr', 'language', 'French','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'fr','fr'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fr', 'language', 'en', 'French'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fr', 'language', 'fr', 'Français'); - --- INSERT INTO language_descriptions(subtag, type, lang, description) --- VALUES( 'fr-CA', 'language', 'fr-CA', 'français'); - --- German -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'de', 'language', 'German','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'de','ger'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'de', 'language', 'de', 'Deutsch'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'de', 'language', 'en', 'German'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -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', 'ελληνικά'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'el', 'language', 'en', 'Greek, Modern [1453- ]'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'el', 'language', 'fr', 'Grec Moderne (Après 1453)'); - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'he', 'language', 'he', 'עברית'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'he', 'language', 'en', 'Hebrew'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'he', 'language', 'fr', 'Hébreu'); - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hi', 'language', 'hi', 'हिन्दी'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hi', 'language', 'en', 'Hindi'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hi', 'language', 'fr', 'Hindi'); - --- Hungarian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'hu', 'language', 'Hungarian','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'hu','hun'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hu', 'language', 'hu', 'Magyar'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hu', 'language', 'en', 'Hungarian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hu', 'language', 'fr', 'Hongrois'); - --- Indonesian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'id', 'language', 'Indonesian','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'id','ind'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'id', 'language', 'id', 'Bahasa Indonesia'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'id', 'language', 'en', 'Indonesian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'id', 'language', 'fr', 'Indonésien'); - --- 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( 'it','ita'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'it', 'language', 'it', 'Italiano'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'it', 'language', 'en', 'Italian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'it', 'language', 'fr', 'Italien'); - --- Japanese -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ja', 'language', 'Japanese','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ja','jpn'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ja', 'language', 'ja', '日本語'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ja', 'language', 'en', 'Japanese'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ja', 'language', 'fr', 'Japonais'); - --- Korean -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ko', 'language', 'Korean','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ko','kor'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ko', 'language', 'ko', '한국어'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ko', 'language', 'en', 'Korean'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ko', 'language', 'fr', 'Coréen'); - --- Latin -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'la', 'language', 'Latin','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'la','lat'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'la', 'language', 'la', 'Latina'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'la', 'language', 'en', 'Latin'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'la', 'language', 'fr', 'Latin'); - --- Norwegian (bokmål) -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'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'nb','nob'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nb', 'language', 'nb', 'Norsk bokmål'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nb', 'language', 'en', 'Norwegian bokmål'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nb', 'language', 'fr', 'Norvégien bokmål'); - --- Norwegian (nynorsk) -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'nn', 'language', 'Norwegian nynorsk','2011-02-14' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'nn','nno'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'nb', 'Norsk nynorsk'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'nn', 'Norsk nynorsk'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'en', 'Norwegian nynorsk'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'fr', 'Norvégien nynorsk'); - --- 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( 'fa','per'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fa', 'language', 'fa', 'فارسى'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fa', 'language', 'en', 'Persian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fa', 'language', 'fr', 'Persan'); - --- Polish -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'pl', 'language', 'Polish','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'pl','pol'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pl', 'language', 'pl', 'Polski'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pl', 'language', 'en', 'Polish'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pl', 'language', 'fr', 'Polonais'); - --- Portuguese -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'pt', 'language', 'Portuguese','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'pt','por'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pt', 'language', 'pt', 'Português'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pt', 'language', 'en', 'Portuguese'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pt', 'language', 'fr', 'Portugais'); - --- Romanian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ro', 'language', 'Romanian','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ro','rum'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ro', 'language', 'ro', 'Română'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ro', 'language', 'en', 'Romanian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ro', 'language', 'fr', 'Roumain'); - --- Russian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ru', 'language', 'Russian','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ru','rus'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ru', 'language', 'ru', 'Русский'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ru', 'language', 'en', 'Russian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ru', 'language', 'fr', 'Russe'); - --- Spanish, Castilian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'es', 'language', 'Spanish','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'es','spa'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'es', 'language', 'es', 'Español'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'es', 'language', 'en', 'Spanish'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'es', 'language', 'fr', 'Espagnol'); - --- Spanish, Catalan -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ca', 'language', 'Catalan','2013-01-12' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -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( 'ca', 'language', 'en', 'Catalan'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ca', 'language', 'fr', 'Catalan'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ca', 'language', 'ca', 'Català'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ca', 'language', 'de', 'Katalanisch'); - --- Swedish -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'sv', 'language', 'Swedish','2005-10-16' ); - -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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'sv', 'language', 'fr', 'Suédois'); - --- Thai -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'th', 'language', 'Thai','2005-10-16'); - -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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'th', 'language', 'fr', 'Thaï'); - --- 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'); - - --- 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'); - --- Croatian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'hr', 'language', 'Croatian','2014-07-24' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'hr','hrv'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hr', 'language', 'hr', 'Hrvatski'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hr', 'language', 'en', 'Croatian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hr', 'language', 'fr', 'Croate'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hr', 'language', 'de', 'Kroatisch'); - --- 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'); - --- 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'); - --- 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'); - --- 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', 'Han (Simplified variant)'); - -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)'); - --- 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', 'Han (Traditional variant)'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Hant', 'script', 'en', 'Han (Traditional variant)'); - --- 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', 'Hebrew'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Hebr', 'script', 'en', 'Hebrew'); - --- REGIONS --- 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'); - --- 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', 'fr', 'France'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'FR', 'region', 'en', 'France'); - --- 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'); - --- 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'); - --- 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'); diff --git a/installer/data/mysql/fr-FR/1-Obligatoire/subtag_registry.txt b/installer/data/mysql/fr-FR/1-Obligatoire/subtag_registry.txt deleted file mode 100644 index 26dd31d..0000000 --- a/installer/data/mysql/fr-FR/1-Obligatoire/subtag_registry.txt +++ /dev/null @@ -1,4 +0,0 @@ -Koha support international - -BIDI , Arabe et Hébreu -Liens entre sous-codes de script et langue. diff --git a/installer/data/mysql/it-IT/necessari/subtag_registry.sql b/installer/data/mysql/it-IT/necessari/subtag_registry.sql deleted file mode 100644 index a21ed27..0000000 --- a/installer/data/mysql/it-IT/necessari/subtag_registry.sql +++ /dev/null @@ -1,790 +0,0 @@ -SET FOREIGN_KEY_CHECKS=0; - --- http://www.w3.org/International/articles/language-tags/ - --- BIDI Stuff, Arabic and Hebrew -INSERT INTO language_script_bidi(rfc4646_subtag,bidi) -VALUES( 'Arab', 'rtl'); -INSERT INTO language_script_bidi(rfc4646_subtag,bidi) -VALUES( 'Hebr', 'rtl'); - --- Default mappings between script and language subcodes -INSERT INTO language_script_mapping(language_subtag,script_subtag) -VALUES( 'ar', 'Arab'); -INSERT INTO language_script_mapping(language_subtag,script_subtag) -VALUES( 'he', 'Hebr'); - --- EXTENSIONS --- Interface (i) --- SELECT * FROM language_subtag_registry WHERE type='i'; --- OPAC -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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'opac', 'i', 'fr', '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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'intranet', 'i', 'fr', '????'); - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'prog', 't', 'fr', 'Prog'); - --- LANGUAGES - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'ar', 'language', 'ar', 'العربية'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ar', 'language', 'en', 'Arabic'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ar', 'language', 'fr', 'Arabe'); - --- Armenian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'hy', 'language', 'Armenian','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'hy','hy'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'hy', 'language', 'hy', 'Հայերէն'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hy', 'language', 'en', 'Armenian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hy', 'language', 'fr', 'Armenian'); - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'bg', 'language', 'bg', 'Български'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'bg', 'language', 'en', 'Bulgarian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'bg', 'language', 'fr', 'Bulgare'); - --- 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'); - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'cs', 'language', 'cs', 'čeština'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'cs', 'language', 'en', 'Czech'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'cs', 'language', 'fr', 'Tchèque'); - --- 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'); - -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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'da', 'language', 'fr', 'Danois'); - --- Dutch, Flemish -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'nl', 'language', 'Dutch','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'nl','dut'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'nl', 'language', 'nl', 'Nederlands'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nl', 'language', 'en', 'Dutch'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nl', 'language', 'fr', 'Néerlandais'); - --- 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','en'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'en', 'language', 'en', 'English'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'en', 'language', 'fr', 'Anglais'); - --- English -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'fi', 'language', 'Finnish','2005-10-16' ); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fi', 'language', 'fi', 'suomi'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fi', 'language', 'en', 'Finnish'); - --- French -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'fr', 'language', 'French','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'fr','fr'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fr', 'language', 'en', 'French'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fr', 'language', 'fr', 'Français'); - --- INSERT INTO language_descriptions(subtag, type, lang, description) --- VALUES( 'fr-CA', 'language', 'fr-CA', 'français'); - --- Lao -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'lo', 'language', 'Lao','2005-10-16' ); - --- INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) --- VALUES( 'lo','nor'); ??? - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'lo', 'language', 'lo', 'ພາສາລາວ'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'lo', 'language', 'en', 'Lao'); - --- German -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'de', 'language', 'German','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'de','ger'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'de', 'language', 'de', 'Deutsch'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'de', 'language', 'en', 'German'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -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', 'ελληνικά'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'el', 'language', 'en', 'Greek, Modern [1453- ]'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'el', 'language', 'fr', 'Grec Moderne (Après 1453)'); - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'he', 'language', 'he', 'עברית'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'he', 'language', 'en', 'Hebrew'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'he', 'language', 'fr', 'Hébreu'); - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hi', 'language', 'hi', 'हिन्दी'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hi', 'language', 'en', 'Hindi'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hi', 'language', 'fr', 'Hindi'); - --- Hungarian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'hu', 'language', 'Hungarian','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'hu','hun'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hu', 'language', 'hu', 'Magyar'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hu', 'language', 'en', 'Hungarian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hu', 'language', 'fr', 'Hongrois'); - --- Indonesian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'id', 'language', 'Indonesian','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'id','ind'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'id', 'language', 'id', 'Bahasa Indonesia'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'id', 'language', 'en', 'Indonesian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'id', 'language', 'fr', 'Indonésien'); - --- 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( 'it','ita'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'it', 'language', 'it', 'Italiano'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'it', 'language', 'en', 'Italian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'it', 'language', 'fr', 'Italien'); - --- Japanese -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ja', 'language', 'Japanese','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ja','jpn'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ja', 'language', 'ja', '日本語'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ja', 'language', 'en', 'Japanese'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ja', 'language', 'fr', 'Japonais'); - --- Korean -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ko', 'language', 'Korean','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ko','kor'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ko', 'language', 'ko', '한국어'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ko', 'language', 'en', 'Korean'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ko', 'language', 'fr', 'Coréen'); - --- Latin -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'la', 'language', 'Latin','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'la','lat'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'la', 'language', 'la', 'Latina'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'la', 'language', 'en', 'Latin'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'la', 'language', 'fr', 'Latin'); - --- Galacian - -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'gl', 'language', 'Galician','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'gl','glg'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'gl', 'language', 'gl', 'Galego'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'gl', 'language', 'en', 'Galician'); - --- Norwegian (bokmål) -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'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'nb','nob'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nb', 'language', 'nb', 'Norsk bokmål'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nb', 'language', 'en', 'Norwegian bokmål'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nb', 'language', 'fr', 'Norvégien bokmål'); - --- Norwegian (nynorsk) -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'nn', 'language', 'Norwegian nynorsk','2011-02-14' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'nn','nno'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'nb', 'Norsk nynorsk'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'nn', 'Norsk nynorsk'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'en', 'Norwegian nynorsk'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'fr', 'Norvégien nynorsk'); - --- 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( 'fa','per'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fa', 'language', 'fa', 'فارسى'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fa', 'language', 'en', 'Persian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fa', 'language', 'fr', 'Persan'); - --- Polish -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'pl', 'language', 'Polish','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'pl','pol'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pl', 'language', 'pl', 'Polski'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pl', 'language', 'en', 'Polish'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pl', 'language', 'fr', 'Polonais'); - --- Portuguese -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'pt', 'language', 'Portuguese','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'pt','por'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pt', 'language', 'pt', 'Português'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pt', 'language', 'en', 'Portuguese'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pt', 'language', 'fr', 'Portugais'); - --- Romanian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ro', 'language', 'Romanian','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ro','rum'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ro', 'language', 'ro', 'Română'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ro', 'language', 'en', 'Romanian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ro', 'language', 'fr', 'Roumain'); - --- Russian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ru', 'language', 'Russian','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ru','rus'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ru', 'language', 'ru', 'Русский'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ru', 'language', 'en', 'Russian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ru', 'language', 'fr', 'Russe'); - --- Serbian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'sr', 'language', 'Serbian','2005-10-16' ); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'sr', 'language', 'sr', 'српски'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'sr', 'language', 'en', 'Serbian'); - --- Spanish, Castilian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'es', 'language', 'Spanish','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'es','spa'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'es', 'language', 'es', 'Español'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'es', 'language', 'en', 'Spanish'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'es', 'language', 'fr', 'Espagnol'); - --- Spanish, Catalan -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ca', 'language', 'Catalan','2013-01-12' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -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( 'ca', 'language', 'en', 'Catalan'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ca', 'language', 'fr', 'Catalan'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ca', 'language', 'ca', 'Català'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ca', 'language', 'de', 'Katalanisch'); - --- Swedish -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'sv', 'language', 'Swedish','2005-10-16' ); - -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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'sv', 'language', 'fr', 'Suédois'); - --- Tetum -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'tet', 'language', 'Tetum','2005-10-16' ); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'tet', 'language', 'tet', 'tetun'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'tet', 'language', 'en', 'Tetum'); - --- Thai -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'th', 'language', 'Thai','2005-10-16'); - -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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'th', 'language', 'fr', 'Thaï'); - --- 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'); - - --- 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'); - --- English -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ur', 'language', 'Urdu','2005-10-16' ); - -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', 'اردو'); - --- 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'); - --- 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'); - --- 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'); - --- 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', 'Han (Simplified variant)'); - -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)'); - --- 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', 'Han (Traditional variant)'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Hant', 'script', 'en', 'Han (Traditional variant)'); - --- 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', 'Hebrew'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Hebr', 'script', 'en', 'Hebrew'); - --- 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', 'lo', 'Lao'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Laoo', 'script', 'en', 'Lao'); - --- Croatian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'hr', 'language', 'Croatian','2014-07-24' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'hr','hrv'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hr', 'language', 'hr', 'Hrvatski'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hr', 'language', 'en', 'Croatian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hr', 'language', 'fr', 'Croate'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hr', 'language', 'de', 'Kroatisch'); - - --- REGIONS --- 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'); - --- 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'); - --- 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', 'fr', 'France'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'FR', 'region', 'en', 'France'); - --- 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'); - --- 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'); - --- 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'); - -SET FOREIGN_KEY_CHECKS=1; diff --git a/installer/data/mysql/it-IT/necessari/subtag_registry.txt b/installer/data/mysql/it-IT/necessari/subtag_registry.txt deleted file mode 100644 index 5dc9d53..0000000 --- a/installer/data/mysql/it-IT/necessari/subtag_registry.txt +++ /dev/null @@ -1,5 +0,0 @@ -Supporto I18N di Koha - -Gestione lingue scritte da destra (Arabo ed Ebraico). -Collegamenti predefinti tra alfabeti e codici di lingua ISO -Estensioni delle lingue diff --git a/installer/data/mysql/en/mandatory/subtag_registry.sql b/installer/data/mysql/mandatory/subtag_registry.sql similarity index 100% rename from installer/data/mysql/en/mandatory/subtag_registry.sql rename to installer/data/mysql/mandatory/subtag_registry.sql diff --git a/installer/data/mysql/en/mandatory/subtag_registry.txt b/installer/data/mysql/mandatory/subtag_registry.txt similarity index 100% rename from installer/data/mysql/en/mandatory/subtag_registry.txt rename to installer/data/mysql/mandatory/subtag_registry.txt diff --git a/installer/data/mysql/nb-NO/1-Obligatorisk/subtag_registry.sql b/installer/data/mysql/nb-NO/1-Obligatorisk/subtag_registry.sql deleted file mode 100644 index 9748f21..0000000 --- a/installer/data/mysql/nb-NO/1-Obligatorisk/subtag_registry.sql +++ /dev/null @@ -1,819 +0,0 @@ --- --- Default classification sources and filing rules --- for Koha. --- --- Copyright (C) 2008 LibLime --- --- This file is part of Koha. --- --- Koha is free software; you can redistribute it and/or modify it under the --- terms of the GNU General Public License as published by the Free Software --- Foundation; either version 2 of the License, or (at your option) any later --- version. --- --- Koha is distributed in the hope that it will be useful, but WITHOUT ANY --- WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR --- A PARTICULAR PURPOSE. See the GNU General Public License for more details. --- --- You should have received a copy of the GNU General Public License along --- with Koha; if not, write to the Free Software Foundation, Inc., --- 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA. - --- http://www.w3.org/International/articles/language-tags/ - --- BIDI Stuff, Arabic and Hebrew -INSERT INTO language_script_bidi(rfc4646_subtag,bidi) -VALUES( 'Arab', 'rtl'); -INSERT INTO language_script_bidi(rfc4646_subtag,bidi) -VALUES( 'Hebr', 'rtl'); - --- Default mappings between script and language subcodes -INSERT INTO language_script_mapping(language_subtag,script_subtag) -VALUES( 'ar', 'Arab'); -INSERT INTO language_script_mapping(language_subtag,script_subtag) -VALUES( 'he', 'Hebr'); - --- EXTENSIONS --- Interface (i) --- SELECT * FROM language_subtag_registry WHERE type='i'; --- OPAC -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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'opac', 'i', 'fr', '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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'intranet', 'i', 'fr', '????'); - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'prog', 't', 'fr', 'Prog'); - --- LANGUAGES - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'ar', 'language', 'ar', 'العربية'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ar', 'language', 'en', 'Arabic'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ar', 'language', 'fr', 'Arabe'); - --- Armenian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'hy', 'language', 'Armenian','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'hy','arm'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'hy', 'language', 'hy', 'Հայերէն'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hy', 'language', 'en', 'Armenian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hy', 'language', 'fr', 'Armenian'); - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'bg', 'language', 'bg', 'Български'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'bg', 'language', 'en', 'Bulgarian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'bg', 'language', 'fr', 'Bulgare'); - --- 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'); - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'cs', 'language', 'cs', 'čeština'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'cs', 'language', 'en', 'Czech'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'cs', 'language', 'fr', 'Tchèque'); - --- 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'); - -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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'da', 'language', 'fr', 'Danois'); - --- Dutch, Flemish -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'nl', 'language', 'Dutch','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'nl','dut'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'nl', 'language', 'nl', 'Nederlands'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nl', 'language', 'en', 'Dutch'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nl', 'language', 'fr', 'Néerlandais'); - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'en', 'language', 'en', 'English'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'en', 'language', 'fr', 'Anglais'); - --- Finnish -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'fi', 'language', 'Finnish','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'fi','fin'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fi', 'language', 'fi', 'suomi'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fi', 'language', 'en', 'Finnish'); - --- French -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'fr', 'language', 'French','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'fr','fre'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fr', 'language', 'en', 'French'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fr', 'language', 'fr', 'Français'); - --- INSERT INTO language_descriptions(subtag, type, lang, description) --- VALUES( 'fr-CA', 'language', 'fr-CA', 'français'); - --- Lao -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'lo', 'language', 'Lao','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'lo','lao'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'lo', 'language', 'lo', 'ພາສາລາວ'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'lo', 'language', 'en', 'Lao'); - --- German -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'de', 'language', 'German','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'de','ger'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'de', 'language', 'de', 'Deutsch'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'de', 'language', 'en', 'German'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -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', 'ελληνικά'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'el', 'language', 'en', 'Greek, Modern [1453- ]'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'el', 'language', 'fr', 'Grec Moderne (Après 1453)'); - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'he', 'language', 'he', 'עברית'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'he', 'language', 'en', 'Hebrew'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'he', 'language', 'fr', 'Hébreu'); - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hi', 'language', 'hi', 'हिन्दी'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hi', 'language', 'en', 'Hindi'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hi', 'language', 'fr', 'Hindi'); - --- Hungarian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'hu', 'language', 'Hungarian','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'hu','hun'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hu', 'language', 'hu', 'Magyar'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hu', 'language', 'en', 'Hungarian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hu', 'language', 'fr', 'Hongrois'); - --- Indonesian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'id', 'language', 'Indonesian','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'id','ind'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'id', 'language', 'id', 'Bahasa Indonesia'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'id', 'language', 'en', 'Indonesian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'id', 'language', 'fr', 'Indonésien'); - --- 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( 'it','ita'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'it', 'language', 'it', 'Italiano'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'it', 'language', 'en', 'Italian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'it', 'language', 'fr', 'Italien'); - --- Japanese -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ja', 'language', 'Japanese','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ja','jpn'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ja', 'language', 'ja', '日本語'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ja', 'language', 'en', 'Japanese'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ja', 'language', 'fr', 'Japonais'); - --- Korean -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ko', 'language', 'Korean','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ko','kor'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ko', 'language', 'ko', '한국어'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ko', 'language', 'en', 'Korean'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ko', 'language', 'fr', 'Coréen'); - --- Latin -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'la', 'language', 'Latin','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'la','lat'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'la', 'language', 'la', 'Latina'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'la', 'language', 'en', 'Latin'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'la', 'language', 'fr', 'Latin'); - --- Galician - -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'gl', 'language', 'Galician','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'gl','glg'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'gl', 'language', 'gl', 'Galego'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'gl', 'language', 'en', 'Galician'); - --- Norwegian (bokmål) -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'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'nb','nob'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nb', 'language', 'nb', 'Norsk bokmål'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nb', 'language', 'en', 'Norwegian bokmål'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nb', 'language', 'fr', 'Norvégien bokmål'); - --- Norwegian (nynorsk) -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'nn', 'language', 'Norwegian nynorsk','2011-02-14' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'nn','nno'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'nb', 'Norsk nynorsk'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'nn', 'Norsk nynorsk'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'en', 'Norwegian nynorsk'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'fr', 'Norvégien nynorsk'); - --- 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( 'fa','per'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fa', 'language', 'fa', 'فارسى'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fa', 'language', 'en', 'Persian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fa', 'language', 'fr', 'Persan'); - --- Polish -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'pl', 'language', 'Polish','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'pl','pol'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pl', 'language', 'pl', 'Polski'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pl', 'language', 'en', 'Polish'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pl', 'language', 'fr', 'Polonais'); - --- Portuguese -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'pt', 'language', 'Portuguese','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'pt','por'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pt', 'language', 'pt', 'Português'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pt', 'language', 'en', 'Portuguese'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pt', 'language', 'fr', 'Portugais'); - --- Romanian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ro', 'language', 'Romanian','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ro','rum'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ro', 'language', 'ro', 'Română'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ro', 'language', 'en', 'Romanian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ro', 'language', 'fr', 'Roumain'); - --- Russian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ru', 'language', 'Russian','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ru','rus'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ru', 'language', 'ru', 'Русский'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ru', 'language', 'en', 'Russian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ru', 'language', 'fr', 'Russe'); - --- 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( 'sr', 'language', 'sr', 'српски'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'sr', 'language', 'en', 'Serbian'); - --- Spanish, Castilian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'es', 'language', 'Spanish','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'es','spa'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'es', 'language', 'es', 'Español'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'es', 'language', 'en', 'Spanish'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'es', 'language', 'fr', 'Espagnol'); - --- Spanish, Catalan -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ca', 'language', 'Catalan','2013-01-12' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -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( 'ca', 'language', 'en', 'Catalan'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ca', 'language', 'fr', 'Catalan'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ca', 'language', 'ca', 'Català'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ca', 'language', 'de', 'Katalanisch'); - --- Swedish -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'sv', 'language', 'Swedish','2005-10-16' ); - -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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'sv', 'language', 'fr', 'Suédois'); - --- Tetum -INSERT INTO language_subtag_registry( subtag, type, description, added) -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( 'tet', 'language', 'tet', 'tetun'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'tet', 'language', 'en', 'Tetum'); - --- Thai -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'th', 'language', 'Thai','2005-10-16'); - -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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'th', 'language', 'fr', 'Thaï'); - --- 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'); - - --- 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'); - --- 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', 'اردو'); - --- 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'); - --- 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'); - --- 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'); - --- 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', 'Han (Simplified variant)'); - -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)'); - --- 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', 'Han (Traditional variant)'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Hant', 'script', 'en', 'Han (Traditional variant)'); - --- 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', 'Hebrew'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Hebr', 'script', 'en', 'Hebrew'); - --- 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', 'lo', 'Lao'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Laoo', 'script', 'en', 'Lao'); - --- Croatian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'hr', 'language', 'Croatian','2014-07-24' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'hr','hrv'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hr', 'language', 'hr', 'Hrvatski'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hr', 'language', 'en', 'Croatian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hr', 'language', 'fr', 'Croate'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hr', 'language', 'de', 'Kroatisch'); - - --- REGIONS --- 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'); - --- 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'); - --- 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', 'fr', 'France'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'FR', 'region', 'en', 'France'); - --- 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'); - --- 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'); - --- 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'); diff --git a/installer/data/mysql/nb-NO/1-Obligatorisk/subtag_registry.txt b/installer/data/mysql/nb-NO/1-Obligatorisk/subtag_registry.txt deleted file mode 100644 index 70219c0..0000000 --- a/installer/data/mysql/nb-NO/1-Obligatorisk/subtag_registry.txt +++ /dev/null @@ -1 +0,0 @@ -Støtte for flerspråklighet. diff --git a/installer/data/mysql/pl-PL/mandatory/subtag_registry.sql b/installer/data/mysql/pl-PL/mandatory/subtag_registry.sql deleted file mode 100644 index d62b007..0000000 --- a/installer/data/mysql/pl-PL/mandatory/subtag_registry.sql +++ /dev/null @@ -1,786 +0,0 @@ --- http://www.w3.org/International/articles/language-tags/ - --- BIDI Stuff, Arabic and Hebrew -INSERT INTO language_script_bidi(rfc4646_subtag,bidi) -VALUES( 'Arab', 'rtl'); -INSERT INTO language_script_bidi(rfc4646_subtag,bidi) -VALUES( 'Hebr', 'rtl'); - --- Default mappings between script and language subcodes -INSERT INTO language_script_mapping(language_subtag,script_subtag) -VALUES( 'ar', 'Arab'); -INSERT INTO language_script_mapping(language_subtag,script_subtag) -VALUES( 'he', 'Hebr'); - --- EXTENSIONS --- Interface (i) --- SELECT * FROM language_subtag_registry WHERE type='i'; --- OPAC -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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'opac', 'i', 'fr', '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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'intranet', 'i', 'fr', '????'); - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'prog', 't', 'fr', 'Prog'); - --- LANGUAGES - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'ar', 'language', 'ar', 'العربية'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ar', 'language', 'en', 'Arabic'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ar', 'language', 'fr', 'Arabe'); - --- Armenian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'hy', 'language', 'Armenian','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'hy','hy'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'hy', 'language', 'hy', 'Հայերէն'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hy', 'language', 'en', 'Armenian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hy', 'language', 'fr', 'Armenian'); - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'bg', 'language', 'bg', 'Български'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'bg', 'language', 'en', 'Bulgarian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'bg', 'language', 'fr', 'Bulgare'); - --- 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'); - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'cs', 'language', 'cs', 'čeština'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'cs', 'language', 'en', 'Czech'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'cs', 'language', 'fr', 'Tchèque'); - --- 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'); - -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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'da', 'language', 'fr', 'Danois'); - --- Dutch, Flemish -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'nl', 'language', 'Dutch','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'nl','dut'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'nl', 'language', 'nl', 'Nederlands'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nl', 'language', 'en', 'Dutch'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nl', 'language', 'fr', 'Néerlandais'); - --- 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','en'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'en', 'language', 'en', 'English'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'en', 'language', 'fr', 'Anglais'); - --- English -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'fi', 'language', 'Finnish','2005-10-16' ); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fi', 'language', 'fi', 'suomi'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fi', 'language', 'en', 'Finnish'); - --- French -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'fr', 'language', 'French','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'fr','fr'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fr', 'language', 'en', 'French'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fr', 'language', 'fr', 'Français'); - --- INSERT INTO language_descriptions(subtag, type, lang, description) --- VALUES( 'fr-CA', 'language', 'fr-CA', 'français'); - --- Lao -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'lo', 'language', 'Lao','2005-10-16' ); - --- INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) --- VALUES( 'lo','nor'); ??? - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'lo', 'language', 'lo', 'ພາສາລາວ'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'lo', 'language', 'en', 'Lao'); - --- German -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'de', 'language', 'German','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'de','ger'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'de', 'language', 'de', 'Deutsch'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'de', 'language', 'en', 'German'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -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', 'ελληνικά'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'el', 'language', 'en', 'Greek, Modern [1453- ]'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'el', 'language', 'fr', 'Grec Moderne (Après 1453)'); - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'he', 'language', 'he', 'עברית'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'he', 'language', 'en', 'Hebrew'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'he', 'language', 'fr', 'Hébreu'); - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hi', 'language', 'hi', 'हिन्दी'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hi', 'language', 'en', 'Hindi'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hi', 'language', 'fr', 'Hindi'); - --- Hungarian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'hu', 'language', 'Hungarian','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'hu','hun'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hu', 'language', 'hu', 'Magyar'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hu', 'language', 'en', 'Hungarian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hu', 'language', 'fr', 'Hongrois'); - --- Indonesian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'id', 'language', 'Indonesian','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'id','ind'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'id', 'language', 'id', 'Bahasa Indonesia'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'id', 'language', 'en', 'Indonesian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'id', 'language', 'fr', 'Indonésien'); - --- 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( 'it','ita'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'it', 'language', 'it', 'Italiano'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'it', 'language', 'en', 'Italian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'it', 'language', 'fr', 'Italien'); - --- Japanese -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ja', 'language', 'Japanese','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ja','jpn'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ja', 'language', 'ja', '日本語'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ja', 'language', 'en', 'Japanese'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ja', 'language', 'fr', 'Japonais'); - --- Korean -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ko', 'language', 'Korean','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ko','kor'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ko', 'language', 'ko', '한국어'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ko', 'language', 'en', 'Korean'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ko', 'language', 'fr', 'Coréen'); - --- Latin -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'la', 'language', 'Latin','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'la','lat'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'la', 'language', 'la', 'Latina'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'la', 'language', 'en', 'Latin'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'la', 'language', 'fr', 'Latin'); - --- Galacian - -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'gl', 'language', 'Galician','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'gl','glg'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'gl', 'language', 'gl', 'Galego'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'gl', 'language', 'en', 'Galician'); - --- Norwegian (bokmål) -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'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'nb','nob'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nb', 'language', 'nb', 'Norsk bokmål'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nb', 'language', 'en', 'Norwegian bokmål'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nb', 'language', 'fr', 'Norvégien bokmål'); - --- Norwegian (nynorsk) -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'nn', 'language', 'Norwegian nynorsk','2011-02-14' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'nn','nno'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'nb', 'Norsk nynorsk'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'nn', 'Norsk nynorsk'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'en', 'Norwegian nynorsk'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'fr', 'Norvégien nynorsk'); - --- 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( 'fa','per'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fa', 'language', 'fa', 'فارسى'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fa', 'language', 'en', 'Persian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fa', 'language', 'fr', 'Persan'); - --- Polish -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'pl', 'language', 'Polish','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'pl','pol'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pl', 'language', 'pl', 'Polski'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pl', 'language', 'en', 'Polish'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pl', 'language', 'fr', 'Polonais'); - --- Portuguese -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'pt', 'language', 'Portuguese','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'pt','pol'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pt', 'language', 'pt', 'Português'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pt', 'language', 'en', 'Portuguese'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pt', 'language', 'fr', 'Portugais'); - --- Romanian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ro', 'language', 'Romanian','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ro','rum'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ro', 'language', 'ro', 'Română'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ro', 'language', 'en', 'Romanian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ro', 'language', 'fr', 'Roumain'); - --- Russian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ru', 'language', 'Russian','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ru','rus'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ru', 'language', 'ru', 'Русский'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ru', 'language', 'en', 'Russian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ru', 'language', 'fr', 'Russe'); - --- Serbian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'sr', 'language', 'Serbian','2005-10-16' ); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'sr', 'language', 'sr', 'српски'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'sr', 'language', 'en', 'Serbian'); - --- Spanish, Castilian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'es', 'language', 'Spanish','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'es','spa'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'es', 'language', 'es', 'Español'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'es', 'language', 'en', 'Spanish'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'es', 'language', 'fr', 'Espagnol'); - --- Spanish, Catalan -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ca', 'language', 'Catalan','2013-01-12' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -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( 'ca', 'language', 'en', 'Catalan'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ca', 'language', 'fr', 'Catalan'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ca', 'language', 'ca', 'Català'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ca', 'language', 'de', 'Katalanisch'); - --- Swedish -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'sv', 'language', 'Swedish','2005-10-16' ); - -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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'sv', 'language', 'fr', 'Suédois'); - --- Tetum -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'tet', 'language', 'Tetum','2005-10-16' ); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'tet', 'language', 'tet', 'tetun'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'tet', 'language', 'en', 'Tetum'); - --- Thai -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'th', 'language', 'Thai','2005-10-16'); - -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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'th', 'language', 'fr', 'Thaï'); - --- 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'); - - --- 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'); - --- English -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ur', 'language', 'Urdu','2005-10-16' ); - -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', 'اردو'); - --- 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'); - --- 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'); - --- 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'); - --- 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', 'Han (Simplified variant)'); - -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)'); - --- 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', 'Han (Traditional variant)'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Hant', 'script', 'en', 'Han (Traditional variant)'); - --- 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', 'Hebrew'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Hebr', 'script', 'en', 'Hebrew'); - --- 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', 'lo', 'Lao'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Laoo', 'script', 'en', 'Lao'); - --- Croatian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'hr', 'language', 'Croatian','2014-07-24' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'hr','hrv'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hr', 'language', 'hr', 'Hrvatski'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hr', 'language', 'en', 'Croatian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hr', 'language', 'fr', 'Croate'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hr', 'language', 'de', 'Kroatisch'); - - --- REGIONS --- 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'); - --- 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'); - --- 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', 'fr', 'France'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'FR', 'region', 'en', 'France'); - --- 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'); - --- 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'); - --- 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'); diff --git a/installer/data/mysql/pl-PL/mandatory/subtag_registry.txt b/installer/data/mysql/pl-PL/mandatory/subtag_registry.txt deleted file mode 100644 index 5d3c96d..0000000 --- a/installer/data/mysql/pl-PL/mandatory/subtag_registry.txt +++ /dev/null @@ -1,5 +0,0 @@ -Wsparcie Koha dla I18N - -Tłumaczenia dwukierunkowe, arabski i and hebrajski -Domyślne mapowania pomiędzy skryptem a subkodami języków -Rozszerzenia języków diff --git a/installer/data/mysql/ru-RU/mandatory/subtag_registry.sql b/installer/data/mysql/ru-RU/mandatory/subtag_registry.sql deleted file mode 100644 index 5e3b60f..0000000 --- a/installer/data/mysql/ru-RU/mandatory/subtag_registry.sql +++ /dev/null @@ -1,786 +0,0 @@ --- http://www.w3.org/International/articles/language-tags/ - --- BIDI Stuff, Arabic and Hebrew -INSERT INTO language_script_bidi(rfc4646_subtag,bidi) -VALUES( 'Arab', 'rtl'); -INSERT INTO language_script_bidi(rfc4646_subtag,bidi) -VALUES( 'Hebr', 'rtl'); - --- Default mappings between script and language subcodes -INSERT INTO language_script_mapping(language_subtag,script_subtag) -VALUES( 'ar', 'Arab'); -INSERT INTO language_script_mapping(language_subtag,script_subtag) -VALUES( 'he', 'Hebr'); - --- EXTENSIONS --- Interface (i) --- SELECT * FROM language_subtag_registry WHERE type='i'; --- OPAC -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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'opac', 'i', 'fr', '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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'intranet', 'i', 'fr', '????'); - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'prog', 't', 'fr', 'Prog'); - --- LANGUAGES - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'ar', 'language', 'ar', 'العربية'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ar', 'language', 'en', 'Arabic'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ar', 'language', 'fr', 'Arabe'); - --- Armenian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'hy', 'language', 'Armenian','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'hy','hy'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'hy', 'language', 'hy', 'Հայերէն'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hy', 'language', 'en', 'Armenian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hy', 'language', 'fr', 'Armenian'); - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'bg', 'language', 'bg', 'Български'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'bg', 'language', 'en', 'Bulgarian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'bg', 'language', 'fr', 'Bulgare'); - --- 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'); - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'cs', 'language', 'cs', 'čeština'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'cs', 'language', 'en', 'Czech'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'cs', 'language', 'fr', 'Tchèque'); - --- 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'); - -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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'da', 'language', 'fr', 'Danois'); - --- Dutch, Flemish -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'nl', 'language', 'Dutch','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'nl','dut'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'nl', 'language', 'nl', 'Nederlands'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nl', 'language', 'en', 'Dutch'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nl', 'language', 'fr', 'Néerlandais'); - --- 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','en'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'en', 'language', 'en', 'English'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'en', 'language', 'fr', 'Anglais'); - --- English -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'fi', 'language', 'Finnish','2005-10-16' ); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fi', 'language', 'fi', 'suomi'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fi', 'language', 'en', 'Finnish'); - --- French -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'fr', 'language', 'French','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'fr','fr'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fr', 'language', 'en', 'French'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fr', 'language', 'fr', 'Français'); - --- INSERT INTO language_descriptions(subtag, type, lang, description) --- VALUES( 'fr-CA', 'language', 'fr-CA', 'français'); - --- Lao -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'lo', 'language', 'Lao','2005-10-16' ); - --- INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) --- VALUES( 'lo','nor'); ??? - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'lo', 'language', 'lo', 'ພາສາລາວ'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'lo', 'language', 'en', 'Lao'); - --- German -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'de', 'language', 'German','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'de','ger'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'de', 'language', 'de', 'Deutsch'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'de', 'language', 'en', 'German'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -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', 'ελληνικά'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'el', 'language', 'en', 'Greek, Modern [1453- ]'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'el', 'language', 'fr', 'Grec Moderne (Après 1453)'); - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'he', 'language', 'he', 'עברית'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'he', 'language', 'en', 'Hebrew'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'he', 'language', 'fr', 'Hébreu'); - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hi', 'language', 'hi', 'हिन्दी'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hi', 'language', 'en', 'Hindi'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hi', 'language', 'fr', 'Hindi'); - --- Hungarian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'hu', 'language', 'Hungarian','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'hu','hun'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hu', 'language', 'hu', 'Magyar'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hu', 'language', 'en', 'Hungarian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hu', 'language', 'fr', 'Hongrois'); - --- Indonesian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'id', 'language', 'Indonesian','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'id','ind'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'id', 'language', 'id', 'Bahasa Indonesia'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'id', 'language', 'en', 'Indonesian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'id', 'language', 'fr', 'Indonésien'); - --- 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( 'it','ita'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'it', 'language', 'it', 'Italiano'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'it', 'language', 'en', 'Italian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'it', 'language', 'fr', 'Italien'); - --- Japanese -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ja', 'language', 'Japanese','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ja','jpn'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ja', 'language', 'ja', '日本語'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ja', 'language', 'en', 'Japanese'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ja', 'language', 'fr', 'Japonais'); - --- Korean -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ko', 'language', 'Korean','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ko','kor'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ko', 'language', 'ko', '한국어'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ko', 'language', 'en', 'Korean'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ko', 'language', 'fr', 'Coréen'); - --- Latin -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'la', 'language', 'Latin','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'la','lat'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'la', 'language', 'la', 'Latina'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'la', 'language', 'en', 'Latin'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'la', 'language', 'fr', 'Latin'); - --- Galacian - -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'gl', 'language', 'Galician','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'gl','glg'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'gl', 'language', 'gl', 'Galego'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'gl', 'language', 'en', 'Galician'); - --- Norwegian (bokmål) -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'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'nb','nob'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nb', 'language', 'nb', 'Norsk bokmål'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nb', 'language', 'en', 'Norwegian bokmål'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nb', 'language', 'fr', 'Norvégien bokmål'); - --- Norwegian (nynorsk) -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'nn', 'language', 'Norwegian nynorsk','2011-02-14' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'nn','nno'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'nb', 'Norsk nynorsk'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'nn', 'Norsk nynorsk'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'en', 'Norwegian nynorsk'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'fr', 'Norvégien nynorsk'); - --- 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( 'fa','per'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fa', 'language', 'fa', 'فارسى'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fa', 'language', 'en', 'Persian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fa', 'language', 'fr', 'Persan'); - --- Polish -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'pl', 'language', 'Polish','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'pl','pol'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pl', 'language', 'pl', 'Polski'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pl', 'language', 'en', 'Polish'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pl', 'language', 'fr', 'Polonais'); - --- Portuguese -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'pt', 'language', 'Portuguese','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'pt','por'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pt', 'language', 'pt', 'Português'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pt', 'language', 'en', 'Portuguese'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pt', 'language', 'fr', 'Portugais'); - --- Romanian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ro', 'language', 'Romanian','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ro','rum'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ro', 'language', 'ro', 'Română'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ro', 'language', 'en', 'Romanian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ro', 'language', 'fr', 'Roumain'); - --- Russian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ru', 'language', 'Russian','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ru','rus'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ru', 'language', 'ru', 'Русский'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ru', 'language', 'en', 'Russian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ru', 'language', 'fr', 'Russe'); - --- Serbian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'sr', 'language', 'Serbian','2005-10-16' ); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'sr', 'language', 'sr', 'српски'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'sr', 'language', 'en', 'Serbian'); - --- Spanish, Castilian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'es', 'language', 'Spanish','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'es','spa'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'es', 'language', 'es', 'Español'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'es', 'language', 'en', 'Spanish'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'es', 'language', 'fr', 'Espagnol'); - --- Spanish, Catalan -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ca', 'language', 'Catalan','2013-01-12' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -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( 'ca', 'language', 'en', 'Catalan'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ca', 'language', 'fr', 'Catalan'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ca', 'language', 'ca', 'Català'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ca', 'language', 'de', 'Katalanisch'); - --- Swedish -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'sv', 'language', 'Swedish','2005-10-16' ); - -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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'sv', 'language', 'fr', 'Suédois'); - --- Tetum -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'tet', 'language', 'Tetum','2005-10-16' ); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'tet', 'language', 'tet', 'tetun'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'tet', 'language', 'en', 'Tetum'); - --- Thai -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'th', 'language', 'Thai','2005-10-16'); - -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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'th', 'language', 'fr', 'Thaï'); - --- 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'); - - --- 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'); - --- English -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ur', 'language', 'Urdu','2005-10-16' ); - -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', 'اردو'); - --- 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'); - --- 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'); - --- 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'); - --- 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', 'Han (Simplified variant)'); - -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)'); - --- 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', 'Han (Traditional variant)'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Hant', 'script', 'en', 'Han (Traditional variant)'); - --- 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', 'Hebrew'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Hebr', 'script', 'en', 'Hebrew'); - --- 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', 'lo', 'Lao'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Laoo', 'script', 'en', 'Lao'); - --- Croatian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'hr', 'language', 'Croatian','2014-07-24' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'hr','hrv'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hr', 'language', 'hr', 'Hrvatski'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hr', 'language', 'en', 'Croatian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hr', 'language', 'fr', 'Croate'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hr', 'language', 'de', 'Kroatisch'); - - --- REGIONS --- 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'); - --- 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'); - --- 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', 'fr', 'France'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'FR', 'region', 'en', 'France'); - --- 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'); - --- 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'); - --- 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'); diff --git a/installer/data/mysql/ru-RU/mandatory/subtag_registry.txt b/installer/data/mysql/ru-RU/mandatory/subtag_registry.txt deleted file mode 100644 index 8a5db01..0000000 --- a/installer/data/mysql/ru-RU/mandatory/subtag_registry.txt +++ /dev/null @@ -1,4 +0,0 @@ -Поддержка интернационализации (I18N) в Koha -Поддержка двунаправленности (BIDI); арабский и иврит. -Стандартное отображение между письмом и подкодами языка. -Расширения языка. diff --git a/installer/data/mysql/uk-UA/mandatory/subtag_registry.sql b/installer/data/mysql/uk-UA/mandatory/subtag_registry.sql deleted file mode 100644 index 5e3b60f..0000000 --- a/installer/data/mysql/uk-UA/mandatory/subtag_registry.sql +++ /dev/null @@ -1,786 +0,0 @@ --- http://www.w3.org/International/articles/language-tags/ - --- BIDI Stuff, Arabic and Hebrew -INSERT INTO language_script_bidi(rfc4646_subtag,bidi) -VALUES( 'Arab', 'rtl'); -INSERT INTO language_script_bidi(rfc4646_subtag,bidi) -VALUES( 'Hebr', 'rtl'); - --- Default mappings between script and language subcodes -INSERT INTO language_script_mapping(language_subtag,script_subtag) -VALUES( 'ar', 'Arab'); -INSERT INTO language_script_mapping(language_subtag,script_subtag) -VALUES( 'he', 'Hebr'); - --- EXTENSIONS --- Interface (i) --- SELECT * FROM language_subtag_registry WHERE type='i'; --- OPAC -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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'opac', 'i', 'fr', '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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'intranet', 'i', 'fr', '????'); - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'prog', 't', 'fr', 'Prog'); - --- LANGUAGES - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'ar', 'language', 'ar', 'العربية'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ar', 'language', 'en', 'Arabic'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ar', 'language', 'fr', 'Arabe'); - --- Armenian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'hy', 'language', 'Armenian','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'hy','hy'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'hy', 'language', 'hy', 'Հայերէն'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hy', 'language', 'en', 'Armenian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hy', 'language', 'fr', 'Armenian'); - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'bg', 'language', 'bg', 'Български'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'bg', 'language', 'en', 'Bulgarian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'bg', 'language', 'fr', 'Bulgare'); - --- 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'); - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'cs', 'language', 'cs', 'čeština'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'cs', 'language', 'en', 'Czech'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'cs', 'language', 'fr', 'Tchèque'); - --- 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'); - -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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'da', 'language', 'fr', 'Danois'); - --- Dutch, Flemish -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'nl', 'language', 'Dutch','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'nl','dut'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'nl', 'language', 'nl', 'Nederlands'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nl', 'language', 'en', 'Dutch'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nl', 'language', 'fr', 'Néerlandais'); - --- 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','en'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'en', 'language', 'en', 'English'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'en', 'language', 'fr', 'Anglais'); - --- English -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'fi', 'language', 'Finnish','2005-10-16' ); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fi', 'language', 'fi', 'suomi'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fi', 'language', 'en', 'Finnish'); - --- French -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'fr', 'language', 'French','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'fr','fr'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fr', 'language', 'en', 'French'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fr', 'language', 'fr', 'Français'); - --- INSERT INTO language_descriptions(subtag, type, lang, description) --- VALUES( 'fr-CA', 'language', 'fr-CA', 'français'); - --- Lao -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'lo', 'language', 'Lao','2005-10-16' ); - --- INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) --- VALUES( 'lo','nor'); ??? - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'lo', 'language', 'lo', 'ພາສາລາວ'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'lo', 'language', 'en', 'Lao'); - --- German -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'de', 'language', 'German','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'de','ger'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'de', 'language', 'de', 'Deutsch'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'de', 'language', 'en', 'German'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -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', 'ελληνικά'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'el', 'language', 'en', 'Greek, Modern [1453- ]'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'el', 'language', 'fr', 'Grec Moderne (Après 1453)'); - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'he', 'language', 'he', 'עברית'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'he', 'language', 'en', 'Hebrew'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'he', 'language', 'fr', 'Hébreu'); - --- 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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hi', 'language', 'hi', 'हिन्दी'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hi', 'language', 'en', 'Hindi'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hi', 'language', 'fr', 'Hindi'); - --- Hungarian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'hu', 'language', 'Hungarian','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'hu','hun'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hu', 'language', 'hu', 'Magyar'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hu', 'language', 'en', 'Hungarian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hu', 'language', 'fr', 'Hongrois'); - --- Indonesian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'id', 'language', 'Indonesian','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'id','ind'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'id', 'language', 'id', 'Bahasa Indonesia'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'id', 'language', 'en', 'Indonesian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'id', 'language', 'fr', 'Indonésien'); - --- 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( 'it','ita'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'it', 'language', 'it', 'Italiano'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'it', 'language', 'en', 'Italian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'it', 'language', 'fr', 'Italien'); - --- Japanese -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ja', 'language', 'Japanese','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ja','jpn'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ja', 'language', 'ja', '日本語'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ja', 'language', 'en', 'Japanese'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ja', 'language', 'fr', 'Japonais'); - --- Korean -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ko', 'language', 'Korean','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ko','kor'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ko', 'language', 'ko', '한국어'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ko', 'language', 'en', 'Korean'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ko', 'language', 'fr', 'Coréen'); - --- Latin -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'la', 'language', 'Latin','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'la','lat'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'la', 'language', 'la', 'Latina'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'la', 'language', 'en', 'Latin'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'la', 'language', 'fr', 'Latin'); - --- Galacian - -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'gl', 'language', 'Galician','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'gl','glg'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'gl', 'language', 'gl', 'Galego'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'gl', 'language', 'en', 'Galician'); - --- Norwegian (bokmål) -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'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'nb','nob'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nb', 'language', 'nb', 'Norsk bokmål'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nb', 'language', 'en', 'Norwegian bokmål'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nb', 'language', 'fr', 'Norvégien bokmål'); - --- Norwegian (nynorsk) -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'nn', 'language', 'Norwegian nynorsk','2011-02-14' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'nn','nno'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'nb', 'Norsk nynorsk'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'nn', 'Norsk nynorsk'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'en', 'Norwegian nynorsk'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'fr', 'Norvégien nynorsk'); - --- 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( 'fa','per'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fa', 'language', 'fa', 'فارسى'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fa', 'language', 'en', 'Persian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fa', 'language', 'fr', 'Persan'); - --- Polish -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'pl', 'language', 'Polish','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'pl','pol'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pl', 'language', 'pl', 'Polski'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pl', 'language', 'en', 'Polish'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pl', 'language', 'fr', 'Polonais'); - --- Portuguese -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'pt', 'language', 'Portuguese','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'pt','por'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pt', 'language', 'pt', 'Português'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pt', 'language', 'en', 'Portuguese'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pt', 'language', 'fr', 'Portugais'); - --- Romanian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ro', 'language', 'Romanian','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ro','rum'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ro', 'language', 'ro', 'Română'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ro', 'language', 'en', 'Romanian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ro', 'language', 'fr', 'Roumain'); - --- Russian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ru', 'language', 'Russian','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ru','rus'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ru', 'language', 'ru', 'Русский'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ru', 'language', 'en', 'Russian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ru', 'language', 'fr', 'Russe'); - --- Serbian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'sr', 'language', 'Serbian','2005-10-16' ); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'sr', 'language', 'sr', 'српски'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'sr', 'language', 'en', 'Serbian'); - --- Spanish, Castilian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'es', 'language', 'Spanish','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'es','spa'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'es', 'language', 'es', 'Español'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'es', 'language', 'en', 'Spanish'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'es', 'language', 'fr', 'Espagnol'); - --- Spanish, Catalan -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ca', 'language', 'Catalan','2013-01-12' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -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( 'ca', 'language', 'en', 'Catalan'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ca', 'language', 'fr', 'Catalan'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ca', 'language', 'ca', 'Català'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ca', 'language', 'de', 'Katalanisch'); - --- Swedish -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'sv', 'language', 'Swedish','2005-10-16' ); - -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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'sv', 'language', 'fr', 'Suédois'); - --- Tetum -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'tet', 'language', 'Tetum','2005-10-16' ); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'tet', 'language', 'tet', 'tetun'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'tet', 'language', 'en', 'Tetum'); - --- Thai -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'th', 'language', 'Thai','2005-10-16'); - -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'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'th', 'language', 'fr', 'Thaï'); - --- 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'); - - --- 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'); - --- English -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ur', 'language', 'Urdu','2005-10-16' ); - -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', 'اردو'); - --- 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'); - --- 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'); - --- 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'); - --- 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', 'Han (Simplified variant)'); - -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)'); - --- 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', 'Han (Traditional variant)'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Hant', 'script', 'en', 'Han (Traditional variant)'); - --- 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', 'Hebrew'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Hebr', 'script', 'en', 'Hebrew'); - --- 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', 'lo', 'Lao'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Laoo', 'script', 'en', 'Lao'); - --- Croatian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'hr', 'language', 'Croatian','2014-07-24' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'hr','hrv'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hr', 'language', 'hr', 'Hrvatski'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hr', 'language', 'en', 'Croatian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hr', 'language', 'fr', 'Croate'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hr', 'language', 'de', 'Kroatisch'); - - --- REGIONS --- 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'); - --- 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'); - --- 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', 'fr', 'France'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'FR', 'region', 'en', 'France'); - --- 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'); - --- 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'); - --- 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'); diff --git a/installer/data/mysql/uk-UA/mandatory/subtag_registry.txt b/installer/data/mysql/uk-UA/mandatory/subtag_registry.txt deleted file mode 100644 index 198757d..0000000 --- a/installer/data/mysql/uk-UA/mandatory/subtag_registry.txt +++ /dev/null @@ -1,4 +0,0 @@ -Підтримка інтернаціоналізації (I18N) в Koha. -Підтримка двонаправленого (BIDI) письма, арабська та іврит. -Стандартне відображення між письмом та підкодами мови. -Розширення мови. -- 2.1.0