From da15b6777a575d68a82b52afad37cb5c83922c6c Mon Sep 17 00:00:00 2001 From: Katrin Fischer Date: Thu, 1 Feb 2018 07:42:13 +0100 Subject: [PATCH] Bug 20082: Correct description of Vietnamese language and add German translation MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Fixes the language description of Vietnamese according to the bug report and adds the German translation for the language name. To test: - Run the database update - Verify that the new descriptions Tiếng Việt shows in advanced search language pull down - Install German translations - Verify that the German translation 'Vietnamesisch' shows in the pull down when German is selected. --- .../mysql/atomicupdate/bug_20082_fix_vietnamese_description.sql | 6 ++++++ installer/data/mysql/mandatory/subtag_registry.sql | 5 ++++- 2 files changed, 10 insertions(+), 1 deletion(-) create mode 100644 installer/data/mysql/atomicupdate/bug_20082_fix_vietnamese_description.sql diff --git a/installer/data/mysql/atomicupdate/bug_20082_fix_vietnamese_description.sql b/installer/data/mysql/atomicupdate/bug_20082_fix_vietnamese_description.sql new file mode 100644 index 0000000000..046dfff922 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_20082_fix_vietnamese_description.sql @@ -0,0 +1,6 @@ +INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) + VALUES ('vi', 'language', 'de', 'Vietnamesisch'); +UPDATE language_descriptions SET description = 'Tiếng Việt' + WHERE subtag = 'vi' and type = 'language' and lang = 'vi'; + +-- print "Upgrade to $DBversion done (Bug 20082 - Update descriptions of Vietnamese language)\n"; diff --git a/installer/data/mysql/mandatory/subtag_registry.sql b/installer/data/mysql/mandatory/subtag_registry.sql index e21577affb..ebcdedcc29 100755 --- a/installer/data/mysql/mandatory/subtag_registry.sql +++ b/installer/data/mysql/mandatory/subtag_registry.sql @@ -1136,11 +1136,14 @@ INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'vi','vie'); INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'vi', 'language', 'vi', '㗂越'); +VALUES ( 'vi', 'language', 'vi', 'Tiếng Việt'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'vi', 'language', 'en', 'Vietnamese'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'vi', 'language', 'de', 'Vietnamesisch'); + -- Chinese INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'zh', 'language', 'Chinese','2005-10-16'); -- 2.14.1