From 1c2e8d5614e01f9231be9097922b9854998b9134 Mon Sep 17 00:00:00 2001 From: Katrin Fischer Date: Fri, 7 Oct 2022 19:46:16 +0000 Subject: [PATCH] Bug 31715: Add German translations for language descriptions 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 Signed-off-by: Marcel de Rooy Signed-off-by: Tomas Cohen Arazi --- .../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.39.5