From 1f9bddb71305e5e02eb6d077b1033b68050e5eaf 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 Content-Type: text/plain; charset=utf-8 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. --- 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 076c3b5..ee882dd 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; -- 1.7.10.4