From 482664cb804758b164161fe02df0813814fbd01b Mon Sep 17 00:00:00 2001 From: Martin Renvoize Date: Thu, 25 Apr 2019 08:15:58 +0100 Subject: [PATCH] Bug 22729: (QA follow-up) Ensure no NULL values before setting NOT NULL Signed-off-by: Martin Renvoize Signed-off-by: Nick Clemens --- .../mysql/atomicupdate/bug_21336_followup.perl | 6 ++++++ 1 files changed, 6 insertions(+), 0 deletions(-) diff --git a/installer/data/mysql/atomicupdate/bug_21336_followup.perl b/installer/data/mysql/atomicupdate/bug_21336_followup.perl index 880d832..ff26889 100644 --- a/installer/data/mysql/atomicupdate/bug_21336_followup.perl +++ b/installer/data/mysql/atomicupdate/bug_21336_followup.perl @@ -3,6 +3,9 @@ if( CheckVersion( $DBversion ) ) { if ( column_exists( 'borrowers', 'flgAnonymized' ) ) { $dbh->do(q{ + UPDATE borrowers SET flgAnonymized = 0 WHERE flgAnonymized IS NULL + }); + $dbh->do(q{ ALTER TABLE borrowers CHANGE `flgAnonymized` `anonymized` TINYINT(1) NOT NULL DEFAULT 0 }); @@ -10,6 +13,9 @@ if( CheckVersion( $DBversion ) ) { if ( column_exists( 'deletedborrowers', 'flgAnonymized' ) ) { $dbh->do(q{ + UPDATE deletedborrowers SET flgAnonymized = 0 WHERE flgAnonymized IS NULL + }); + $dbh->do(q{ ALTER TABLE deletedborrowers CHANGE `flgAnonymized` `anonymized` TINYINT(1) NOT NULL DEFAULT 0 }); -- 1.7.2.5