|
Lines 589-594
CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower
Link Here
|
| 589 |
`login_attempts` int(4) default 0, -- number of failed login attemps |
589 |
`login_attempts` int(4) default 0, -- number of failed login attemps |
| 590 |
`overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token |
590 |
`overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token |
| 591 |
`anonymized` TINYINT(1) NOT NULL DEFAULT 0, -- flag for data anonymization |
591 |
`anonymized` TINYINT(1) NOT NULL DEFAULT 0, -- flag for data anonymization |
|
|
592 |
`primary_contact_method` varchar(45) DEFAULT NULL, -- useful for reporting purposes |
| 592 |
KEY borrowernumber (borrowernumber), |
593 |
KEY borrowernumber (borrowernumber), |
| 593 |
KEY `cardnumber` (`cardnumber`), |
594 |
KEY `cardnumber` (`cardnumber`), |
| 594 |
KEY `sms_provider_id` (`sms_provider_id`) |
595 |
KEY `sms_provider_id` (`sms_provider_id`) |
|
Lines 1530-1535
CREATE TABLE `borrowers` ( -- this table includes information about your patrons
Link Here
|
| 1530 |
`login_attempts` int(4) default 0, -- number of failed login attemps |
1531 |
`login_attempts` int(4) default 0, -- number of failed login attemps |
| 1531 |
`overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token |
1532 |
`overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token |
| 1532 |
`anonymized` TINYINT(1) NOT NULL DEFAULT 0, -- flag for data anonymization |
1533 |
`anonymized` TINYINT(1) NOT NULL DEFAULT 0, -- flag for data anonymization |
|
|
1534 |
`primary_contact_method` varchar(45) DEFAULT NULL, -- useful for reporting purposes |
| 1533 |
UNIQUE KEY `cardnumber` (`cardnumber`), |
1535 |
UNIQUE KEY `cardnumber` (`cardnumber`), |
| 1534 |
PRIMARY KEY `borrowernumber` (`borrowernumber`), |
1536 |
PRIMARY KEY `borrowernumber` (`borrowernumber`), |
| 1535 |
KEY `categorycode` (`categorycode`), |
1537 |
KEY `categorycode` (`categorycode`), |
|
Lines 3435-3440
CREATE TABLE IF NOT EXISTS `borrower_modifications` (
Link Here
|
| 3435 |
`privacy` int(11) DEFAULT NULL, |
3437 |
`privacy` int(11) DEFAULT NULL, |
| 3436 |
`extended_attributes` MEDIUMTEXT DEFAULT NULL, |
3438 |
`extended_attributes` MEDIUMTEXT DEFAULT NULL, |
| 3437 |
`gdpr_proc_consent` datetime, -- data processing consent |
3439 |
`gdpr_proc_consent` datetime, -- data processing consent |
|
|
3440 |
`primary_contact_method` varchar(45) DEFAULT NULL, -- useful for reporting purposes |
| 3438 |
PRIMARY KEY (`verification_token` (191),`borrowernumber`), |
3441 |
PRIMARY KEY (`verification_token` (191),`borrowernumber`), |
| 3439 |
KEY `verification_token` (`verification_token` (191)), |
3442 |
KEY `verification_token` (`verification_token` (191)), |
| 3440 |
KEY `borrowernumber` (`borrowernumber`) |
3443 |
KEY `borrowernumber` (`borrowernumber`) |