Attachment #87387 for bug #21336

View | Details | Raw Unified | Return to bug 21336
Collapse All | Expand All

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_21336a.perl (+7 lines)
	1	$DBversion = 'XXX'; # will be replaced by the RM
	2	if( CheckVersion( $DBversion ) ) {
	3	$dbh->do( "ALTER TABLE borrowers ADD COLUMN flgAnonymized tinyint DEFAULT 0" );
	4	$dbh->do( "ALTER TABLE deletedborrowers ADD COLUMN flgAnonymized tinyint DEFAULT 0" );
	5	SetVersion( $DBversion );
	6	print "Upgrade to $DBversion done (Bug 21336 - Add field flgAnonymized)\n";
	7	}

Return to bug 21336

Lines 607-612 CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower Link Here

(-)a/installer/data/mysql/kohastructure.sql (-1 / +2 lines)
607	`lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron	607	`lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron
608	`login_attempts` int(4) default 0, -- number of failed login attemps	608	`login_attempts` int(4) default 0, -- number of failed login attemps
609	`overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token	609	`overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token
		610	`flgAnonymized` tinyint DEFAULT 0, -- flag for data anonymization
610	KEY borrowernumber (borrowernumber),	611	KEY borrowernumber (borrowernumber),
611	KEY `cardnumber` (`cardnumber`),	612	KEY `cardnumber` (`cardnumber`),
612	KEY `sms_provider_id` (`sms_provider_id`)	613	KEY `sms_provider_id` (`sms_provider_id`)
Lines 1641-1646 CREATE TABLE `borrowers` ( -- this table includes information about your patrons Link Here
1641	`lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron	1642	`lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron
1642	`login_attempts` int(4) default 0, -- number of failed login attemps	1643	`login_attempts` int(4) default 0, -- number of failed login attemps
1643	`overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token	1644	`overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token
		1645	`flgAnonymized` tinyint DEFAULT 0, -- flag for data anonymization
1644	UNIQUE KEY `cardnumber` (`cardnumber`),	1646	UNIQUE KEY `cardnumber` (`cardnumber`),
1645	PRIMARY KEY `borrowernumber` (`borrowernumber`),	1647	PRIMARY KEY `borrowernumber` (`borrowernumber`),
1646	KEY `categorycode` (`categorycode`),	1648	KEY `categorycode` (`categorycode`),
1647	-