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

(-)a/installer/data/mysql/atomicupdate/bug_9447_-_add_blacklist_and_whitelist_fields_for_borrowers_tags_comments.perl (+30 lines)
Line 0 Link Here
1
$DBversion = 'XXX';
2
if( CheckVersion( $DBversion ) ) {
3
    unless( column_exists( 'borrowers', 'tags_whitelist' ) ) {
4
        $dbh->do(q|ALTER TABLE borrowers ADD tags_whitelist TINYINT(1) default 0 NOT NULL AFTER overdrive_auth_token|);
5
    }
6
    unless( column_exists( 'borrowers', 'comments_whitelist' ) ) {
7
        $dbh->do(q|ALTER TABLE borrowers ADD comments_whitelist TINYINT(1) default 0 NOT NULL AFTER tags_whitelist|);
8
    }
9
    unless( column_exists( 'borrowers', 'tags_blacklist' ) ) {
10
        $dbh->do(q|ALTER TABLE borrowers ADD tags_blacklist TINYINT(1) default 0 NOT NULL AFTER comments_whitelist|);
11
    }
12
    unless( column_exists( 'borrowers', 'comments_blacklist' ) ) {
13
        $dbh->do(q|ALTER TABLE borrowers ADD comments_blacklist TINYINT(1) default 0 NOT NULL AFTER tags_blacklist|);
14
    }
15
    unless( column_exists( 'deletedborrowers', 'tags_whitelist' ) ) {
16
        $dbh->do(q|ALTER TABLE deletedborrowers ADD tags_whitelist TINYINT(1) default 0 NOT NULL AFTER overdrive_auth_token|);
17
    }
18
    unless( column_exists( 'deletedborrowers', 'comments_whitelist' ) ) {
19
        $dbh->do(q|ALTER TABLE deletedborrowers ADD comments_whitelist TINYINT(1) default 0 NOT NULL AFTER tags_whitelist|);
20
    }
21
    unless( column_exists( 'deletedborrowers', 'tags_blacklist' ) ) {
22
        $dbh->do(q|ALTER TABLE deletedborrowers ADD tags_blacklist TINYINT(1) default 0 NOT NULL AFTER comments_whitelist|);
23
    }
24
    unless( column_exists( 'deletedborrowers', 'comments_blacklist' ) ) {
25
        $dbh->do(q|ALTER TABLE deletedborrowers ADD comments_blacklist TINYINT(1) default 0 NOT NULL AFTER tags_blacklist|);
26
    }
27
28
    SetVersion( $DBversion );
29
    print "Upgrade to $DBversion done (Bug 9447: Add columns borrowers.tags_whitelist, borrowers.comments_whitelist, borrowers.tags_blacklist, borrowers.comments_blacklist, deletedborrowers.tags_whitelist, deletedborrowers.comments_whitelist, deletedborrowers.tags_blacklist, and deletedborrowers.comments_blacklist)\n";
30
}
(-)a/installer/data/mysql/kohastructure.sql (-1 / +8 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
  `tags_whitelist` TINYINT(1) DEFAULT 0 NOT NULL, -- borrower can submit tags without requiring approval
646
  `comments_whitelist` TINYINT(1) DEFAULT 0 NOT NULL, -- borrower can submit comments without requiring approval
647
  `tags_blacklist` TINYINT(1) DEFAULT 0 NOT NULL, -- borrower is blocked from submitting tags
648
  `comments_blacklist` TINYINT(1) DEFAULT 0 NOT NULL, -- borrower is blocked from submitting comments
645
  KEY borrowernumber (borrowernumber),
649
  KEY borrowernumber (borrowernumber),
646
  KEY `cardnumber` (`cardnumber`),
650
  KEY `cardnumber` (`cardnumber`),
647
  KEY `sms_provider_id` (`sms_provider_id`)
651
  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
1679
  `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
1680
  `login_attempts` int(4) default 0, -- number of failed login attemps
1677
  `overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token
1681
  `overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token
1682
  `tags_whitelist` TINYINT(1) DEFAULT 0 NOT NULL, -- borrower can submit tags without requiring approval
1683
  `comments_whitelist` TINYINT(1) DEFAULT 0 NOT NULL, -- borrower can submit comments without requiring approval
1684
  `tags_blacklist` TINYINT(1) DEFAULT 0 NOT NULL, -- borrower is blocked from submitting tags
1685
  `comments_blacklist` TINYINT(1) DEFAULT 0 NOT NULL, -- borrower is blocked from submitting comments
1678
  UNIQUE KEY `cardnumber` (`cardnumber`),
1686
  UNIQUE KEY `cardnumber` (`cardnumber`),
1679
  PRIMARY KEY `borrowernumber` (`borrowernumber`),
1687
  PRIMARY KEY `borrowernumber` (`borrowernumber`),
1680
  KEY `categorycode` (`categorycode`),
1688
  KEY `categorycode` (`categorycode`),
1681
- 

Return to bug 9447