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

(-)a/installer/data/mysql/atomicupdate/bug_4078.perl (+9 lines)
Line 0 Link Here
1
$DBversion = 'XXX';  # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
    if( !column_exists( 'currency', 'p_sep_by_space' ) ) {
4
        $dbh->do( "ALTER TABLE currency ADD COLUMN p_sep_by_space tinyint(1) default 0 after archived" );
5
    }
6
7
    SetVersion( $DBversion );
8
    print "Upgrade to $DBversion done (Bug 4078: Add column currency.p_sep_by_space)\n";
9
}
(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 458-463 CREATE TABLE `currency` ( Link Here
458
  `rate` float(15,5) default NULL,
458
  `rate` float(15,5) default NULL,
459
  `active` tinyint(1) default NULL,
459
  `active` tinyint(1) default NULL,
460
  `archived` tinyint(1) DEFAULT 0,
460
  `archived` tinyint(1) DEFAULT 0,
461
  `p_sep_by_space` tinyint(1) DEFAULT 0,
461
  PRIMARY KEY  (`currency`)
462
  PRIMARY KEY  (`currency`)
462
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
463
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
463
464
464
- 

Return to bug 4078