From ba39c6f8520ea5cec5b4567dcdb372d59cd62b2d Mon Sep 17 00:00:00 2001 From: Marc Veron Date: Sun, 11 Nov 2012 22:00:19 +0100 Subject: [PATCH] [SIGNED-OFF] Bug 9056 - Add more translations to table language_descriptions In table language_descriptions a lot of translations are missing (with the exception of French) Additions need to be added to subtag_registry.sql (for new installs) and to updatedatabase.pl (for upgrading). This Bug could be used as 'omnibus' for follow ups for other languages. This patch adds German (and some missing French) translations. Tested updatedatabase.pl Would appreciate if somebody could test subtag_registry.sql. Signed-off-by: Katrin Fischer Tested both, the updatedatabase and the sql file. Works well. --- .../data/mysql/en/mandatory/subtag_registry.sql | 119 ++++++++++++++++++++ installer/data/mysql/updatedatabase.pl | 47 ++++++++ 2 files changed, 166 insertions(+) mode change 100644 => 100755 installer/data/mysql/en/mandatory/subtag_registry.sql diff --git a/installer/data/mysql/en/mandatory/subtag_registry.sql b/installer/data/mysql/en/mandatory/subtag_registry.sql old mode 100644 new mode 100755 index 90a3bed..dac8b29 --- a/installer/data/mysql/en/mandatory/subtag_registry.sql +++ b/installer/data/mysql/en/mandatory/subtag_registry.sql @@ -63,6 +63,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'); @@ -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,6 +177,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 +193,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 +209,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 +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'); @@ -214,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' ); @@ -246,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'); @@ -262,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'); @@ -278,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' ); @@ -294,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' ); @@ -310,6 +358,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 +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'); @@ -342,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'); @@ -358,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' ); @@ -374,6 +434,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 +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' ); @@ -407,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' ); @@ -426,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'); @@ -442,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' ); @@ -458,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' ); @@ -474,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' ); @@ -490,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'); @@ -506,6 +590,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 +606,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 +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'); + -- Swedish INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sv', 'language', 'Swedish','2005-10-16' ); @@ -551,6 +647,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' ); @@ -564,6 +663,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'); @@ -580,6 +685,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' ); @@ -596,6 +704,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) @@ -613,6 +723,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' ); @@ -626,6 +739,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) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 518f23a..b2d5d2d 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -6055,6 +6055,53 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { SetVersion ($DBversion); } +$DBversion = "XXX"; +if (C4::Context->preference("Version") < TransformToNum($DBversion)) { + print "Upgrade to $DBversion done (Bug 9056: add German and a couple of French translations to language_descriptions"; + $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'ar', 'language', 'de', 'Arabisch')"); + $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'hy', 'language', 'de', 'Armenisch')"); + $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'bg', 'language', 'de', 'Bulgarisch')"); + $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'zh', 'language', 'de', 'Chinesisch')"); + $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'cs', 'language', 'de', 'Tschechisch')"); + $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'da', 'language', 'de', 'Dänisch')"); + $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'nl', 'language', 'de', 'Niederländisch')"); + $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'en', 'language', 'de', 'Englisch')"); + $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'fi', 'language', 'de', 'Finnisch')"); + $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'fr', 'language', 'de', 'Französisch')"); + $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'lo', 'language', 'fr', 'Laotien')"); + $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'lo', 'language', 'de', 'Laotisch')"); + $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'el', 'language', 'de', 'Griechisch (Nach 1453)')"); + $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'he', 'language', 'de', 'Hebräisch')"); + $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'hi', 'language', 'de', 'Hindi')"); + $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'hu', 'language', 'de', 'Ungarisch')"); + $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'id', 'language', 'de', 'Indonesisch')"); + $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'it', 'language', 'de', 'Italienisch')"); + $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'ja', 'language', 'de', 'Japanisch')"); + $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'ko', 'language', 'de', 'Koreanisch')"); + $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'la', 'language', 'de', 'Latein')"); + $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'gl', 'language', 'fr', 'Galicien')"); + $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'gl', 'language', 'de', 'Galizisch')"); + $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'nb', 'language', 'de', 'Norwegisch bokmål')"); + $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'nn', 'language', 'de', 'Norwegisch nynorsk')"); + $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'fa', 'language', 'de', 'Persisch')"); + $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'pl', 'language', 'de', 'Polnisch')"); + $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'pt', 'language', 'de', 'Portugiesisch')"); + $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'ro', 'language', 'de', 'Rumänisch')"); + $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'ru', 'language', 'de', 'Russisch')"); + $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'sr', 'language', 'fr', 'Serbe')"); + $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'sr', 'language', 'de', 'Serbisch')"); + $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'es', 'language', 'de', 'Spanisch')"); + $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'sv', 'language', 'de', 'Schwedisch')"); + $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'tet', 'language', 'fr', 'Tétoum')"); + $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'tet', 'language', 'de', 'Tetum')"); + $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'th', 'language', 'de', 'Thailändisch')"); + $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'tr', 'language', 'de', 'Türkisch')"); + $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'uk', 'language', 'de', 'Ukrainisch')"); + $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'ur', 'language', 'fr', 'Ourdou')"); + $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'ur', 'language', 'de', 'Urdu')"); + SetVersion ($DBversion); +} + =head1 FUNCTIONS =head2 TableExists($table) -- 1.7.9.5