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

(-)a/installer/data/mysql/atomicupdate/bug_20352.perl (+13 lines)
Line 0 Link Here
1
$DBversion = 'XXX'; # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
    if( !column_exists( 'currency', 'p_cs_precedes' ) ) {
4
        $dbh->do(q|
5
            ALTER TABLE currency
6
            ADD COLUMN p_cs_precedes tinyint(1) DEFAULT 1
7
            AFTER p_sep_by_space
8
        |);
9
    }
10
11
    SetVersion( $DBversion );
12
    print "Upgrade to $DBversion done (Bug 20352 - Add column currency.p_cs_precedes)\n";
13
}
(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 432-437 CREATE TABLE `currency` ( Link Here
432
  `active` tinyint(1) default NULL,
432
  `active` tinyint(1) default NULL,
433
  `archived` tinyint(1) DEFAULT 0,
433
  `archived` tinyint(1) DEFAULT 0,
434
  `p_sep_by_space` tinyint(1) DEFAULT 0,
434
  `p_sep_by_space` tinyint(1) DEFAULT 0,
435
  `p_cs_precedes` tinyint(1) DEFAULT 1,
435
  PRIMARY KEY  (`currency`)
436
  PRIMARY KEY  (`currency`)
436
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
437
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
437
438
438
- 

Return to bug 20352