Lines 611-616
CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower
Link Here
|
611 |
`overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token |
611 |
`overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token |
612 |
`anonymized` TINYINT(1) NOT NULL DEFAULT 0, -- flag for data anonymization |
612 |
`anonymized` TINYINT(1) NOT NULL DEFAULT 0, -- flag for data anonymization |
613 |
`autorenew_checkouts` TINYINT(1) NOT NULL DEFAULT 1, -- flag for allowing auto-renewal |
613 |
`autorenew_checkouts` TINYINT(1) NOT NULL DEFAULT 1, -- flag for allowing auto-renewal |
|
|
614 |
`primary_contact_method` varchar(45) DEFAULT NULL, -- useful for reporting purposes |
614 |
KEY borrowernumber (borrowernumber), |
615 |
KEY borrowernumber (borrowernumber), |
615 |
KEY `cardnumber` (`cardnumber`), |
616 |
KEY `cardnumber` (`cardnumber`), |
616 |
KEY `sms_provider_id` (`sms_provider_id`) |
617 |
KEY `sms_provider_id` (`sms_provider_id`) |
Lines 1537-1542
CREATE TABLE `borrowers` ( -- this table includes information about your patrons
Link Here
|
1537 |
`overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token |
1538 |
`overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token |
1538 |
`anonymized` TINYINT(1) NOT NULL DEFAULT 0, -- flag for data anonymization |
1539 |
`anonymized` TINYINT(1) NOT NULL DEFAULT 0, -- flag for data anonymization |
1539 |
`autorenew_checkouts` TINYINT(1) NOT NULL DEFAULT 1, -- flag for allowing auto-renewal |
1540 |
`autorenew_checkouts` TINYINT(1) NOT NULL DEFAULT 1, -- flag for allowing auto-renewal |
|
|
1541 |
`primary_contact_method` varchar(45) DEFAULT NULL, -- useful for reporting purposes |
1540 |
UNIQUE KEY `cardnumber` (`cardnumber`), |
1542 |
UNIQUE KEY `cardnumber` (`cardnumber`), |
1541 |
PRIMARY KEY `borrowernumber` (`borrowernumber`), |
1543 |
PRIMARY KEY `borrowernumber` (`borrowernumber`), |
1542 |
KEY `categorycode` (`categorycode`), |
1544 |
KEY `categorycode` (`categorycode`), |
Lines 3541-3546
CREATE TABLE IF NOT EXISTS `borrower_modifications` (
Link Here
|
3541 |
`privacy` int(11) DEFAULT NULL, |
3543 |
`privacy` int(11) DEFAULT NULL, |
3542 |
`extended_attributes` MEDIUMTEXT DEFAULT NULL, |
3544 |
`extended_attributes` MEDIUMTEXT DEFAULT NULL, |
3543 |
`gdpr_proc_consent` datetime, -- data processing consent |
3545 |
`gdpr_proc_consent` datetime, -- data processing consent |
|
|
3546 |
`primary_contact_method` varchar(45) DEFAULT NULL, -- useful for reporting purposes |
3544 |
PRIMARY KEY (`verification_token` (191),`borrowernumber`), |
3547 |
PRIMARY KEY (`verification_token` (191),`borrowernumber`), |
3545 |
KEY `verification_token` (`verification_token` (191)), |
3548 |
KEY `verification_token` (`verification_token` (191)), |
3546 |
KEY `borrowernumber` (`borrowernumber`) |
3549 |
KEY `borrowernumber` (`borrowernumber`) |