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