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

(-)a/installer/data/mysql/atomicupdate/bug_24476_opt_out_of_auto_renewal.perl (+11 lines)
Line 0 Link Here
1
$DBversion = 'XXX';
2
if( CheckVersion( $DBversion ) ) {
3
    unless( column_exists('borrowers','no_autorenewal') ){
4
        $dbh->do( "ALTER TABLE borrowers ADD COLUMN no_autorenewal TINYINT(1)" );
5
    }
6
    unless( column_exists('deletedborrowers','no_autorenewal') ){
7
        $dbh->do( "ALTER TABLE deletedborrowers ADD COLUMN no_autorenewal TINYINT(1)" );
8
    }
9
    SetVersion( $DBversion );
10
    print "Upgrade to $DBversion done (Bug 24476 - Allow patrons to opt-out of autorenewal)\n";
11
}
(-)a/installer/data/mysql/kohastructure.sql (-1 / +2 lines)
Lines 590-595 CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower Link Here
590
  `login_attempts` int(4) default 0, -- number of failed login attemps
590
  `login_attempts` int(4) default 0, -- number of failed login attemps
591
  `overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token
591
  `overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token
592
  `anonymized` TINYINT(1) NOT NULL DEFAULT 0, -- flag for data anonymization
592
  `anonymized` TINYINT(1) NOT NULL DEFAULT 0, -- flag for data anonymization
593
  `no_autorenewal` TINYINT(1) NOT NULL DEFAULT 0, -- flag for auto-renewal opt out
593
  KEY borrowernumber (borrowernumber),
594
  KEY borrowernumber (borrowernumber),
594
  KEY `cardnumber` (`cardnumber`),
595
  KEY `cardnumber` (`cardnumber`),
595
  KEY `sms_provider_id` (`sms_provider_id`)
596
  KEY `sms_provider_id` (`sms_provider_id`)
Lines 1585-1590 CREATE TABLE `borrowers` ( -- this table includes information about your patrons Link Here
1585
  `login_attempts` int(4) default 0, -- number of failed login attemps
1586
  `login_attempts` int(4) default 0, -- number of failed login attemps
1586
  `overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token
1587
  `overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token
1587
  `anonymized` TINYINT(1) NOT NULL DEFAULT 0, -- flag for data anonymization
1588
  `anonymized` TINYINT(1) NOT NULL DEFAULT 0, -- flag for data anonymization
1589
  `no_autorenewal` TINYINT(1) NOT NULL DEFAULT 0, -- flag for auto-renewal opt out
1588
  UNIQUE KEY `cardnumber` (`cardnumber`),
1590
  UNIQUE KEY `cardnumber` (`cardnumber`),
1589
  PRIMARY KEY `borrowernumber` (`borrowernumber`),
1591
  PRIMARY KEY `borrowernumber` (`borrowernumber`),
1590
  KEY `categorycode` (`categorycode`),
1592
  KEY `categorycode` (`categorycode`),
1591
- 

Return to bug 24476