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

(-)a/installer/data/mysql/atomicupdate/bug-23673.perl (+12 lines)
Line 0 Link Here
1
$DBversion = 'XXX'; # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
4
    $dbh->do("ALTER TABLE message_queue MODIFY time_queued timestamp NOT NULL default CURRENT_TIMESTAMP");
5
6
    if( !column_exists( 'message_queue', 'time_status_changed' ) ) {
7
        $dbh->do("ALTER TABLE message_queue ADD COLUMN time_status_changed timestamp NULL AFTER time_queued");
8
    }
9
10
    SetVersion( $DBversion );
11
    print "Upgrade to $DBversion done (Bug 23673 - modify time_queued and add time_status_changed to message_queue)\n";
12
}
(-)a/installer/data/mysql/kohastructure.sql (-2 / +2 lines)
Lines 2426-2432 CREATE TABLE `message_queue` ( Link Here
2426
  `letter_code` varchar(64) DEFAULT NULL,
2426
  `letter_code` varchar(64) DEFAULT NULL,
2427
  `message_transport_type` varchar(20) NOT NULL,
2427
  `message_transport_type` varchar(20) NOT NULL,
2428
  `status` enum('sent','pending','failed','deleted') NOT NULL default 'pending',
2428
  `status` enum('sent','pending','failed','deleted') NOT NULL default 'pending',
2429
  `time_queued` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
2429
  `time_queued` timestamp NOT NULL default CURRENT_TIMESTAMP,
2430
  `time_status_changed` timestamp NULL,
2430
  `to_address` LONGTEXT,
2431
  `to_address` LONGTEXT,
2431
  `from_address` LONGTEXT,
2432
  `from_address` LONGTEXT,
2432
  `content_type` MEDIUMTEXT,
2433
  `content_type` MEDIUMTEXT,
2433
- 

Return to bug 23673