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