Lines 244-250
CREATE TABLE `borrowers` ( -- this table includes information about your patrons
Link Here
|
244 |
`sex` varchar(1) default NULL, -- patron/borrower's gender |
244 |
`sex` varchar(1) default NULL, -- patron/borrower's gender |
245 |
`password` varchar(30) default NULL, -- patron/borrower's encrypted password |
245 |
`password` varchar(30) default NULL, -- patron/borrower's encrypted password |
246 |
`flags` int(11) default NULL, -- will include a number associated with the staff member's permissions |
246 |
`flags` int(11) default NULL, -- will include a number associated with the staff member's permissions |
247 |
`userid` varchar(30) default NULL, -- patron/borrower's opac and/or staff client log in |
247 |
`userid` varchar(75) default NULL, -- patron/borrower's opac and/or staff client log in |
248 |
`opacnote` mediumtext, -- a note on the patron/borrower's account that is visible in the OPAC and staff client |
248 |
`opacnote` mediumtext, -- a note on the patron/borrower's account that is visible in the OPAC and staff client |
249 |
`contactnote` varchar(255) default NULL, -- a note related to the patron/borrower's alternate address |
249 |
`contactnote` varchar(255) default NULL, -- a note related to the patron/borrower's alternate address |
250 |
`sort1` varchar(80) default NULL, -- a field that can be used for any information unique to the library |
250 |
`sort1` varchar(80) default NULL, -- a field that can be used for any information unique to the library |