Attachment 142302 Details for Bug 31715 – Bug 31715: Add German translations for language descriptions

[patch] Bug 31715: Add German translations for language descriptions

Bug-31715-Add-German-translations-for-language-des.patch (text/plain), 24.13 KB, created by Marcel de Rooy on 2022-10-21 07:56:13 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Marcel de Rooy

Created: 2022-10-21 07:56:13 UTC

Size: 24.13 KB

patch

obsolete

>From 650ac379a594fab64a0f43f0786ffa4431e57242 Mon Sep 17 00:00:00 2001
>From: Katrin Fischer <katrin.fischer.83@web.de>
>Date: Fri, 7 Oct 2022 19:46:16 +0000
>Subject: [PATCH] Bug 31715: Add German translations for language descriptions
>Content-Type: text/plain; charset=utf-8
>
>This adds the German translations for the different languages to
>subtag_registry.sql that is used by all languages during installation.
>
>* Apply patch
>* Run database update
>* Install de-DE and activate it for the OPAC
>* Go to advanced search
>* Look at the language pull down - it shows the languages in their
>  language and then translated to English
>* Switch to German - verify the German translations are used now
>  There are 2-3 cases where the translation = name, so only name is shown.
>* Drop your database, create your database
>* Run the web installer
>* Everything should complete without error and the language pull down
>  should look exactly the same and be translated
>
>Signed-off-by: David Nind <david@davidnind.com>
>
>Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
>---
> .../atomicupdate/bug_31715_de-languages.pl    |  52 ++++++++
> .../data/mysql/mandatory/subtag_registry.sql  | 116 +++++++++++++++++-
> 2 files changed, 167 insertions(+), 1 deletion(-)
> create mode 100644 installer/data/mysql/atomicupdate/bug_31715_de-languages.pl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_31715_de-languages.pl b/installer/data/mysql/atomicupdate/bug_31715_de-languages.pl
>new file mode 100644
>index 0000000000..48cf929983
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_31715_de-languages.pl
>@@ -0,0 +1,52 @@
>+use Modern::Perl;
>+
>+return {
>+    bug_number => "31715",
>+    description => "Add missing German (de) language translations",
>+    up => sub {
>+        my ($args) = @_;
>+        my ($dbh, $out) = @$args{qw(dbh out)};
>+        # Do you stuffs here
>+        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'am', 'language', 'de', 'Amharisch') });
>+        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'az', 'language', 'de', 'Aserbaidschanisch') });
>+        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'be', 'language', 'de', 'Belarussisch') });
>+        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'bn', 'language', 'de', 'Bengalisch') });
>+        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'eu', 'language', 'de', 'Baskisch') });
>+        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'fo', 'language', 'de', 'FÃ¤rÃ¶isch') });
>+        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'is', 'language', 'de', 'IslÃ¤ndisch') });
>+        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'mi', 'language', 'de', 'Maorisch') });
>+        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'mi', 'language', 'de', 'Maorisch') });
>+        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'mn', 'language', 'de', 'Mongolisch') });
>+        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'mr', 'language', 'de', 'Marathi') });
>+        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'ms', 'language', 'de', 'Malaiisch') });
>+        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'ne', 'language', 'de', 'Nepali') });
>+        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'pbr', 'language', 'de', 'Pangwa') });
>+        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'prs', 'language', 'de', 'Dari') });
>+        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'rw', 'language', 'de', 'Kinyarwanda') });
>+        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'sd', 'language', 'de', 'Sindhi') });
>+        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'sk', 'language', 'de', 'Slowakisch') });
>+        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'sl', 'language', 'de', 'Slowenisch') });
>+        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'sq', 'language', 'de', 'Albanisch') });
>+        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'sw', 'language', 'de', 'Swahili') });
>+        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'ta', 'language', 'de', 'Tamil') });
>+        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'tl', 'language', 'de', 'Tagalog') });
>+        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUEs ( 'Armn', 'script', 'de', 'Armenisch') });
>+        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUEs ( 'Ethi', 'script', 'en', 'Ãthiopisch') });
>+        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUEs ( 'Jpan', 'script', 'de', 'Japanisch') });
>+        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUEs ( 'Knda', 'script', 'de', 'Kannada') });
>+        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUEs ( 'Kore', 'script', 'de', 'Koreanisch') });
>+        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ('et', 'language', 'de', 'Estnisch') });
>+        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ('lv', 'language', 'de', 'Lettisch') });
>+        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ('lt', 'language', 'de', 'Litauisch') });
>+        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ('iu', 'language', 'de', 'Inuktitut') });
>+        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ('ik', 'language', 'de', 'Inupiaq') });
>+        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'cr', 'language', 'de', 'Cree') });
>+        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'af', 'language', 'de', 'Afrikaans') });
>+        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'mul', 'language', 'de', 'Mehrsprachig') });
>+        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'und', 'language', 'de', 'Unbestimmt') });
>+        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'zxx', 'language', 'de', 'Kein sprachlicher Inhalt') });
>+
>+        # Print useful stuff here
>+        say $out "German (de) translations were added";
>+    },
>+};
>diff --git a/installer/data/mysql/mandatory/subtag_registry.sql b/installer/data/mysql/mandatory/subtag_registry.sql
>index acbcfe7630..cfaf493583 100644
>--- a/installer/data/mysql/mandatory/subtag_registry.sql
>+++ b/installer/data/mysql/mandatory/subtag_registry.sql
>@@ -69,6 +69,9 @@ VALUES ( 'am', 'language', 'am', 'á ááá');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES ( 'am', 'language', 'en', 'Amharic');
> 
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'am', 'language', 'de', 'Amharisch');
>+
> -- Arabic
> INSERT INTO language_subtag_registry( subtag, type, description, added)
> VALUES ( 'ar', 'language', 'Arabic','2005-10-16');
>@@ -101,6 +104,9 @@ VALUES ( 'az', 'language', 'az', 'AzÉrbaycan dili');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES ( 'az', 'language', 'en', 'Azerbaijani');
> 
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'az', 'language', 'de', 'Aserbaidschanisch');
>+
> -- Byelorussian
> INSERT INTO language_subtag_registry( subtag, type, description, added)
> VALUES ( 'be', 'language', 'Byelorussian','2014-10-30');
>@@ -114,6 +120,9 @@ VALUES ( 'be', 'language', 'be', 'ÐÐµÐ»Ð°ÑÑÑÐºÐ°Ñ Ð¼Ð¾Ð²Ð°');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES ( 'be', 'language', 'en', 'Byelorussian');
> 
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'be', 'language', 'de', 'Belarussisch');
>+
> -- Bengali
> INSERT INTO language_subtag_registry( subtag, type, description, added)
> VALUES ( 'bn', 'language', 'Bengali','2014-10-30');
>@@ -127,6 +136,9 @@ VALUES ( 'bn', 'language', 'bn', 'à¦¬à¦¾à¦à¦²à¦¾');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES ( 'bn', 'language', 'en', 'Bengali');
> 
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'bn', 'language', 'de', 'Bengalisch');
>+
> -- Bulgarian
> INSERT INTO language_subtag_registry( subtag, type, description, added)
> VALUES ( 'bg', 'language', 'Bulgarian','2005-10-16');
>@@ -289,6 +301,9 @@ VALUES ( 'eu', 'language', 'eu', 'Euskera');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES ( 'eu', 'language', 'en', 'Basque');
> 
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'eu', 'language', 'de', 'Baskisch');
>+
> -- Persian
> INSERT INTO language_subtag_registry( subtag, type, description, added)
> VALUES ( 'fa', 'language', 'Persian','2005-10-16');
>@@ -337,6 +352,9 @@ VALUES ( 'fo', 'language', 'fo', 'FÃ¸royskt');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES ( 'fo', 'language', 'en', 'Faroese');
> 
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'fo', 'language', 'de', 'FÃ¤rÃ¶isch');
>+
> -- French
> INSERT INTO language_subtag_registry( subtag, type, description, added)
> VALUES ( 'fr', 'language', 'French','2005-10-16' );
>@@ -499,6 +517,9 @@ VALUES ( 'is', 'language', 'is', 'Ãslenska');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES ( 'is', 'language', 'en', 'Icelandic');
> 
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'is', 'language', 'de', 'IslÃ¤ndisch');
>+
> -- Italian
> INSERT INTO language_subtag_registry( subtag, type, description, added)
> VALUES ( 'it', 'language', 'Italian','2005-10-16' );
>@@ -585,6 +606,9 @@ VALUES ( 'km', 'language', 'km', 'áá¶áá¶ááááá');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES( 'km', 'language', 'en', 'Khmer');
> 
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'km', 'language', 'de', 'Khmer');
>+
> -- Korean
> INSERT INTO language_subtag_registry( subtag, type, description, added)
> VALUES ( 'ko', 'language', 'Korean','2005-10-16');
>@@ -643,7 +667,7 @@ 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');
>+VALUES ( 'la', 'language', 'de', 'Lateinisch');
> 
> -- Lao
> INSERT INTO language_subtag_registry( subtag, type, description, added)
>@@ -677,6 +701,9 @@ VALUES ( 'mi', 'language', 'mi', 'Te Reo MÄori');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES ( 'mi', 'language', 'en', 'Maori');
> 
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'mi', 'language', 'de', 'Maorisch');
>+
> -- Mongolian
> INSERT INTO language_subtag_registry( subtag, type, description, added)
> VALUES ( 'mn', 'language', 'Mongolian','2014-10-30');
>@@ -690,6 +717,9 @@ VALUES ( 'mn', 'language', 'mn', 'MÐ¾Ð½Ð³Ð¾Ð»');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES ( 'mn', 'language', 'en', 'Mongolian');
> 
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'mn', 'language', 'de', 'Mongolisch');
>+
> -- Marathi
> INSERT INTO language_subtag_registry( subtag, type, description, added)
> VALUES ( 'mr', 'language', 'Marathi','2014-10-30');
>@@ -703,6 +733,9 @@ VALUES ( 'mr', 'language', 'mr', 'à¤®à¤°à¤¾à¤ à¥');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES ( 'mr', 'language', 'en', 'Marathi');
> 
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'mr', 'language', 'de', 'Marathi');
>+
> -- Malay
> INSERT INTO language_subtag_registry( subtag, type, description, added)
> VALUES ( 'ms', 'language', 'Malay','2014-10-30');
>@@ -716,6 +749,9 @@ VALUES ( 'ms', 'language', 'ms', 'Bahasa melayu');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES ( 'ms', 'language', 'en', 'Malay');
> 
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'ms', 'language', 'de', 'Malaiisch');
>+
> -- Norwegian (bokmÃ¥l)
> INSERT INTO language_subtag_registry( subtag, type, description, added)
> VALUES ( 'nb', 'language', 'Norwegian bokmÃ¥l','2005-10-16' );
>@@ -748,6 +784,9 @@ VALUES ( 'ne', 'language', 'ne', 'à¤¨à¥à¤ªà¤¾à¤²à¥');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES ( 'ne', 'language', 'en', 'Nepali');
> 
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'ne', 'language', 'de', 'Nepali');
>+
> -- Dutch
> INSERT INTO language_subtag_registry( subtag, type, description, added)
> VALUES ( 'nl', 'language', 'Dutch','2005-10-16' );
>@@ -802,6 +841,9 @@ VALUES ( 'pbr', 'language', 'pbr', 'Ekipangwa');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES ( 'pbr', 'language', 'en', 'Pangwa');
> 
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'pbr', 'language', 'de', 'Pangwa');
>+
> -- Polish
> INSERT INTO language_subtag_registry( subtag, type, description, added)
> VALUES ( 'pl', 'language', 'Polish','2005-10-16' );
>@@ -834,6 +876,9 @@ VALUES ( 'prs', 'language', 'prs', 'Ø¯Ø±Ù');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES ( 'prs', 'language', 'en', 'Dari');
> 
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'prs', 'language', 'de', 'Dari');
>+
> -- Portuguese
> INSERT INTO language_subtag_registry( subtag, type, description, added)
> VALUES ( 'pt', 'language', 'Portuguese','2005-10-16' );
>@@ -904,6 +949,9 @@ VALUES ( 'rw', 'language', 'rw', 'Ikinyarwanda');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES ( 'rw', 'language', 'en', 'Kinyarwanda');
> 
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'rw', 'language', 'de', 'Kinyarwanda');
>+
> -- Sindhi
> INSERT INTO language_subtag_registry( subtag, type, description, added)
> VALUES ( 'sd', 'language', 'Sindhi','2014-10-30');
>@@ -917,6 +965,9 @@ VALUES ( 'sd', 'language', 'sd', 'Ø³ÙÚÙ');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES ( 'sd', 'language', 'en', 'Sindhi');
> 
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'sd', 'language', 'de', 'Sindhi');
>+
> -- Slovak
> INSERT INTO language_subtag_registry( subtag, type, description, added)
> VALUES ( 'sk', 'language', 'Slovak','2014-10-30');
>@@ -930,6 +981,9 @@ VALUES ( 'sk', 'language', 'sk', 'SlovenÄina');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES ( 'sk', 'language', 'en', 'Slovak');
> 
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'sk', 'language', 'de', 'Slowakisch');
>+
> -- Slovene
> INSERT INTO language_subtag_registry( subtag, type, description, added)
> VALUES ( 'sl', 'language', 'Slovene','2014-10-30');
>@@ -943,6 +997,9 @@ VALUES ( 'sl', 'language', 'sl', 'SlovenÅ¡Äina');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES ( 'sl', 'language', 'en', 'Slovene');
> 
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'sl', 'language', 'de', 'Slowenisch');
>+
> -- Albanian
> INSERT INTO language_subtag_registry( subtag, type, description, added)
> VALUES ( 'sq', 'language', 'Albanian','2014-10-30');
>@@ -956,6 +1013,9 @@ VALUES ( 'sq', 'language', 'sq', 'Shqip');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES ( 'sq', 'language', 'en', 'Albanian');
> 
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'sq', 'language', 'de', 'Albanisch');
>+
> -- Serbian
> INSERT INTO language_subtag_registry( subtag, type, description, added)
> VALUES ( 'sr', 'language', 'Serbian','2005-10-16' );
>@@ -1007,6 +1067,9 @@ VALUES ( 'sw', 'language', 'sw', 'Kiswahili');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES ( 'sw', 'language', 'en', 'Swahili');
> 
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'sw', 'language', 'de', 'Swahili');
>+
> -- Tamil
> INSERT INTO language_subtag_registry( subtag, type, description, added)
> VALUES ( 'ta', 'language', 'Tamil','2014-10-30');
>@@ -1020,6 +1083,9 @@ VALUES ( 'ta', 'language', 'ta', 'à®¤à®®à®¿à®´à¯');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES ( 'ta', 'language', 'en', 'Tamil');
> 
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'ta', 'language', 'de', 'Tamil');
>+
> -- Tetum
> INSERT INTO language_subtag_registry( subtag, type, description, added)
> VALUES ( 'tet', 'language', 'Tetum','2005-10-16' );
>@@ -1071,6 +1137,9 @@ VALUES ( 'tl', 'language', 'tl', 'Tagalog');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES ( 'tl', 'language', 'en', 'Tagalog');
> 
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'tl', 'language', 'de', 'Tagalog');
>+
> -- Turkish
> INSERT INTO language_subtag_registry( subtag, type, description, added)
> VALUES ( 'tr', 'language', 'Turkish','2005-10-16' );
>@@ -1190,6 +1259,9 @@ VALUES ( 'Armn', 'script', 'Armn', 'ÕÕ¡ÕµÕ¸Ö Õ¡ÕµÕ¢Õ¸ÖÕ¢Õ¥Õ¶');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES( 'Armn', 'script', 'en', 'Armenian');
> 
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES( 'Armn', 'script', 'de', 'Armenisch');
>+
> -- Cyrillic
> INSERT INTO language_subtag_registry( subtag, type, description, added)
> VALUES ( 'Cyrl', 'script', 'Cyrillic','2005-10-16');
>@@ -1216,6 +1288,9 @@ VALUES ( 'Ethi', 'script', 'Ethi', 'ááá');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES( 'Ethi', 'script', 'en', 'Ethiopic');
> 
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES( 'Ethi', 'script', 'de', 'Ãthiopisch');
>+
> -- Greek
> INSERT INTO language_subtag_registry( subtag, type, description, added)
> VALUES ( 'Grek', 'script', 'Greek','2005-10-16');
>@@ -1286,6 +1361,9 @@ VALUES ( 'Jpan', 'script', 'Jpan', 'æ¼¢å');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES( 'Jpan', 'script', 'en', 'Japanese');
> 
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES( 'Jpan', 'script', 'de', 'Japanisch');
>+
> -- Kannada
> INSERT INTO language_subtag_registry( subtag, type, description, added)
> VALUES ( 'Knda', 'script', 'Kannada','2014-10-30');
>@@ -1296,6 +1374,9 @@ VALUES ( 'Knda', 'script', 'Knda', 'à²à²¨à³à²¨à²¡ à²²à²¿à²ªà²¿');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES( 'Knda', 'script', 'en', 'Kannada');
> 
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES( 'Knda', 'script', 'de', 'Kannada');
>+
> -- Korean
> INSERT INTO language_subtag_registry( subtag, type, description, added)
> VALUES ( 'Kore', 'script', 'Korean','2014-10-30');
>@@ -1306,6 +1387,9 @@ VALUES ( 'Kore', 'script', 'Kore', 'íê¸');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES( 'Kore', 'script', 'en', 'Korean');
> 
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES( 'Kore', 'script', 'de', 'Koreanisch');
>+
> -- Lao
> INSERT INTO language_subtag_registry( subtag, type, description, added)
> VALUES ( 'Laoo', 'script', 'Lao','2005-10-16');
>@@ -1813,6 +1897,9 @@ VALUES ('et', 'language', 'en', 'Estonian');
> INSERT INTO language_descriptions (subtag, type, lang, description)
> VALUES ('et', 'language', 'et', 'Eesti');
> 
>+INSERT INTO language_descriptions (subtag, type, lang, description)
>+VALUES ('et', 'language', 'de', 'Estnisch');
>+
> INSERT INTO language_subtag_registry (subtag, type, description, added)
> VALUES ('et', 'language', 'Estonian', now());
> 
>@@ -1827,6 +1914,9 @@ VALUES ('lv', 'language', 'en', 'Latvian');
> INSERT INTO language_descriptions (subtag, type, lang, description)
> VALUES ('lv', 'language', 'lv', 'Latvija');
> 
>+INSERT INTO language_descriptions (subtag, type, lang, description)
>+VALUES ('lv', 'language', 'de', 'Lettisch');
>+
> INSERT INTO language_subtag_registry (subtag, type, description, added)
> VALUES ('lv', 'language', 'Latvian', now());
> 
>@@ -1841,6 +1931,9 @@ VALUES ('lt', 'language', 'en', 'Lithuanian');
> INSERT INTO language_descriptions (subtag, type, lang, description)
> VALUES ('lt', 'language', 'lt', 'LietuviÅ³');
> 
>+INSERT INTO language_descriptions (subtag, type, lang, description)
>+VALUES ('lt', 'language', 'de', 'Litauisch');
>+
> INSERT INTO language_subtag_registry (subtag, type, description, added)
> VALUES ('lt', 'language', 'Lithuanian', now());
> 
>@@ -1855,6 +1948,9 @@ VALUES ('iu', 'language', 'en', 'Inuktitut');
> INSERT INTO language_descriptions (subtag, type, lang, description)
> VALUES ('iu', 'language', 'iu', 'áááááá¦');
> 
>+INSERT INTO language_descriptions (subtag, type, lang, description)
>+VALUES ('iu', 'language', 'de', 'Inuktitut');
>+
> INSERT INTO language_subtag_registry (subtag, type, description, added)
> VALUES ('iu', 'language', 'Inuktitut', now());
> 
>@@ -1869,6 +1965,9 @@ VALUES ('ik', 'language', 'en', 'Inupiaq');
> INSERT INTO language_descriptions (subtag, type, lang, description)
> VALUES ('ik', 'language', 'ik', 'IÃ±upiaq');
> 
>+INSERT INTO language_descriptions (subtag, type, lang, description)
>+VALUES ('ik', 'language', 'de', 'Inupiaq');
>+
> INSERT INTO language_subtag_registry (subtag, type, description, added)
> VALUES ('ik', 'language', 'Inupiaq', now());
> 
>@@ -1915,6 +2014,9 @@ VALUES ( 'cr', 'language', 'en', 'Cree');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES ( 'cr', 'language', 'fr', 'Cree');
> 
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'cr', 'language', 'de', 'Cree');
>+
> -- Afrikaans
> 
> INSERT INTO language_subtag_registry( subtag, type, description, added)
>@@ -1929,6 +2031,9 @@ VALUES ( 'af', 'language', 'en', 'Afrikaans');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES ( 'af', 'language', 'fr', 'Afrikaans');
> 
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'af', 'language', 'de', 'Afrikaans');
>+
> -- Multiple languages
> 
> INSERT INTO language_subtag_registry( subtag, type, description, added)
>@@ -1943,6 +2048,9 @@ VALUES ( 'mul', 'language', 'en', 'Multiple languages');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES ( 'mul', 'language', 'fr', 'Multilingue');
> 
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'mul', 'language', 'de', 'Mehrsprachig');
>+
> -- Undetermined
> 
> INSERT INTO language_subtag_registry( subtag, type, description, added)
>@@ -1957,6 +2065,9 @@ VALUES ( 'und', 'language', 'en', 'Undetermined');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES ( 'und', 'language', 'fr', 'IndÃ©terminÃ©e');
> 
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'und', 'language', 'de', 'Unbestimmt');
>+
> -- No linguistic content
> 
> INSERT INTO language_subtag_registry( subtag, type, description, added)
>@@ -1970,3 +2081,6 @@ VALUES ( 'zxx', 'language', 'en', 'No linguistic content');
> 
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES ( 'zxx', 'language', 'fr', 'Pas de contenu linguistique');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'zxx', 'language', 'de', 'Kein sprachlicher Inhalt');
>-- 
>2.30.2

Actions: View | Diff | Splinter Review

Attachments on bug 31715: 141524 | 141525 | 141940 | 142302