Lines 602-608
CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower
Link Here
|
602 |
`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) |
602 |
`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) |
603 |
`lastseen` datetime default NULL, -- last time a patron has been seen (connected at the OPAC or staff interface) |
603 |
`lastseen` datetime default NULL, -- last time a patron has been seen (connected at the OPAC or staff interface) |
604 |
`lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron |
604 |
`lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron |
605 |
`login_attempts` int(4) default 0, -- number of failed login attemps |
605 |
`login_attempts` int(4) NOT NULL default 0, -- number of failed login attemps |
606 |
`overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token |
606 |
`overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token |
607 |
`anonymized` TINYINT(1) NOT NULL DEFAULT 0, -- flag for data anonymization |
607 |
`anonymized` TINYINT(1) NOT NULL DEFAULT 0, -- flag for data anonymization |
608 |
`autorenew_checkouts` TINYINT(1) NOT NULL DEFAULT 1, -- flag for allowing auto-renewal |
608 |
`autorenew_checkouts` TINYINT(1) NOT NULL DEFAULT 1, -- flag for allowing auto-renewal |
Lines 1522-1528
CREATE TABLE `borrowers` ( -- this table includes information about your patrons
Link Here
|
1522 |
`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) |
1522 |
`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) |
1523 |
`lastseen` datetime default NULL, -- last time a patron has been seen (connected at the OPAC or staff interface) |
1523 |
`lastseen` datetime default NULL, -- last time a patron has been seen (connected at the OPAC or staff interface) |
1524 |
`lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron |
1524 |
`lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron |
1525 |
`login_attempts` int(4) default 0, -- number of failed login attemps |
1525 |
`login_attempts` int(4) NOT NULL default 0, -- number of failed login attemps |
1526 |
`overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token |
1526 |
`overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token |
1527 |
`anonymized` TINYINT(1) NOT NULL DEFAULT 0, -- flag for data anonymization |
1527 |
`anonymized` TINYINT(1) NOT NULL DEFAULT 0, -- flag for data anonymization |
1528 |
`autorenew_checkouts` TINYINT(1) NOT NULL DEFAULT 1, -- flag for allowing auto-renewal |
1528 |
`autorenew_checkouts` TINYINT(1) NOT NULL DEFAULT 1, -- flag for allowing auto-renewal |