From 14cc4a3499319591c2fc658dacb1d3c1f4e73523 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Tue, 24 Apr 2018 12:04:29 -0300 Subject: [PATCH] Bug 20482: DBRev 17.12.00.039 Signed-off-by: Jonathan Druart --- .../bug_20482_update_language_codes.sql | 3 --- installer/data/mysql/updatedatabase.pl | 17 +++++++++++++++++ 2 files changed, 17 insertions(+), 3 deletions(-) delete mode 100644 installer/data/mysql/atomicupdate/bug_20482_update_language_codes.sql diff --git a/installer/data/mysql/atomicupdate/bug_20482_update_language_codes.sql b/installer/data/mysql/atomicupdate/bug_20482_update_language_codes.sql deleted file mode 100644 index ae7d1aa1e8..0000000000 --- a/installer/data/mysql/atomicupdate/bug_20482_update_language_codes.sql +++ /dev/null @@ -1,3 +0,0 @@ -UPDATE language_rfc4646_to_iso639 SET iso639_2_code = 'baq' WHERE iso639_2_code = 'eus' AND rfc4646_subtag = 'eu'; -UPDATE language_rfc4646_to_iso639 SET iso639_2_code = 'mao' WHERE iso639_2_code = 'mri' AND rfc4646_subtag = 'mi'; -UPDATE language_rfc4646_to_iso639 SET iso639_2_code = 'alb' WHERE iso639_2_code = 'sqi' AND rfc4646_subtag = 'sq'; diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index e5b50acfa4..cc569b31b4 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -15952,6 +15952,23 @@ if( CheckVersion( $DBversion ) ) { print "Upgrade to $DBversion done (Bug 20245 - Use Bibliographic code value for Slovak language)\n"; } +$DBversion = '17.12.00.039'; +if( CheckVersion( $DBversion ) ) { + + $dbh->do( q{ + UPDATE language_rfc4646_to_iso639 SET iso639_2_code = 'baq' WHERE iso639_2_code = 'eus' AND rfc4646_subtag = 'eu'; + } ); + $dbh->do( q{ + UPDATE language_rfc4646_to_iso639 SET iso639_2_code = 'mao' WHERE iso639_2_code = 'mri' AND rfc4646_subtag = 'mi'; + } ); + $dbh->do( q{ + UPDATE language_rfc4646_to_iso639 SET iso639_2_code = 'alb' WHERE iso639_2_code = 'sqi' AND rfc4646_subtag = 'sq'; + } ); + + SetVersion( $DBversion ); + print "Upgrade to $DBversion done (Bug 20482 - Use Bibliographic code value for Basque, Maori and Albanian languages)\n"; +} + # SEE bug 13068 # if there is anything in the atomicupdate, read and execute it. -- 2.39.5