|
Lines 1670-1676
CREATE TABLE `borrowers` ( -- this table includes information about your patrons
Link Here
|
| 1670 |
`privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts |
1670 |
`privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts |
| 1671 |
`checkprevcheckout` varchar(7) NOT NULL default 'inherit', -- 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'. |
1671 |
`checkprevcheckout` varchar(7) NOT NULL default 'inherit', -- 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'. |
| 1672 |
`updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- time of last change could be useful for synchronization with external systems (among others) |
1672 |
`updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- time of last change could be useful for synchronization with external systems (among others) |
| 1673 |
`lastseen` datetime default NULL, -- last time a patron has been seed (connected at the OPAC or staff interface) |
1673 |
`lastseen` datetime default NULL, -- last time a patron has been seen (connected at the OPAC or staff interface) |
| 1674 |
`lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron |
1674 |
`lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron |
| 1675 |
`login_attempts` int(4) default 0, -- number of failed login attemps |
1675 |
`login_attempts` int(4) default 0, -- number of failed login attemps |
| 1676 |
`overdrive_auth_token` text default NULL, -- persist OverDrive auth token |
1676 |
`overdrive_auth_token` text default NULL, -- persist OverDrive auth token |
| 1677 |
- |
|
|