From 875da6e8a8dd054088c554704013cb4afebfb879 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Wed, 5 Feb 2020 09:47:47 +0100 Subject: [PATCH] Bug 23673: Set updated_on=time_queued on DB update Signed-off-by: Jonathan Druart --- installer/data/mysql/atomicupdate/bug-23673.perl | 1 + 1 file changed, 1 insertion(+) diff --git a/installer/data/mysql/atomicupdate/bug-23673.perl b/installer/data/mysql/atomicupdate/bug-23673.perl index 64c52ef5d9..faa5a88e8d 100644 --- a/installer/data/mysql/atomicupdate/bug-23673.perl +++ b/installer/data/mysql/atomicupdate/bug-23673.perl @@ -5,6 +5,7 @@ if( CheckVersion( $DBversion ) ) { 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"); + $dbh->do("UPDATE message_queue SET updated_on=time_queued"); } SetVersion( $DBversion ); -- 2.11.0