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 2636-2642 CREATE TABLE `accountlines` ( Link Here
2636
  `issue_id` int(11) NULL DEFAULT NULL,
2636
  `issue_id` int(11) NULL DEFAULT NULL,
2637
  `borrowernumber` int(11) DEFAULT NULL,
2637
  `borrowernumber` int(11) DEFAULT NULL,
2638
  `itemnumber` int(11) default NULL,
2638
  `itemnumber` int(11) default NULL,
2639
  `date` date default NULL,
2639
  `date` timestamp NULL,
2640
  `amount` decimal(28,6) default NULL,
2640
  `amount` decimal(28,6) default NULL,
2641
  `description` LONGTEXT,
2641
  `description` LONGTEXT,
2642
  `credit_type_code` varchar(80) default NULL,
2642
  `credit_type_code` varchar(80) default NULL,
2643
- 

Return to bug 24818