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