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

(-)a/installer/data/mysql/atomicupdate/bug_24818.perl (+8 lines)
Line 0 Link Here
1
$DBversion = 'XXX'; # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
4
    $dbh->do( "ALTER TABLE accountlines MODIFY COLUMN date TIMESTAMP NULL" );
5
6
    SetVersion( $DBversion );
7
    print "Upgrade to $DBversion done (Bug 24818: Update 'accountlines.date' from DATE to TIMESTAMP)\n";
8
}
(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 2650-2656 CREATE TABLE `accountlines` ( Link Here
2650
  `issue_id` int(11) NULL DEFAULT NULL,
2650
  `issue_id` int(11) NULL DEFAULT NULL,
2651
  `borrowernumber` int(11) DEFAULT NULL,
2651
  `borrowernumber` int(11) DEFAULT NULL,
2652
  `itemnumber` int(11) default NULL,
2652
  `itemnumber` int(11) default NULL,
2653
  `date` date default NULL,
2653
  `date` timestamp NULL,
2654
  `amount` decimal(28,6) default NULL,
2654
  `amount` decimal(28,6) default NULL,
2655
  `description` LONGTEXT,
2655
  `description` LONGTEXT,
2656
  `credit_type_code` varchar(80) default NULL,
2656
  `credit_type_code` varchar(80) default NULL,
2657
- 

Return to bug 24818