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

(-)a/installer/data/mysql/atomicupdate/bug_21336a.perl (+7 lines)
Line 0 Link Here
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
}
(-)a/installer/data/mysql/kohastructure.sql (-1 / +2 lines)
Lines 642-647 CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower Link Here
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
- 

Return to bug 21336