Lines 635-642
CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower
Link Here
|
635 |
`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'. |
635 |
`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'. |
636 |
`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) |
636 |
`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) |
637 |
`lastseen` datetime default NULL, -- last time a patron has been seen (connected at the OPAC or staff interface) |
637 |
`lastseen` datetime default NULL, -- last time a patron has been seen (connected at the OPAC or staff interface) |
638 |
`lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron |
|
|
639 |
`login_attempts` int(4) default 0, -- number of failed login attemps |
638 |
`login_attempts` int(4) default 0, -- number of failed login attemps |
|
|
639 |
`lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron |
640 |
`overdrive_auth_token` text default NULL, -- persist OverDrive auth token |
640 |
`overdrive_auth_token` text default NULL, -- persist OverDrive auth token |
641 |
KEY borrowernumber (borrowernumber), |
641 |
KEY borrowernumber (borrowernumber), |
642 |
KEY `cardnumber` (`cardnumber`), |
642 |
KEY `cardnumber` (`cardnumber`), |
Lines 1673-1680
CREATE TABLE `borrowers` ( -- this table includes information about your patrons
Link Here
|
1673 |
`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'. |
1673 |
`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'. |
1674 |
`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) |
1674 |
`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) |
1675 |
`lastseen` datetime default NULL, -- last time a patron has been seen (connected at the OPAC or staff interface) |
1675 |
`lastseen` datetime default NULL, -- last time a patron has been seen (connected at the OPAC or staff interface) |
1676 |
`lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron |
|
|
1677 |
`login_attempts` int(4) default 0, -- number of failed login attemps |
1676 |
`login_attempts` int(4) default 0, -- number of failed login attemps |
|
|
1677 |
`lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron |
1678 |
`overdrive_auth_token` text default NULL, -- persist OverDrive auth token |
1678 |
`overdrive_auth_token` text default NULL, -- persist OverDrive auth token |
1679 |
UNIQUE KEY `cardnumber` (`cardnumber`), |
1679 |
UNIQUE KEY `cardnumber` (`cardnumber`), |
1680 |
PRIMARY KEY `borrowernumber` (`borrowernumber`), |
1680 |
PRIMARY KEY `borrowernumber` (`borrowernumber`), |