|
Lines 615-620
CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower
Link Here
|
| 615 |
`lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron |
615 |
`lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron |
| 616 |
`login_attempts` int(4) default 0, -- number of failed login attemps |
616 |
`login_attempts` int(4) default 0, -- number of failed login attemps |
| 617 |
`overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token |
617 |
`overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token |
|
|
618 |
`flgAnonymized` tinyint DEFAULT 0, -- flag for data anonymization |
| 618 |
KEY borrowernumber (borrowernumber), |
619 |
KEY borrowernumber (borrowernumber), |
| 619 |
KEY `cardnumber` (`cardnumber`), |
620 |
KEY `cardnumber` (`cardnumber`), |
| 620 |
KEY `sms_provider_id` (`sms_provider_id`) |
621 |
KEY `sms_provider_id` (`sms_provider_id`) |
|
Lines 1645-1650
CREATE TABLE `borrowers` ( -- this table includes information about your patrons
Link Here
|
| 1645 |
`lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron |
1646 |
`lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron |
| 1646 |
`login_attempts` int(4) default 0, -- number of failed login attemps |
1647 |
`login_attempts` int(4) default 0, -- number of failed login attemps |
| 1647 |
`overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token |
1648 |
`overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token |
|
|
1649 |
`flgAnonymized` tinyint DEFAULT 0, -- flag for data anonymization |
| 1648 |
UNIQUE KEY `cardnumber` (`cardnumber`), |
1650 |
UNIQUE KEY `cardnumber` (`cardnumber`), |
| 1649 |
PRIMARY KEY `borrowernumber` (`borrowernumber`), |
1651 |
PRIMARY KEY `borrowernumber` (`borrowernumber`), |
| 1650 |
KEY `categorycode` (`categorycode`), |
1652 |
KEY `categorycode` (`categorycode`), |
| 1651 |
- |
|
|