https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21336 --- Comment #97 from Martin Renvoize <martin.renvoize@ptfs-europe.com> --- Comment on attachment 87176 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=87176 Bug 21336: Database revision for borrowers.flgAnonymized Review of attachment 87176: --> (https://bugs.koha-community.org/bugzilla3/page.cgi?id=splinter.html&bug=21336&attachment=87176) ----------------------------------------------------------------- ::: installer/data/mysql/atomicupdate/bug_21336a.perl @@ +1,3 @@
+$DBversion = 'XXX'; # will be replaced by the RM +if( CheckVersion( $DBversion ) ) { + $dbh->do( "ALTER TABLE borrowers ADD COLUMN flgAnonymized tinyint DEFAULT 0" );
Sorry chaps.. we need the if column exists adding here to make it idempotent. @@ +1,4 @@
+$DBversion = 'XXX'; # will be replaced by the RM +if( CheckVersion( $DBversion ) ) { + $dbh->do( "ALTER TABLE borrowers ADD COLUMN flgAnonymized tinyint DEFAULT 0" ); + $dbh->do( "ALTER TABLE deletedborrowers ADD COLUMN flgAnonymized tinyint DEFAULT 0" );
and here... -- You are receiving this mail because: You are watching all bug changes.