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

(-)a/installer/data/mysql/kohastructure.sql (+1 lines)
Lines 863-868 CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower Link Here
863
  `altcontactphone` varchar(50) default NULL, -- the phone number for the alternate contact for the patron/borrower
863
  `altcontactphone` varchar(50) default NULL, -- the phone number for the alternate contact for the patron/borrower
864
  `smsalertnumber` varchar(50) default NULL, -- the mobile phone number where the patron/borrower would like to receive notices (if SNS turned on)
864
  `smsalertnumber` varchar(50) default NULL, -- the mobile phone number where the patron/borrower would like to receive notices (if SNS turned on)
865
  `privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history  KEY `borrowernumber` (`borrowernumber`),
865
  `privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history  KEY `borrowernumber` (`borrowernumber`),
866
  `privacy_relative_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts
866
  KEY borrowernumber (borrowernumber),
867
  KEY borrowernumber (borrowernumber),
867
  KEY `cardnumber` (`cardnumber`)
868
  KEY `cardnumber` (`cardnumber`)
868
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
869
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +3 lines)
Lines 7756-7761 if(CheckVersion($DBversion)) { Link Here
7756
        ALTER TABLE borrowers ADD privacy_relative_checkouts BOOLEAN NOT NULL DEFAULT '0'
7756
        ALTER TABLE borrowers ADD privacy_relative_checkouts BOOLEAN NOT NULL DEFAULT '0'
7757
    });
7757
    });
7758
    $dbh->do(q{
7758
    $dbh->do(q{
7759
        ALTER TABLE deletedborrowers ADD privacy_relative_checkouts BOOLEAN NOT NULL DEFAULT '0'
7760
    });
7761
    $dbh->do(q{
7759
        ALTER TABLE old_issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST
7762
        ALTER TABLE old_issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST
7760
    });
7763
    });
7761
    $dbh->do(q{
7764
    $dbh->do(q{
7762
- 

Return to bug 9303