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

(-)a/installer/data/mysql/atomicupdate/bug_24640.perl (+7 lines)
Line 0 Link Here
1
$DBversion = 'XXX'; # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
    $dbh->do( "ALTER TABLE quotes MODIFY timestamp datetime NULL" );
4
5
    SetVersion( $DBversion );
6
    print "Upgrade to $DBversion done (Bug 24640 - Allow quotes.timestamp to be NULL)\n";
7
}
(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 3314-3320 CREATE TABLE `quotes` ( -- data for the quote of the day feature Link Here
3314
  `id` int(11) NOT NULL AUTO_INCREMENT, -- unique id for the quote
3314
  `id` int(11) NOT NULL AUTO_INCREMENT, -- unique id for the quote
3315
  `source` MEDIUMTEXT DEFAULT NULL, -- source/credit for the quote
3315
  `source` MEDIUMTEXT DEFAULT NULL, -- source/credit for the quote
3316
  `text` LONGTEXT NOT NULL, -- text of the quote
3316
  `text` LONGTEXT NOT NULL, -- text of the quote
3317
  `timestamp` datetime NOT NULL, -- date and time that the quote last appeared in the opac
3317
  `timestamp` datetime NULL, -- date and time that the quote last appeared in the opac
3318
  PRIMARY KEY (`id`)
3318
  PRIMARY KEY (`id`)
3319
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3319
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3320
3320
3321
- 

Return to bug 24640