From 8386f5f5e828565457ea4421773b0d0fe5168483 Mon Sep 17 00:00:00 2001 From: Joy Nelson Date: Wed, 1 Apr 2020 20:52:41 +0000 Subject: [PATCH] Bug 22273: DBRev 19.11.04.002 Signed-off-by: Joy Nelson --- installer/data/mysql/updatedatabase.pl | 4 +--- 1 file changed, 1 insertion(+), 3 deletions(-) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 4ff898dfbf..911e4ad130 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -20463,9 +20463,7 @@ if( CheckVersion( $DBversion ) ) { $DBversion = '19.11.04.002'; if( CheckVersion( $DBversion ) ) { $dbh->do( q| - ALTER TABLE article_requests - MODIFY COLUMN created_on timestamp NULL, - MODIFY COLUMN updated_on timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() + ALTER TABLE article_requests MODIFY COLUMN created_on timestamp NULL, MODIFY COLUMN updated_on timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() |); SetVersion( $DBversion ); print "Upgrade to $DBversion done (Bug 22273: Column article_requests.created_on should not be updated)\n"; -- 2.20.1