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

(-)a/installer/data/mysql/atomicupdate/bug_15517.sql (+2 lines)
Line 0 Link Here
1 
ALTER TABLE deletedborrowers MODIFY COLUMN userid VARCHAR(75) DEFAULT NULL;
2 
ALTER TABLE deletedborrowers MODIFY COLUMN password VARCHAR(60) DEFAULT NULL;
(-)a/installer/data/mysql/kohastructure.sql (-3 / +2 lines)
Lines 881-889 CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower Link Here
881 
  `borrowernotes` mediumtext, -- a note on the patron/borrower's account that is only visible in the staff client
 881 
  `borrowernotes` mediumtext, -- a note on the patron/borrower's account that is only visible in the staff client
882 
  `relationship` varchar(100) default NULL, -- used for children to include the relationship to their guarentor
 882 
  `relationship` varchar(100) default NULL, -- used for children to include the relationship to their guarentor
883 
  `sex` varchar(1) default NULL, -- patron/borrower's gender
 883 
  `sex` varchar(1) default NULL, -- patron/borrower's gender
884 
  `password` varchar(30) default NULL, -- patron/borrower's encrypted password
 884 
  `password` varchar(60) default NULL, -- patron/borrower's encrypted password
885 
  `flags` int(11) default NULL, -- will include a number associated with the staff member's permissions
 885 
  `flags` int(11) default NULL, -- will include a number associated with the staff member's permissions
886 
  `userid` varchar(30) default NULL, -- patron/borrower's opac and/or staff client log in
 886 
  `userid` varchar(75) default NULL, -- patron/borrower's opac and/or staff client log in
887 
  `opacnote` mediumtext, -- a note on the patron/borrower's account that is visible in the OPAC and staff client
 887 
  `opacnote` mediumtext, -- a note on the patron/borrower's account that is visible in the OPAC and staff client
888 
  `contactnote` varchar(255) default NULL, -- a note related to the patron/borrower's alternate address
 888 
  `contactnote` varchar(255) default NULL, -- a note related to the patron/borrower's alternate address
889 
  `sort1` varchar(80) default NULL, -- a field that can be used for any information unique to the library
 889 
  `sort1` varchar(80) default NULL, -- a field that can be used for any information unique to the library
890 
-

Return to bug 15517