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 NULL");
5
6
    if( !column_exists( 'message_queue', 'updated_on' ) ) {
7
        $dbh->do("ALTER TABLE message_queue ADD COLUMN updated_on timestamp NOT NULL default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER time_queued");
8
    }
9
10
    SetVersion( $DBversion );
11
    print "Upgrade to $DBversion done (Bug 23673 - modify time_queued and add updated_on to message_queue)\n";
12
}
(-)a/installer/data/mysql/kohastructure.sql (-2 / +2 lines)
Lines 2387-2393 CREATE TABLE `message_queue` ( Link Here
2387
  `letter_code` varchar(64) DEFAULT NULL,
2387
  `letter_code` varchar(64) DEFAULT NULL,
2388
  `message_transport_type` varchar(20) NOT NULL,
2388
  `message_transport_type` varchar(20) NOT NULL,
2389
  `status` enum('sent','pending','failed','deleted') NOT NULL default 'pending',
2389
  `status` enum('sent','pending','failed','deleted') NOT NULL default 'pending',
2390
  `time_queued` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
2390
  `time_queued` timestamp NULL,
2391
  `updated_on` timestamp NOT NULL default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
2391
  `to_address` LONGTEXT,
2392
  `to_address` LONGTEXT,
2392
  `from_address` LONGTEXT,
2393
  `from_address` LONGTEXT,
2393
  `content_type` MEDIUMTEXT,
2394
  `content_type` MEDIUMTEXT,
2394
- 

Return to bug 23673