@@ -, +, @@ setting NOT NULL --- installer/data/mysql/atomicupdate/bug_21336_followup.perl | 6 ++++++ 1 file changed, 6 insertions(+) --- a/installer/data/mysql/atomicupdate/bug_21336_followup.perl +++ a/installer/data/mysql/atomicupdate/bug_21336_followup.perl @@ -2,6 +2,9 @@ $DBversion = 'XXX'; 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 @@ -9,6 +12,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 --