From b97f1fab52281a71cd72b33bd61f453ed1bb5337 Mon Sep 17 00:00:00 2001 From: Martin Renvoize Date: Fri, 10 May 2019 10:13:36 +0100 Subject: [PATCH] Bug 20307: (QA follow-up) Move DB update to perl --- installer/data/mysql/atomicupdate/bug_20307.perl | 11 +++++++++++ installer/data/mysql/atomicupdate/bug_20307.sql | 3 --- 2 files changed, 11 insertions(+), 3 deletions(-) create mode 100644 installer/data/mysql/atomicupdate/bug_20307.perl delete mode 100644 installer/data/mysql/atomicupdate/bug_20307.sql diff --git a/installer/data/mysql/atomicupdate/bug_20307.perl b/installer/data/mysql/atomicupdate/bug_20307.perl new file mode 100644 index 0000000000..4f96e1a0d5 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_20307.perl @@ -0,0 +1,11 @@ +$DBversion = 'XXX'; # will be replaced by the RM +if ( CheckVersion($DBversion) ) { + if ( !column_exists( 'localization', 'interface' ) ) { + $dbh->do("ALTER TABLE `localization` ADD COLUMN `interface` VARCHAR(30) DEFAULT NULL AFTER `entity`"); + $dbh->do("ALTER TABLE `localization` DROP CONSTRAINT `entity_code_lang`"); + $dbh->do("ALTER TABLE `localization` ADD UNIQUE KEY `entity_code_interface_lang` (entity, code, interface, lang)"); + } + + SetVersion($DBversion); + print "Upgrade to $DBversion done (Bug 20307 - Update localization table with interface)\n"; +} diff --git a/installer/data/mysql/atomicupdate/bug_20307.sql b/installer/data/mysql/atomicupdate/bug_20307.sql deleted file mode 100644 index 05ad215edf..0000000000 --- a/installer/data/mysql/atomicupdate/bug_20307.sql +++ /dev/null @@ -1,3 +0,0 @@ -alter table localization add column interface varchar(30) default null after entity; -alter table localization drop constraint entity_code_lang; -alter table localization add unique key entity_code_interface_lang (entity, code, interface, lang); -- 2.20.1