From a46c4d8a89a7f68db2047b3f2e4fe294b2a9d0d1 Mon Sep 17 00:00:00 2001
From: Marc Veron <veron@veron.ch>
Date: Sun, 11 Nov 2012 22:00:19 +0100
Subject: [PATCH] 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 <Katrin.Fischer.83@web.de>
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&ccedil;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&ccedil;ais');
 
@@ -214,6 +244,12 @@ VALUES( 'lo', 'language', 'lo', '&#3742;&#3762;&#3754;&#3762;&#3749;&#3762;&#375
 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&#229;l','2005-10-16' );
@@ -407,6 +473,9 @@ VALUES( 'nb', 'language', 'en', 'Norwegian bokm&#229;l');
 INSERT INTO language_descriptions(subtag, type, lang, description)
 VALUES( 'nb', 'language', 'fr', 'Norvégien bokm&#229;l');
 
+INSERT INTO language_descriptions(subtag, type, lang, description)
+VALUES( 'nb', 'language', 'de', 'Norwegisch bokm&#229;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', '&#1089;&#1088;&#1087;&#1089;&#1082;&#1080;');
 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', '&#1575;&#1585;&#1583;&#1608;');
 
+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 676bb3e..cdc276a 100755
--- a/installer/data/mysql/updatedatabase.pl
+++ b/installer/data/mysql/updatedatabase.pl
@@ -6131,6 +6131,53 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
         UPDATE virtualshelves SET sortfield="copyrightdate" where sortfield="year";
     });
     print "Upgrade to $DBversion done (Bug 9167: Update the virtualshelves.sortfield column with 'copyrightdate' if needed)\n";
+    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&#229;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);
 }
 
-- 
1.7.9.5