@@ -, +, @@ --- 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 --- a/installer/data/mysql/atomicupdate/bug_20307.perl +++ a/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 FOREIGN KEY `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"; +} --- a/installer/data/mysql/atomicupdate/bug_20307.sql +++ a/installer/data/mysql/atomicupdate/bug_20307.sql @@ -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); --