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

(-)a/installer/data/mysql/kohastructure.sql (-1 / +2 lines)
642	`lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron	642	`lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron
643	`login_attempts` int(4) default 0, -- number of failed login attemps	643	`login_attempts` int(4) default 0, -- number of failed login attemps
644	`overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token	644	`overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token
		645	`flgAnonymized` tinyint DEFAULT 0, -- flag for data anonymization
645	KEY borrowernumber (borrowernumber),	646	KEY borrowernumber (borrowernumber),
646	KEY `cardnumber` (`cardnumber`),	647	KEY `cardnumber` (`cardnumber`),
647	KEY `sms_provider_id` (`sms_provider_id`)	648	KEY `sms_provider_id` (`sms_provider_id`)
Lines 1675-1680 CREATE TABLE `borrowers` ( -- this table includes information about your patrons Link Here
1675	`lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron	1676	`lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron
1676	`login_attempts` int(4) default 0, -- number of failed login attemps	1677	`login_attempts` int(4) default 0, -- number of failed login attemps
1677	`overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token	1678	`overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token
		1679	`flgAnonymized` tinyint DEFAULT 0, -- flag for data anonymization
1678	UNIQUE KEY `cardnumber` (`cardnumber`),	1680	UNIQUE KEY `cardnumber` (`cardnumber`),
1679	PRIMARY KEY `borrowernumber` (`borrowernumber`),	1681	PRIMARY KEY `borrowernumber` (`borrowernumber`),
1680	KEY `categorycode` (`categorycode`),	1682	KEY `categorycode` (`categorycode`),
1681	-