Lines 301-307
DROP TABLE IF EXISTS `borrower_attributes`;
Link Here
|
301 |
CREATE TABLE `borrower_attributes` ( -- values of custom patron fields known as extended patron attributes linked to patrons/borrowers |
301 |
CREATE TABLE `borrower_attributes` ( -- values of custom patron fields known as extended patron attributes linked to patrons/borrowers |
302 |
`borrowernumber` int(11) NOT NULL, -- foreign key from the borrowers table, defines which patron/borrower has this attribute |
302 |
`borrowernumber` int(11) NOT NULL, -- foreign key from the borrowers table, defines which patron/borrower has this attribute |
303 |
`code` varchar(10) NOT NULL, -- foreign key from the borrower_attribute_types table, defines which custom field this value was entered for |
303 |
`code` varchar(10) NOT NULL, -- foreign key from the borrower_attribute_types table, defines which custom field this value was entered for |
304 |
`attribute` varchar(64) default NULL, -- custom patron field value |
304 |
`attribute` varchar(255) default NULL, -- custom patron field value |
305 |
`password` varchar(64) default NULL, -- password associated with this field |
305 |
`password` varchar(64) default NULL, -- password associated with this field |
306 |
KEY `borrowernumber` (`borrowernumber`), |
306 |
KEY `borrowernumber` (`borrowernumber`), |
307 |
KEY `code_attribute` (`code`, `attribute`), |
307 |
KEY `code_attribute` (`code`, `attribute`), |