From ac59bed98ac980efaa789fa46fad1225c12bc7ce Mon Sep 17 00:00:00 2001 From: Marcel de Rooy Date: Fri, 29 Jul 2016 08:16:47 +0200 Subject: [PATCH] Bug 15839: [QA Follow-up] Update existing rows in dbrev Adding the default is fine for new records; we also should take care of the pending existing ones. Trivial addition to atomic update file. Signed-off-by: Marcel de Rooy Tested the dbrev again with existing unapproved reviews. Signed-off-by: Kyle M Hall --- installer/data/mysql/atomicupdate/bug_review.sql | 1 + 1 file changed, 1 insertion(+) diff --git a/installer/data/mysql/atomicupdate/bug_review.sql b/installer/data/mysql/atomicupdate/bug_review.sql index 076c3b51d2..ee882dd4cd 100644 --- a/installer/data/mysql/atomicupdate/bug_review.sql +++ b/installer/data/mysql/atomicupdate/bug_review.sql @@ -1 +1,2 @@ ALTER TABLE reviews CHANGE COLUMN approved approved tinyint(4) DEFAULT 0; +UPDATE reviews SET approved=0 WHERE approved IS NULL; -- 2.39.2