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

(-)a/installer/data/mysql/kohastructure.sql (-1 / +2 lines)
625	`lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron	625	`lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron
626	`login_attempts` int(4) default 0, -- number of failed login attemps	626	`login_attempts` int(4) default 0, -- number of failed login attemps
627	`overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token	627	`overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token
		628	`flgAnonymized` tinyint DEFAULT 0, -- flag for data anonymization
628	KEY borrowernumber (borrowernumber),	629	KEY borrowernumber (borrowernumber),
629	KEY `cardnumber` (`cardnumber`),	630	KEY `cardnumber` (`cardnumber`),
630	KEY `sms_provider_id` (`sms_provider_id`)	631	KEY `sms_provider_id` (`sms_provider_id`)
Lines 1656-1661 CREATE TABLE `borrowers` ( -- this table includes information about your patrons Link Here
1656	`lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron	1657	`lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron
1657	`login_attempts` int(4) default 0, -- number of failed login attemps	1658	`login_attempts` int(4) default 0, -- number of failed login attemps
1658	`overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token	1659	`overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token
		1660	`flgAnonymized` tinyint DEFAULT 0, -- flag for data anonymization
1659	UNIQUE KEY `cardnumber` (`cardnumber`),	1661	UNIQUE KEY `cardnumber` (`cardnumber`),
1660	PRIMARY KEY `borrowernumber` (`borrowernumber`),	1662	PRIMARY KEY `borrowernumber` (`borrowernumber`),
1661	KEY `categorycode` (`categorycode`),	1663	KEY `categorycode` (`categorycode`),
1662	-