Lines 1472-1478
CREATE TABLE `borrowers` (
Link Here
|
1472 |
`privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'controls if relatives can see this patron''s checkouts', |
1472 |
`privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'controls if relatives can see this patron''s checkouts', |
1473 |
`checkprevcheckout` varchar(7) NOT NULL DEFAULT 'inherit' COMMENT 'produce a warning for this patron if this item has previously been checked out to this patron if ''yes'', not if ''no'', defer to category setting if ''inherit''.', |
1473 |
`checkprevcheckout` varchar(7) NOT NULL DEFAULT 'inherit' COMMENT 'produce a warning for this patron if this item has previously been checked out to this patron if ''yes'', not if ''no'', defer to category setting if ''inherit''.', |
1474 |
`updated_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'time of last change could be useful for synchronization with external systems (among others)', |
1474 |
`updated_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'time of last change could be useful for synchronization with external systems (among others)', |
1475 |
`lastseen` datetime DEFAULT NULL COMMENT 'last time a patron has been seen (connected at the OPAC or staff interface)', |
1475 |
`lastseen` datetime NOT NULL DEFAULT current_timestamp() COMMENT 'last time a patron has been seen (connected at the OPAC or staff interface)', |
1476 |
`lang` varchar(25) NOT NULL DEFAULT 'default' COMMENT 'lang to use to send notices to this patron', |
1476 |
`lang` varchar(25) NOT NULL DEFAULT 'default' COMMENT 'lang to use to send notices to this patron', |
1477 |
`login_attempts` int(4) NOT NULL DEFAULT 0 COMMENT 'number of failed login attemps', |
1477 |
`login_attempts` int(4) NOT NULL DEFAULT 0 COMMENT 'number of failed login attemps', |
1478 |
`overdrive_auth_token` mediumtext DEFAULT NULL COMMENT 'persist OverDrive auth token', |
1478 |
`overdrive_auth_token` mediumtext DEFAULT NULL COMMENT 'persist OverDrive auth token', |
1479 |
- |
|
|