Attachment 83202 Details for Bug 21336 – Bug 21336: Database revision for borrowers.flgAnonymized

[patch] Bug 21336: Database revision for borrowers.flgAnonymized

Bug-21336-Database-revision-for-borrowersflgAnonym.patch (text/plain), 2.53 KB, created by Marcel de Rooy on 2018-12-14 08:56:23 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Marcel de Rooy

Created: 2018-12-14 08:56:23 UTC

Size: 2.53 KB

patch

obsolete

>From fe34fdfb7d2e02facfb2b5a7c7e52cf97b03de41 Mon Sep 17 00:00:00 2001
>From: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
>Date: Wed, 19 Sep 2018 16:56:16 +0200
>Subject: [PATCH] Bug 21336: Database revision for borrowers.flgAnonymized
>Content-Type: text/plain; charset=utf-8
>
>This new flag should speak for itself ;)
>
>Test plan:
>Run installer or updatedatabase.
>
>Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
>---
> installer/data/mysql/atomicupdate/bug_21336a.perl | 7 +++++++
> installer/data/mysql/kohastructure.sql            | 2 ++
> 2 files changed, 9 insertions(+)
> create mode 100644 installer/data/mysql/atomicupdate/bug_21336a.perl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_21336a.perl b/installer/data/mysql/atomicupdate/bug_21336a.perl
>new file mode 100644
>index 0000000..2ac9f76
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_21336a.perl
>@@ -0,0 +1,7 @@
>+$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" );
>+    SetVersion( $DBversion );
>+    print "Upgrade to $DBversion done (Bug 21336 - Add field flgAnonymized)\n";
>+}
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index c3c9570..fb4f7df 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -642,6 +642,7 @@ CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower
>   `lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron
>   `login_attempts` int(4) default 0, -- number of failed login attemps
>   `overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token
>+  `flgAnonymized` tinyint DEFAULT 0, -- flag for data anonymization
>   KEY borrowernumber (borrowernumber),
>   KEY `cardnumber` (`cardnumber`),
>   KEY `sms_provider_id` (`sms_provider_id`)
>@@ -1675,6 +1676,7 @@ CREATE TABLE `borrowers` ( -- this table includes information about your patrons
>   `lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron
>   `login_attempts` int(4) default 0, -- number of failed login attemps
>   `overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token
>+  `flgAnonymized` tinyint DEFAULT 0, -- flag for data anonymization
>   UNIQUE KEY `cardnumber` (`cardnumber`),
>   PRIMARY KEY `borrowernumber` (`borrowernumber`),
>   KEY `categorycode` (`categorycode`),
>-- 
>2.1.4

Actions: View | Diff | Splinter Review

Attachments on bug 21336: 79165 | 79166 | 79167 | 79168 | 79169 | 79170 | 80201 | 80202 | 80203 | 80204 | 80205 | 80206 | 80207 | 80208 | 80213 | 80214 | 80386 | 80387 | 80403 | 81112 | 81113 | 81114 | 81115 | 81116 | 81117 | 81118 | 81119 | 81270 | 81474 | 81475 | 81476 | 81477 | 81478 | 81479 | 81480 | 81481 | 81482 | 81483 | 82051 | 82052 | 82053 | 82054 | 82055 | 82056 | 82057 | 82058 | 82059 | 83202 | 83203 | 83204 | 83205 | 83206 | 83207 | 83208 | 83209 | 83256 | 87158 | 87159 | 87160 | 87161 | 87162 | 87163 | 87164 | 87165 | 87166 | 87167 | 87168 | 87176 | 87177 | 87178 | 87179 | 87180 | 87181 | 87182 | 87183 | 87184 | 87185 | 87387 | 87388 | 87389 | 87390 | 87391 | 87392 | 87393 | 87394 | 87395 | 87396 | 87397 | 87400 | 87401 | 88198 | 88199 | 88217 | 88218