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 7749-7754 if(CheckVersion($DBversion)) { Link Here
7749
        ALTER TABLE borrowers ADD privacy_relative_checkouts BOOLEAN NOT NULL DEFAULT '0'
7749
        ALTER TABLE borrowers ADD privacy_relative_checkouts BOOLEAN NOT NULL DEFAULT '0'
7750
    });
7750
    });
7751
    $dbh->do(q{
7751
    $dbh->do(q{
7752
        ALTER TABLE deletedborrowers ADD privacy_relative_checkouts BOOLEAN NOT NULL DEFAULT '0'
7753
    });
7754
    $dbh->do(q{
7752
        ALTER TABLE old_issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST
7755
        ALTER TABLE old_issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST
7753
    });
7756
    });
7754
    $dbh->do(q{
7757
    $dbh->do(q{
7755
- 

Return to bug 9303