From 56f8aadd1c6139bd5d5141313107b7dc00328658 Mon Sep 17 00:00:00 2001 From: Tomas Cohen Arazi Date: Wed, 17 Apr 2019 15:01:47 -0300 Subject: [PATCH] Bug 22729: DB update Signed-off-by: Tomas Cohen Arazi --- .../atomicupdate/bug_21336_followup.perl | 20 +++++++++++++++++++ installer/data/mysql/kohastructure.sql | 4 ++-- 2 files changed, 22 insertions(+), 2 deletions(-) create mode 100644 installer/data/mysql/atomicupdate/bug_21336_followup.perl diff --git a/installer/data/mysql/atomicupdate/bug_21336_followup.perl b/installer/data/mysql/atomicupdate/bug_21336_followup.perl new file mode 100644 index 0000000000..880d83205e --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_21336_followup.perl @@ -0,0 +1,20 @@ +$DBversion = 'XXX'; +if( CheckVersion( $DBversion ) ) { + + if ( column_exists( 'borrowers', 'flgAnonymized' ) ) { + $dbh->do(q{ + ALTER TABLE borrowers + CHANGE `flgAnonymized` `anonymized` TINYINT(1) NOT NULL DEFAULT 0 + }); + } + + if ( column_exists( 'deletedborrowers', 'flgAnonymized' ) ) { + $dbh->do(q{ + ALTER TABLE deletedborrowers + CHANGE `flgAnonymized` `anonymized` TINYINT(1) NOT NULL DEFAULT 0 + }); + } + + SetVersion( $DBversion ); + print "Upgrade to $DBversion done (Bug 21336 - (follow-up) Rename flgAnonymized column)\n"; +} diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 7b78a87b76..77224bcac3 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -609,7 +609,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 + `anonymized` TINYINT(1) NOT NULL DEFAULT 0, -- flag for data anonymization KEY borrowernumber (borrowernumber), KEY `cardnumber` (`cardnumber`), KEY `sms_provider_id` (`sms_provider_id`) @@ -1643,7 +1643,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 + `anonymized` TINYINT(1) NOT NULL DEFAULT 0, -- flag for data anonymization UNIQUE KEY `cardnumber` (`cardnumber`), PRIMARY KEY `borrowernumber` (`borrowernumber`), KEY `categorycode` (`categorycode`), -- 2.21.0