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 488-493 CREATE TABLE `currency` ( Link Here
488
  `rate` float(15,5) default NULL,
488
  `rate` float(15,5) default NULL,
489
  `active` tinyint(1) default NULL,
489
  `active` tinyint(1) default NULL,
490
  `archived` tinyint(1) DEFAULT 0,
490
  `archived` tinyint(1) DEFAULT 0,
491
  `p_sep_by_space` tinyint(1) DEFAULT 0,
491
  PRIMARY KEY  (`currency`)
492
  PRIMARY KEY  (`currency`)
492
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
493
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
493
494
494
- 

Return to bug 4078