From a893bad8079e744ee655c443f9f7e2e28aa90087 Mon Sep 17 00:00:00 2001 From: Bernardo Gonzalez Kriegel Date: Sat, 16 Feb 2013 12:43:31 -0300 Subject: [PATCH] Followup 2 - Bug 9381 - Add Catalan language Sorry, this followup fulfills K. Fischer request to base de-DE file in english one. The differences are small corrections and added languages. Signed-off-by: Chris Cormack Rebased to master --- .../data/mysql/de-DE/mandatory/subtag_registry.sql | 149 ++++++++++++++++++-- .../data/mysql/en/mandatory/subtag_registry.sql | 3 + 2 files changed, 143 insertions(+), 9 deletions(-) diff --git a/installer/data/mysql/de-DE/mandatory/subtag_registry.sql b/installer/data/mysql/de-DE/mandatory/subtag_registry.sql index f494bab..9663c5c 100644 --- a/installer/data/mysql/de-DE/mandatory/subtag_registry.sql +++ b/installer/data/mysql/de-DE/mandatory/subtag_registry.sql @@ -63,12 +63,15 @@ 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', 'Հայերէն'); @@ -79,6 +82,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 +101,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 +120,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 +139,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 +158,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 +177,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 +193,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 +225,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 +235,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 +244,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 +282,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 (Nach 1453)'); + -- Hebrew INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'he', 'language', 'Hebrew','2005-10-16'); @@ -259,6 +301,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 +320,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 +339,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,12 +358,15 @@ VALUES( 'id', 'language', 'en', 'Indonesian'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'id', 'language', 'fr', 'Indonésien'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'id', 'language', 'de', 'Indonesisch'); + -- Italian INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'it', 'language', 'Italian','2005-10-16' ); INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'it','ind'); +VALUES( 'it','ita'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'it', 'language', 'it', 'Italiano'); @@ -323,6 +377,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 +396,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 +415,9 @@ VALUES( 'ko', 'language', 'en', 'Korean'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'ko', 'language', 'fr', 'Coréen'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ko', 'language', 'de', 'Koreanisch'); + -- Latin INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'la', 'language', 'Latin','2005-10-16' ); @@ -371,7 +434,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 +451,9 @@ 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'); + -- Norwegian (bokmål) INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'nb', 'language', 'Norwegian bokmål','2005-10-16' ); @@ -404,6 +473,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 +495,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 +514,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 +533,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 +552,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 +571,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 +590,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 +628,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 +669,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 +707,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 +726,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 +745,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) diff --git a/installer/data/mysql/en/mandatory/subtag_registry.sql b/installer/data/mysql/en/mandatory/subtag_registry.sql index b9cbd3c..9663c5c 100755 --- a/installer/data/mysql/en/mandatory/subtag_registry.sql +++ b/installer/data/mysql/en/mandatory/subtag_registry.sql @@ -650,6 +650,9 @@ VALUES( 'ca', 'language', 'fr', 'Catalan'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'ca', 'language', 'ca', 'Català'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ca', 'language', 'de', 'Katalanisch'); + -- Swedish INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sv', 'language', 'Swedish','2005-10-16' ); -- 1.7.9.5