Lines 641-646
CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower
Link Here
|
641 |
`lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron |
641 |
`lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron |
642 |
`login_attempts` int(4) default 0, -- number of failed login attemps |
642 |
`login_attempts` int(4) default 0, -- number of failed login attemps |
643 |
`overdrive_auth_token` text default NULL, -- persist OverDrive auth token |
643 |
`overdrive_auth_token` text default NULL, -- persist OverDrive auth token |
|
|
644 |
`primary_contact_method` varchar(45) DEFAULT NULL, -- useful for reporting purposes |
644 |
KEY borrowernumber (borrowernumber), |
645 |
KEY borrowernumber (borrowernumber), |
645 |
KEY `cardnumber` (`cardnumber`), |
646 |
KEY `cardnumber` (`cardnumber`), |
646 |
KEY `sms_provider_id` (`sms_provider_id`) |
647 |
KEY `sms_provider_id` (`sms_provider_id`) |
Lines 1681-1686
CREATE TABLE `borrowers` ( -- this table includes information about your patrons
Link Here
|
1681 |
`lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron |
1682 |
`lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron |
1682 |
`login_attempts` int(4) default 0, -- number of failed login attemps |
1683 |
`login_attempts` int(4) default 0, -- number of failed login attemps |
1683 |
`overdrive_auth_token` text default NULL, -- persist OverDrive auth token |
1684 |
`overdrive_auth_token` text default NULL, -- persist OverDrive auth token |
|
|
1685 |
`lastseen` datetime default NULL, -- last time a patron has been seed (connected at the OPAC or staff interface) |
1686 |
`primary_contact_method` varchar(45) DEFAULT NULL, -- useful for reporting purposes |
1684 |
UNIQUE KEY `cardnumber` (`cardnumber`), |
1687 |
UNIQUE KEY `cardnumber` (`cardnumber`), |
1685 |
PRIMARY KEY `borrowernumber` (`borrowernumber`), |
1688 |
PRIMARY KEY `borrowernumber` (`borrowernumber`), |
1686 |
KEY `categorycode` (`categorycode`), |
1689 |
KEY `categorycode` (`categorycode`), |
Lines 3471-3476
CREATE TABLE IF NOT EXISTS `borrower_modifications` (
Link Here
|
3471 |
`smsalertnumber` varchar(50) DEFAULT NULL, |
3474 |
`smsalertnumber` varchar(50) DEFAULT NULL, |
3472 |
`privacy` int(11) DEFAULT NULL, |
3475 |
`privacy` int(11) DEFAULT NULL, |
3473 |
`extended_attributes` text DEFAULT NULL, |
3476 |
`extended_attributes` text DEFAULT NULL, |
|
|
3477 |
`primary_contact_method` varchar(45) DEFAULT NULL, -- useful for reporting purposes |
3474 |
PRIMARY KEY (`verification_token`,`borrowernumber`), |
3478 |
PRIMARY KEY (`verification_token`,`borrowernumber`), |
3475 |
KEY `verification_token` (`verification_token`), |
3479 |
KEY `verification_token` (`verification_token`), |
3476 |
KEY `borrowernumber` (`borrowernumber`) |
3480 |
KEY `borrowernumber` (`borrowernumber`) |