From aef1bf950a0f7febc76db9c37040a515c8b7d58a Mon Sep 17 00:00:00 2001 From: Bernardo Gonzalez Kriegel Date: Tue, 13 May 2014 17:19:39 -0300 Subject: [PATCH] Bug 12250 - Add Kurdish Language This patch adds Kurdish language As a side effect, it put in sync with english all language versions of subtag_registry.sql To test: 1. Apply the patch 2. Run updatedatabase.pl 2.b Test loading new subtag_registry.sql run on database: delete from language_descriptions; delete from language_rfc4646_to_iso639; delete from language_script_bidi; delete from language_script_mapping; delete from language_subtag_registry; load subtag_registry.sql 3. Update/Install ku-Arab cd misc/translator perl translate update ku-Arab perl translate install ku-Arab 4. Go to Sysprefs > I18N, check correct Kurdish description 5. Enable kurdish on opac/staff, enable opaclanguagesdisplay 6. Reload staff, change to Kurdish, check correct RTL display 7. Reload opac, change to Kurdish, chech correct RTL display Note: As Kurdish has two descriptions based on script type, I added both because can't select description based only on language code 'ku' --- .../data/mysql/de-DE/mandatory/subtag_registry.sql | 24 +- .../data/mysql/en/mandatory/subtag_registry.sql | 24 +- .../data/mysql/es-ES/mandatory/subtag_registry.sql | 183 +++++++++++- .../mysql/fr-FR/1-Obligatoire/subtag_registry.sql | 299 +++++++++++++++++++- .../data/mysql/it-IT/necessari/subtag_registry.sql | 215 +++++++++++++- .../mysql/nb-NO/1-Obligatorisk/subtag_registry.sql | 204 +++++++++++-- .../data/mysql/pl-PL/mandatory/subtag_registry.sql | 219 +++++++++++++- .../data/mysql/ru-RU/mandatory/subtag_registry.sql | 211 +++++++++++++- .../data/mysql/uk-UA/mandatory/subtag_registry.sql | 211 +++++++++++++- installer/data/mysql/updatedatabase.pl | 13 + ...06000.po => ku-Arab-i-opac-t-prog-v-3006000.po} | 0 ...6000.po => ku-Arab-i-staff-t-prog-v-3006000.po} | 0 ...opac-bootstrap.po => ku-Arab-opac-bootstrap.po} | 0 .../po/{ku-opac-ccsr.po => ku-Arab-opac-ccsr.po} | 0 misc/translator/po/{ku-pref.po => ku-Arab-pref.po} | 0 .../po/{ku-staff-help.po => ku-Arab-staff-help.po} | 0 16 files changed, 1523 insertions(+), 80 deletions(-) rename misc/translator/po/{ku-i-opac-t-prog-v-3006000.po => ku-Arab-i-opac-t-prog-v-3006000.po} (100%) rename misc/translator/po/{ku-i-staff-t-prog-v-3006000.po => ku-Arab-i-staff-t-prog-v-3006000.po} (100%) rename misc/translator/po/{ku-opac-bootstrap.po => ku-Arab-opac-bootstrap.po} (100%) rename misc/translator/po/{ku-opac-ccsr.po => ku-Arab-opac-ccsr.po} (100%) rename misc/translator/po/{ku-pref.po => ku-Arab-pref.po} (100%) rename misc/translator/po/{ku-staff-help.po => ku-Arab-staff-help.po} (100%) diff --git a/installer/data/mysql/de-DE/mandatory/subtag_registry.sql b/installer/data/mysql/de-DE/mandatory/subtag_registry.sql index b91aba9..43bb9b4 100644 --- a/installer/data/mysql/de-DE/mandatory/subtag_registry.sql +++ b/installer/data/mysql/de-DE/mandatory/subtag_registry.sql @@ -83,7 +83,7 @@ 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', 'Հայերէն'); +VALUES ( 'hy', 'language', 'hy', 'Հայերեն'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'hy', 'language', 'en', 'Armenian'); @@ -427,6 +427,28 @@ VALUES( 'ko', 'language', 'fr', 'Coréen'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'ko', 'language', 'de', 'Koreanisch'); +-- Kurdish +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'ku', 'language', 'Kurdish','2014-05-13'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'ku','kur'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ku', 'language', 'ku', 'کوردی, Kurdí'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ku', 'language', 'en', 'Kurdish'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ku', 'language', 'fr', 'Kurde'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ku', 'language', 'de', 'Kurdisch'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ku', 'language', 'es', 'Kurdo'); + -- Latin INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'la', 'language', 'Latin','2005-10-16' ); diff --git a/installer/data/mysql/en/mandatory/subtag_registry.sql b/installer/data/mysql/en/mandatory/subtag_registry.sql index 64bcc1b..a27d5fc 100755 --- a/installer/data/mysql/en/mandatory/subtag_registry.sql +++ b/installer/data/mysql/en/mandatory/subtag_registry.sql @@ -36,7 +36,7 @@ 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', '????'); +VALUES( 'intranet', 'i', 'fr', 'Français'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'intranet', 'i', 'de', 'Dienstoberfläche'); @@ -427,6 +427,28 @@ VALUES( 'ko', 'language', 'fr', 'Coréen'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'ko', 'language', 'de', 'Koreanisch'); +-- Kurdish +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'ku', 'language', 'Kurdish','2014-05-13'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'ku','kur'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ku', 'language', 'ku', 'کوردی, Kurdí'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ku', 'language', 'en', 'Kurdish'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ku', 'language', 'fr', 'Kurde'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ku', 'language', 'de', 'Kurdisch'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ku', 'language', 'es', 'Kurdo'); + -- Latin INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'la', 'language', 'Latin','2005-10-16' ); diff --git a/installer/data/mysql/es-ES/mandatory/subtag_registry.sql b/installer/data/mysql/es-ES/mandatory/subtag_registry.sql index 49ad7ab..a27d5fc 100644 --- a/installer/data/mysql/es-ES/mandatory/subtag_registry.sql +++ b/installer/data/mysql/es-ES/mandatory/subtag_registry.sql @@ -25,6 +25,9 @@ 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'); @@ -33,7 +36,10 @@ 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', '????'); +VALUES( 'intranet', 'i', 'fr', 'Français'); + +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) @@ -45,6 +51,9 @@ 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 @@ -63,6 +72,9 @@ 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'); @@ -71,7 +83,7 @@ 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', 'Հայերէն'); +VALUES ( 'hy', 'language', 'hy', 'Հայերեն'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'hy', 'language', 'en', 'Armenian'); @@ -79,6 +91,9 @@ 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'); @@ -95,6 +110,9 @@ 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'); @@ -111,6 +129,9 @@ 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' ); @@ -127,6 +148,9 @@ 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' ); @@ -143,6 +167,9 @@ 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' ); @@ -159,6 +186,9 @@ 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' ); @@ -172,6 +202,9 @@ 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' ); @@ -185,6 +218,9 @@ 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' ); @@ -198,6 +234,9 @@ 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'); @@ -214,6 +253,12 @@ 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' ); @@ -246,6 +291,9 @@ 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'); @@ -262,6 +310,9 @@ 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'); @@ -278,6 +329,9 @@ 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' ); @@ -294,6 +348,9 @@ 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' ); @@ -310,6 +367,9 @@ 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' ); @@ -326,6 +386,9 @@ 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'); @@ -342,6 +405,9 @@ 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'); @@ -358,6 +424,31 @@ 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'); + +-- Kurdish +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'ku', 'language', 'Kurdish','2014-05-13'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'ku','kur'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ku', 'language', 'ku', 'کوردی, Kurdí'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ku', 'language', 'en', 'Kurdish'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ku', 'language', 'fr', 'Kurde'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ku', 'language', 'de', 'Kurdisch'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ku', 'language', 'es', 'Kurdo'); + -- Latin INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'la', 'language', 'Latin','2005-10-16' ); @@ -374,6 +465,9 @@ 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) @@ -388,6 +482,13 @@ 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' ); @@ -407,6 +508,9 @@ 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' ); @@ -426,6 +530,9 @@ 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'); @@ -442,6 +549,9 @@ 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' ); @@ -458,6 +568,9 @@ 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' ); @@ -474,6 +587,9 @@ 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' ); @@ -490,6 +606,9 @@ 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'); @@ -506,6 +625,9 @@ 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' ); @@ -519,6 +641,12 @@ 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' ); @@ -535,6 +663,9 @@ 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' ); @@ -573,6 +704,9 @@ 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' ); @@ -586,6 +720,12 @@ 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'); @@ -602,6 +742,9 @@ 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' ); @@ -618,6 +761,8 @@ 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) @@ -635,6 +780,9 @@ 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' ); @@ -648,6 +796,12 @@ 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) @@ -662,6 +816,9 @@ 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'); @@ -675,6 +832,10 @@ 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'); @@ -688,6 +849,10 @@ 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'); @@ -701,6 +866,10 @@ 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'); @@ -711,6 +880,9 @@ 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'); @@ -721,6 +893,9 @@ 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'); @@ -731,6 +906,10 @@ 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', 'en', 'Laotisch'); + + -- REGIONS -- Canada INSERT INTO language_subtag_registry( subtag, type, description, added) diff --git a/installer/data/mysql/fr-FR/1-Obligatoire/subtag_registry.sql b/installer/data/mysql/fr-FR/1-Obligatoire/subtag_registry.sql index 59db6bb..a27d5fc 100644 --- a/installer/data/mysql/fr-FR/1-Obligatoire/subtag_registry.sql +++ b/installer/data/mysql/fr-FR/1-Obligatoire/subtag_registry.sql @@ -25,6 +25,9 @@ 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'); @@ -35,15 +38,21 @@ VALUES( 'intranet', 'i', 'en', 'Staff Client'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'intranet', 'i', 'fr', 'Français'); +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', 'United Kingdom','2005-10-16'); +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', 'i', 'en', 'Prog'); +VALUES( 'prog', 't', 'fr', 'Prog'); INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'prog', 'i', 'fr', 'Prog'); +VALUES( 'prog', 't', 'de', 'Prog'); -- LANGUAGES @@ -63,6 +72,28 @@ 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'); @@ -79,6 +110,9 @@ 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'); @@ -95,6 +129,9 @@ 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' ); @@ -111,6 +148,9 @@ 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' ); @@ -127,6 +167,9 @@ 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' ); @@ -143,12 +186,15 @@ 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','en'); +VALUES( 'en','eng'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'en', 'language', 'en', 'English'); @@ -156,12 +202,31 @@ 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','fr'); +VALUES( 'fr','fre'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'fr', 'language', 'en', 'French'); @@ -169,9 +234,31 @@ 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' ); @@ -204,6 +291,9 @@ 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'); @@ -220,6 +310,9 @@ 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'); @@ -236,6 +329,9 @@ 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' ); @@ -252,6 +348,9 @@ 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' ); @@ -268,6 +367,9 @@ 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' ); @@ -284,6 +386,9 @@ 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'); @@ -300,6 +405,9 @@ 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'); @@ -316,6 +424,31 @@ 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'); + +-- Kurdish +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'ku', 'language', 'Kurdish','2014-05-13'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'ku','kur'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ku', 'language', 'ku', 'کوردی, Kurdí'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ku', 'language', 'en', 'Kurdish'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ku', 'language', 'fr', 'Kurde'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ku', 'language', 'de', 'Kurdisch'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ku', 'language', 'es', 'Kurdo'); + -- Latin INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'la', 'language', 'Latin','2005-10-16' ); @@ -332,6 +465,30 @@ 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' ); @@ -351,6 +508,9 @@ 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' ); @@ -370,6 +530,9 @@ 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'); @@ -386,6 +549,9 @@ 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' ); @@ -402,6 +568,9 @@ 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' ); @@ -418,6 +587,9 @@ 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' ); @@ -434,6 +606,9 @@ 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'); @@ -450,6 +625,28 @@ 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' ); @@ -466,6 +663,9 @@ 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' ); @@ -504,6 +704,28 @@ 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'); @@ -520,6 +742,9 @@ 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' ); @@ -536,6 +761,8 @@ 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) @@ -553,7 +780,27 @@ 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 @@ -569,6 +816,9 @@ 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'); @@ -582,6 +832,10 @@ 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'); @@ -595,6 +849,10 @@ 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'); @@ -608,6 +866,10 @@ 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'); @@ -618,6 +880,9 @@ 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'); @@ -628,6 +893,23 @@ 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', 'en', 'Laotisch'); + + -- REGIONS -- Canada INSERT INTO language_subtag_registry( subtag, type, description, added) @@ -636,6 +918,13 @@ 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'); diff --git a/installer/data/mysql/it-IT/necessari/subtag_registry.sql b/installer/data/mysql/it-IT/necessari/subtag_registry.sql index 43e5a14..a27d5fc 100644 --- a/installer/data/mysql/it-IT/necessari/subtag_registry.sql +++ b/installer/data/mysql/it-IT/necessari/subtag_registry.sql @@ -1,5 +1,3 @@ -SET FOREIGN_KEY_CHECKS=0; - -- http://www.w3.org/International/articles/language-tags/ -- BIDI Stuff, Arabic and Hebrew @@ -27,6 +25,9 @@ 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'); @@ -35,7 +36,10 @@ 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', '????'); +VALUES( 'intranet', 'i', 'fr', 'Français'); + +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) @@ -47,6 +51,9 @@ 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 @@ -65,15 +72,18 @@ 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','hy'); +VALUES( 'hy','arm'); INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'hy', 'language', 'hy', 'Հայերէն'); +VALUES ( 'hy', 'language', 'hy', 'Հայերեն'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'hy', 'language', 'en', 'Armenian'); @@ -81,6 +91,9 @@ 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'); @@ -97,6 +110,9 @@ 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'); @@ -113,6 +129,9 @@ 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' ); @@ -129,6 +148,9 @@ 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' ); @@ -145,6 +167,9 @@ 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' ); @@ -161,12 +186,15 @@ 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','en'); +VALUES( 'en','eng'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'en', 'language', 'en', 'English'); @@ -174,22 +202,31 @@ VALUES( 'en', 'language', 'en', 'English'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'en', 'language', 'fr', 'Anglais'); --- English +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','fr'); +VALUES( 'fr','fre'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'fr', 'language', 'en', 'French'); @@ -197,6 +234,9 @@ 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'); @@ -204,8 +244,8 @@ VALUES( 'fr', 'language', 'fr', 'Français'); 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_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'lo','lao'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'lo', 'language', 'lo', 'ພາສາລາວ'); @@ -213,6 +253,12 @@ 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' ); @@ -245,6 +291,9 @@ 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'); @@ -261,6 +310,9 @@ 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'); @@ -277,6 +329,9 @@ 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' ); @@ -293,6 +348,9 @@ 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' ); @@ -309,6 +367,9 @@ 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' ); @@ -325,6 +386,9 @@ 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'); @@ -341,6 +405,9 @@ 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'); @@ -357,6 +424,31 @@ 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'); + +-- Kurdish +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'ku', 'language', 'Kurdish','2014-05-13'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'ku','kur'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ku', 'language', 'ku', 'کوردی, Kurdí'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ku', 'language', 'en', 'Kurdish'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ku', 'language', 'fr', 'Kurde'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ku', 'language', 'de', 'Kurdisch'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ku', 'language', 'es', 'Kurdo'); + -- Latin INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'la', 'language', 'Latin','2005-10-16' ); @@ -373,7 +465,10 @@ VALUES( 'la', 'language', 'en', 'Latin'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'la', 'language', 'fr', 'Latin'); --- Galacian +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' ); @@ -387,6 +482,13 @@ 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' ); @@ -406,6 +508,9 @@ 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' ); @@ -425,6 +530,9 @@ 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'); @@ -441,6 +549,9 @@ 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' ); @@ -457,6 +568,9 @@ 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' ); @@ -473,6 +587,9 @@ 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' ); @@ -489,6 +606,9 @@ 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'); @@ -505,16 +625,28 @@ 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' ); @@ -531,6 +663,9 @@ 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' ); @@ -569,16 +704,28 @@ 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'); @@ -595,6 +742,9 @@ 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' ); @@ -611,6 +761,8 @@ 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) @@ -628,16 +780,28 @@ VALUES( 'uk', 'language', 'en', 'Ukranian'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'uk', 'language', 'fr', 'Ukrainien'); --- English +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) @@ -652,6 +816,9 @@ 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'); @@ -665,6 +832,10 @@ 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'); @@ -678,6 +849,10 @@ 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'); @@ -691,6 +866,10 @@ 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'); @@ -701,6 +880,9 @@ 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'); @@ -711,6 +893,9 @@ 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'); @@ -721,6 +906,10 @@ 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', 'en', 'Laotisch'); + + -- REGIONS -- Canada INSERT INTO language_subtag_registry( subtag, type, description, added) @@ -766,5 +955,3 @@ 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/nb-NO/1-Obligatorisk/subtag_registry.sql b/installer/data/mysql/nb-NO/1-Obligatorisk/subtag_registry.sql index f4d5409..a27d5fc 100644 --- a/installer/data/mysql/nb-NO/1-Obligatorisk/subtag_registry.sql +++ b/installer/data/mysql/nb-NO/1-Obligatorisk/subtag_registry.sql @@ -1,24 +1,3 @@ --- --- 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 @@ -46,6 +25,9 @@ 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'); @@ -54,7 +36,10 @@ 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', '????'); +VALUES( 'intranet', 'i', 'fr', 'Français'); + +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) @@ -66,6 +51,9 @@ 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 @@ -84,6 +72,9 @@ 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'); @@ -92,7 +83,7 @@ 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', 'Հայերէն'); +VALUES ( 'hy', 'language', 'hy', 'Հայերեն'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'hy', 'language', 'en', 'Armenian'); @@ -100,6 +91,9 @@ 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'); @@ -116,6 +110,9 @@ 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'); @@ -132,6 +129,9 @@ 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' ); @@ -148,6 +148,9 @@ 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' ); @@ -164,6 +167,9 @@ 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' ); @@ -180,6 +186,9 @@ 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' ); @@ -193,6 +202,9 @@ 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' ); @@ -206,6 +218,9 @@ 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' ); @@ -219,6 +234,9 @@ 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'); @@ -235,6 +253,12 @@ 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' ); @@ -267,6 +291,9 @@ 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'); @@ -283,6 +310,9 @@ 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'); @@ -299,6 +329,9 @@ 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' ); @@ -315,6 +348,9 @@ 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' ); @@ -331,6 +367,9 @@ 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' ); @@ -347,6 +386,9 @@ 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'); @@ -363,6 +405,9 @@ 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'); @@ -379,6 +424,31 @@ 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'); + +-- Kurdish +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'ku', 'language', 'Kurdish','2014-05-13'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'ku','kur'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ku', 'language', 'ku', 'کوردی, Kurdí'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ku', 'language', 'en', 'Kurdish'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ku', 'language', 'fr', 'Kurde'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ku', 'language', 'de', 'Kurdisch'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ku', 'language', 'es', 'Kurdo'); + -- Latin INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'la', 'language', 'Latin','2005-10-16' ); @@ -395,6 +465,9 @@ 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) @@ -409,6 +482,13 @@ 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' ); @@ -428,6 +508,9 @@ 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' ); @@ -447,6 +530,9 @@ 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'); @@ -463,6 +549,9 @@ 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' ); @@ -479,6 +568,9 @@ 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' ); @@ -495,6 +587,9 @@ 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' ); @@ -511,6 +606,9 @@ 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'); @@ -527,6 +625,9 @@ 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' ); @@ -540,6 +641,12 @@ 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' ); @@ -556,6 +663,9 @@ 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' ); @@ -594,6 +704,9 @@ 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' ); @@ -607,6 +720,12 @@ 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'); @@ -623,6 +742,9 @@ 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' ); @@ -639,6 +761,8 @@ 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) @@ -656,6 +780,9 @@ 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' ); @@ -669,6 +796,12 @@ 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) @@ -683,6 +816,9 @@ 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'); @@ -696,6 +832,10 @@ 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'); @@ -709,6 +849,10 @@ 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'); @@ -722,6 +866,10 @@ 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'); @@ -732,6 +880,9 @@ 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'); @@ -742,6 +893,9 @@ 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'); @@ -752,6 +906,10 @@ 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', 'en', 'Laotisch'); + + -- REGIONS -- Canada INSERT INTO language_subtag_registry( subtag, type, description, added) diff --git a/installer/data/mysql/pl-PL/mandatory/subtag_registry.sql b/installer/data/mysql/pl-PL/mandatory/subtag_registry.sql index 09561a9..a27d5fc 100644 --- a/installer/data/mysql/pl-PL/mandatory/subtag_registry.sql +++ b/installer/data/mysql/pl-PL/mandatory/subtag_registry.sql @@ -25,6 +25,9 @@ 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'); @@ -33,7 +36,10 @@ 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', '????'); +VALUES( 'intranet', 'i', 'fr', 'Français'); + +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) @@ -45,6 +51,9 @@ 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 @@ -63,15 +72,18 @@ 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','hy'); +VALUES( 'hy','arm'); INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'hy', 'language', 'hy', 'Հայերէն'); +VALUES ( 'hy', 'language', 'hy', 'Հայերեն'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'hy', 'language', 'en', 'Armenian'); @@ -79,6 +91,9 @@ 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'); @@ -95,6 +110,9 @@ 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'); @@ -111,6 +129,9 @@ 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' ); @@ -127,6 +148,9 @@ 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' ); @@ -143,6 +167,9 @@ 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' ); @@ -159,12 +186,15 @@ 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','en'); +VALUES( 'en','eng'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'en', 'language', 'en', 'English'); @@ -172,22 +202,31 @@ VALUES( 'en', 'language', 'en', 'English'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'en', 'language', 'fr', 'Anglais'); --- English +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','fr'); +VALUES( 'fr','fre'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'fr', 'language', 'en', 'French'); @@ -195,6 +234,9 @@ 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'); @@ -202,8 +244,8 @@ VALUES( 'fr', 'language', 'fr', 'Français'); 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_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'lo','lao'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'lo', 'language', 'lo', 'ພາສາລາວ'); @@ -211,6 +253,12 @@ 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' ); @@ -243,6 +291,9 @@ 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'); @@ -259,6 +310,9 @@ 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'); @@ -275,6 +329,9 @@ 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' ); @@ -291,6 +348,9 @@ 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' ); @@ -307,6 +367,9 @@ 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' ); @@ -323,6 +386,9 @@ 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'); @@ -339,6 +405,9 @@ 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'); @@ -355,6 +424,31 @@ 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'); + +-- Kurdish +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'ku', 'language', 'Kurdish','2014-05-13'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'ku','kur'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ku', 'language', 'ku', 'کوردی, Kurdí'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ku', 'language', 'en', 'Kurdish'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ku', 'language', 'fr', 'Kurde'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ku', 'language', 'de', 'Kurdisch'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ku', 'language', 'es', 'Kurdo'); + -- Latin INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'la', 'language', 'Latin','2005-10-16' ); @@ -371,7 +465,10 @@ VALUES( 'la', 'language', 'en', 'Latin'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'la', 'language', 'fr', 'Latin'); --- Galacian +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' ); @@ -385,6 +482,13 @@ 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' ); @@ -404,6 +508,9 @@ 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' ); @@ -423,6 +530,9 @@ 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'); @@ -439,6 +549,9 @@ 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' ); @@ -455,12 +568,15 @@ 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','pol'); +VALUES( 'pt','por'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'pt', 'language', 'pt', 'Português'); @@ -471,6 +587,9 @@ 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' ); @@ -487,6 +606,9 @@ 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'); @@ -503,16 +625,28 @@ 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' ); @@ -529,6 +663,9 @@ 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' ); @@ -562,21 +699,33 @@ INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'sv', 'language', 'sv', 'Svenska'); INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'sv', 'language', 'en', 'Swedish'); +VALUES( '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'); @@ -588,11 +737,14 @@ INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'th', 'language', 'th', 'ภาษาไทย'); INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'th', 'language', 'en', 'Thai'); +VALUES( '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' ); @@ -604,11 +756,13 @@ 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'); +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) @@ -626,16 +780,28 @@ VALUES( 'uk', 'language', 'en', 'Ukranian'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'uk', 'language', 'fr', 'Ukrainien'); --- English +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) @@ -650,6 +816,9 @@ 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'); @@ -663,6 +832,10 @@ 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'); @@ -676,6 +849,10 @@ 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'); @@ -689,6 +866,10 @@ 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'); @@ -699,6 +880,9 @@ 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'); @@ -709,6 +893,9 @@ 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'); @@ -719,6 +906,10 @@ 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', 'en', 'Laotisch'); + + -- REGIONS -- Canada INSERT INTO language_subtag_registry( subtag, type, description, added) diff --git a/installer/data/mysql/ru-RU/mandatory/subtag_registry.sql b/installer/data/mysql/ru-RU/mandatory/subtag_registry.sql index 3403d0f..a27d5fc 100644 --- a/installer/data/mysql/ru-RU/mandatory/subtag_registry.sql +++ b/installer/data/mysql/ru-RU/mandatory/subtag_registry.sql @@ -25,6 +25,9 @@ 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'); @@ -33,7 +36,10 @@ 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', '????'); +VALUES( 'intranet', 'i', 'fr', 'Français'); + +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) @@ -45,6 +51,9 @@ 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 @@ -63,15 +72,18 @@ 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','hy'); +VALUES( 'hy','arm'); INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'hy', 'language', 'hy', 'Հայերէն'); +VALUES ( 'hy', 'language', 'hy', 'Հայերեն'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'hy', 'language', 'en', 'Armenian'); @@ -79,6 +91,9 @@ 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'); @@ -95,6 +110,9 @@ 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'); @@ -111,6 +129,9 @@ 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' ); @@ -127,6 +148,9 @@ 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' ); @@ -143,6 +167,9 @@ 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' ); @@ -159,12 +186,15 @@ 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','en'); +VALUES( 'en','eng'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'en', 'language', 'en', 'English'); @@ -172,22 +202,31 @@ VALUES( 'en', 'language', 'en', 'English'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'en', 'language', 'fr', 'Anglais'); --- English +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','fr'); +VALUES( 'fr','fre'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'fr', 'language', 'en', 'French'); @@ -195,6 +234,9 @@ 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'); @@ -202,8 +244,8 @@ VALUES( 'fr', 'language', 'fr', 'Français'); 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_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'lo','lao'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'lo', 'language', 'lo', 'ພາສາລາວ'); @@ -211,6 +253,12 @@ 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' ); @@ -243,6 +291,9 @@ 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'); @@ -259,6 +310,9 @@ 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'); @@ -275,6 +329,9 @@ 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' ); @@ -291,6 +348,9 @@ 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' ); @@ -307,6 +367,9 @@ 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' ); @@ -323,6 +386,9 @@ 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'); @@ -339,6 +405,9 @@ 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'); @@ -355,6 +424,31 @@ 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'); + +-- Kurdish +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'ku', 'language', 'Kurdish','2014-05-13'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'ku','kur'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ku', 'language', 'ku', 'کوردی, Kurdí'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ku', 'language', 'en', 'Kurdish'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ku', 'language', 'fr', 'Kurde'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ku', 'language', 'de', 'Kurdisch'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ku', 'language', 'es', 'Kurdo'); + -- Latin INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'la', 'language', 'Latin','2005-10-16' ); @@ -371,7 +465,10 @@ VALUES( 'la', 'language', 'en', 'Latin'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'la', 'language', 'fr', 'Latin'); --- Galacian +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' ); @@ -385,6 +482,13 @@ 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' ); @@ -404,6 +508,9 @@ 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' ); @@ -423,6 +530,9 @@ 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'); @@ -439,6 +549,9 @@ 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' ); @@ -455,6 +568,9 @@ 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' ); @@ -471,6 +587,9 @@ 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' ); @@ -487,6 +606,9 @@ 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'); @@ -503,16 +625,28 @@ 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' ); @@ -529,6 +663,9 @@ 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' ); @@ -567,16 +704,28 @@ 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'); @@ -593,6 +742,9 @@ 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' ); @@ -609,6 +761,8 @@ 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) @@ -626,16 +780,28 @@ VALUES( 'uk', 'language', 'en', 'Ukranian'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'uk', 'language', 'fr', 'Ukrainien'); --- English +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) @@ -650,6 +816,9 @@ 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'); @@ -663,6 +832,10 @@ 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'); @@ -676,6 +849,10 @@ 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'); @@ -689,6 +866,10 @@ 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'); @@ -699,6 +880,9 @@ 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'); @@ -709,6 +893,9 @@ 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'); @@ -719,6 +906,10 @@ 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', 'en', 'Laotisch'); + + -- REGIONS -- Canada INSERT INTO language_subtag_registry( subtag, type, description, added) diff --git a/installer/data/mysql/uk-UA/mandatory/subtag_registry.sql b/installer/data/mysql/uk-UA/mandatory/subtag_registry.sql index 3403d0f..a27d5fc 100644 --- a/installer/data/mysql/uk-UA/mandatory/subtag_registry.sql +++ b/installer/data/mysql/uk-UA/mandatory/subtag_registry.sql @@ -25,6 +25,9 @@ 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'); @@ -33,7 +36,10 @@ 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', '????'); +VALUES( 'intranet', 'i', 'fr', 'Français'); + +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) @@ -45,6 +51,9 @@ 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 @@ -63,15 +72,18 @@ 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','hy'); +VALUES( 'hy','arm'); INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'hy', 'language', 'hy', 'Հայերէն'); +VALUES ( 'hy', 'language', 'hy', 'Հայերեն'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'hy', 'language', 'en', 'Armenian'); @@ -79,6 +91,9 @@ 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'); @@ -95,6 +110,9 @@ 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'); @@ -111,6 +129,9 @@ 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' ); @@ -127,6 +148,9 @@ 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' ); @@ -143,6 +167,9 @@ 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' ); @@ -159,12 +186,15 @@ 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','en'); +VALUES( 'en','eng'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'en', 'language', 'en', 'English'); @@ -172,22 +202,31 @@ VALUES( 'en', 'language', 'en', 'English'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'en', 'language', 'fr', 'Anglais'); --- English +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','fr'); +VALUES( 'fr','fre'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'fr', 'language', 'en', 'French'); @@ -195,6 +234,9 @@ 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'); @@ -202,8 +244,8 @@ VALUES( 'fr', 'language', 'fr', 'Français'); 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_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'lo','lao'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'lo', 'language', 'lo', 'ພາສາລາວ'); @@ -211,6 +253,12 @@ 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' ); @@ -243,6 +291,9 @@ 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'); @@ -259,6 +310,9 @@ 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'); @@ -275,6 +329,9 @@ 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' ); @@ -291,6 +348,9 @@ 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' ); @@ -307,6 +367,9 @@ 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' ); @@ -323,6 +386,9 @@ 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'); @@ -339,6 +405,9 @@ 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'); @@ -355,6 +424,31 @@ 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'); + +-- Kurdish +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'ku', 'language', 'Kurdish','2014-05-13'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'ku','kur'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ku', 'language', 'ku', 'کوردی, Kurdí'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ku', 'language', 'en', 'Kurdish'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ku', 'language', 'fr', 'Kurde'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ku', 'language', 'de', 'Kurdisch'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ku', 'language', 'es', 'Kurdo'); + -- Latin INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'la', 'language', 'Latin','2005-10-16' ); @@ -371,7 +465,10 @@ VALUES( 'la', 'language', 'en', 'Latin'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'la', 'language', 'fr', 'Latin'); --- Galacian +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' ); @@ -385,6 +482,13 @@ 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' ); @@ -404,6 +508,9 @@ 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' ); @@ -423,6 +530,9 @@ 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'); @@ -439,6 +549,9 @@ 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' ); @@ -455,6 +568,9 @@ 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' ); @@ -471,6 +587,9 @@ 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' ); @@ -487,6 +606,9 @@ 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'); @@ -503,16 +625,28 @@ 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' ); @@ -529,6 +663,9 @@ 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' ); @@ -567,16 +704,28 @@ 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'); @@ -593,6 +742,9 @@ 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' ); @@ -609,6 +761,8 @@ 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) @@ -626,16 +780,28 @@ VALUES( 'uk', 'language', 'en', 'Ukranian'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'uk', 'language', 'fr', 'Ukrainien'); --- English +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) @@ -650,6 +816,9 @@ 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'); @@ -663,6 +832,10 @@ 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'); @@ -676,6 +849,10 @@ 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'); @@ -689,6 +866,10 @@ 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'); @@ -699,6 +880,9 @@ 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'); @@ -709,6 +893,9 @@ 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'); @@ -719,6 +906,10 @@ 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', 'en', 'Laotisch'); + + -- REGIONS -- Canada INSERT INTO language_subtag_registry( subtag, type, description, added) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 3b1718c..34a68ce 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -8465,6 +8465,19 @@ if ( CheckVersion($DBversion) ) { SetVersion($DBversion); } +$DBversion = "3.15.00.XXX"; +if ( CheckVersion($DBversion) ) { + $dbh->do("INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'ku', 'language', 'Kurdish','2014-05-13')"); + $dbh->do("INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES( 'ku','kur')"); + $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES( 'ku', 'language', 'ku', 'کﻭﺭﺩی, Kurdí')"); + $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES( 'ku', 'language', 'en', 'Kurdish')"); + $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES( 'ku', 'language', 'fr', 'Kurde')"); + $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES( 'ku', 'language', 'de', 'Kurdisch')"); + $dbh->do("INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES( 'ku', 'language', 'es', 'Kurdo')"); + print "Upgrade to $DBversion done (Bug 12250: Add Kurdish language)\n"; + SetVersion($DBversion); +} + =head1 FUNCTIONS =head2 TableExists($table) diff --git a/misc/translator/po/ku-i-opac-t-prog-v-3006000.po b/misc/translator/po/ku-Arab-i-opac-t-prog-v-3006000.po similarity index 100% rename from misc/translator/po/ku-i-opac-t-prog-v-3006000.po rename to misc/translator/po/ku-Arab-i-opac-t-prog-v-3006000.po diff --git a/misc/translator/po/ku-i-staff-t-prog-v-3006000.po b/misc/translator/po/ku-Arab-i-staff-t-prog-v-3006000.po similarity index 100% rename from misc/translator/po/ku-i-staff-t-prog-v-3006000.po rename to misc/translator/po/ku-Arab-i-staff-t-prog-v-3006000.po diff --git a/misc/translator/po/ku-opac-bootstrap.po b/misc/translator/po/ku-Arab-opac-bootstrap.po similarity index 100% rename from misc/translator/po/ku-opac-bootstrap.po rename to misc/translator/po/ku-Arab-opac-bootstrap.po diff --git a/misc/translator/po/ku-opac-ccsr.po b/misc/translator/po/ku-Arab-opac-ccsr.po similarity index 100% rename from misc/translator/po/ku-opac-ccsr.po rename to misc/translator/po/ku-Arab-opac-ccsr.po diff --git a/misc/translator/po/ku-pref.po b/misc/translator/po/ku-Arab-pref.po similarity index 100% rename from misc/translator/po/ku-pref.po rename to misc/translator/po/ku-Arab-pref.po diff --git a/misc/translator/po/ku-staff-help.po b/misc/translator/po/ku-Arab-staff-help.po similarity index 100% rename from misc/translator/po/ku-staff-help.po rename to misc/translator/po/ku-Arab-staff-help.po -- 1.7.9.5