Attachment #80202 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 615-620 CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower Link Here

(-)a/installer/data/mysql/kohastructure.sql (-1 / +2 lines)
615	`lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron	615	`lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron
616	`login_attempts` int(4) default 0, -- number of failed login attemps	616	`login_attempts` int(4) default 0, -- number of failed login attemps
617	`overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token	617	`overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token
		618	`flgAnonymized` tinyint DEFAULT 0, -- flag for data anonymization
618	KEY borrowernumber (borrowernumber),	619	KEY borrowernumber (borrowernumber),
619	KEY `cardnumber` (`cardnumber`),	620	KEY `cardnumber` (`cardnumber`),
620	KEY `sms_provider_id` (`sms_provider_id`)	621	KEY `sms_provider_id` (`sms_provider_id`)
Lines 1645-1650 CREATE TABLE `borrowers` ( -- this table includes information about your patrons Link Here
1645	`lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron	1646	`lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron
1646	`login_attempts` int(4) default 0, -- number of failed login attemps	1647	`login_attempts` int(4) default 0, -- number of failed login attemps
1647	`overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token	1648	`overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token
		1649	`flgAnonymized` tinyint DEFAULT 0, -- flag for data anonymization
1648	UNIQUE KEY `cardnumber` (`cardnumber`),	1650	UNIQUE KEY `cardnumber` (`cardnumber`),
1649	PRIMARY KEY `borrowernumber` (`borrowernumber`),	1651	PRIMARY KEY `borrowernumber` (`borrowernumber`),
1650	KEY `categorycode` (`categorycode`),	1652	KEY `categorycode` (`categorycode`),
1651	-