@@ -, +, @@ --- 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 --- a/installer/data/mysql/atomicupdate/bug_21336a.perl +++ a/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"; +} --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -607,6 +607,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`) @@ -1641,6 +1642,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`), --