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 <chris@bigballofwax.co.nz>
Signed-off-by: Katrin Fischer <Katrin.Fischer.83@web.de>
Works as described, tested with de-DE.
Thx!

Signed-off-by: Tomas Cohen Arazi <tomascohen@gmail.com>

diff --git a/C4/Installer.pm b/C4/Installer.pm
index 2add0e8..300697a 100644 (file)
--- 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.txt b/installer/data/mysql/de-DE/mandatory/subtag_registry.txt
deleted file mode 100644 (file)
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/en/mandatory/subtag_registry.sql b/installer/data/mysql/en/mandatory/subtag_registry.sql
deleted file mode 100755 (executable)
index 1e642c0..0000000
--- a/installer/data/mysql/en/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/es-ES/mandatory/subtag_registry.sql b/installer/data/mysql/es-ES/mandatory/subtag_registry.sql
deleted file mode 100644 (file)
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 (file)
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 (file)
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 (file)
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 (file)
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 (file)
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/de-DE/mandatory/subtag_registry.sql b/installer/data/mysql/mandatory/subtag_registry.sql
similarity index 100%
rename from installer/data/mysql/de-DE/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 (file)
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 (file)
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 (file)
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 (file)
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 (file)
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 (file)
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 (file)
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 (file)
index 198757d..0000000
--- a/installer/data/mysql/uk-UA/mandatory/subtag_registry.txt
+++ /dev/null
@@ -1,4 +0,0 @@
-Підтримка інтернаціоналізації (I18N) в Koha.
-Підтримка двонаправленого (BIDI) письма, арабська та іврит. 
-Стандартне відображення між письмом та підкодами мови. 
-Розширення мови.