https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21336
--- Comment #97 from Martin Renvoize <[email protected]> --- 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. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
