View | Details | Raw Unified | Return to bug 20307
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_20307.perl (+11 lines)
Line 0 Link Here
1
$DBversion = 'XXX';    # will be replaced by the RM
2
if ( CheckVersion($DBversion) ) {
3
    if ( !column_exists( 'localization', 'interface' ) ) {
4
        $dbh->do("ALTER TABLE `localization` ADD COLUMN `interface` VARCHAR(30) DEFAULT NULL AFTER `entity`");
5
        $dbh->do("ALTER TABLE `localization` DROP CONSTRAINT `entity_code_lang`");
6
        $dbh->do("ALTER TABLE `localization` ADD UNIQUE KEY `entity_code_interface_lang` (entity, code, interface, lang)");
7
    }
8
9
    SetVersion($DBversion);
10
    print "Upgrade to $DBversion done (Bug 20307 - Update localization table with interface)\n";
11
}
(-)a/installer/data/mysql/atomicupdate/bug_20307.sql (-4 lines)
Lines 1-3 Link Here
1
alter table localization add column interface varchar(30) default null after entity;
2
alter table localization drop constraint entity_code_lang;
3
alter table localization add unique key entity_code_interface_lang (entity, code, interface, lang);
4
- 

Return to bug 20307