[Koha-bugs] [Bug 21336] GDPR: Handle unsubscribe requests automatically by optional (administrative) lock, anonymize and remove

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21336

--- Comment #97 from Martin Renvoize <martin.renvoize at 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.