@@ -, +, @@ --- installer/data/mysql/atomicupdate/bug-23673.perl | 12 ++++++++++++ installer/data/mysql/kohastructure.sql | 3 ++- 2 files changed, 14 insertions(+), 1 deletion(-) create mode 100644 installer/data/mysql/atomicupdate/bug-23673.perl --- a/installer/data/mysql/atomicupdate/bug-23673.perl +++ a/installer/data/mysql/atomicupdate/bug-23673.perl @@ -0,0 +1,12 @@ +$DBversion = 'XXX'; # will be replaced by the RM +if( CheckVersion( $DBversion ) ) { + + $dbh->do("ALTER TABLE message_queue MODIFY time_queued timestamp NULL"); + + if( !column_exists( 'message_queue', 'updated_on' ) ) { + $dbh->do("ALTER TABLE message_queue ADD COLUMN updated_on timestamp NOT NULL default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER time_queued"); + } + + SetVersion( $DBversion ); + print "Upgrade to $DBversion done (Bug 23673 - modify time_queued and add updated_on to message_queue)\n"; +} --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -2387,7 +2387,8 @@ CREATE TABLE `message_queue` ( `letter_code` varchar(64) DEFAULT NULL, `message_transport_type` varchar(20) NOT NULL, `status` enum('sent','pending','failed','deleted') NOT NULL default 'pending', - `time_queued` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, + `time_queued` timestamp NULL, + `updated_on` timestamp NOT NULL default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `to_address` LONGTEXT, `from_address` LONGTEXT, `content_type` MEDIUMTEXT, --