Lines 1304-1309
CREATE TABLE `borrower_modifications` (
Link Here
|
1304 |
`privacy` int(11) DEFAULT NULL, |
1304 |
`privacy` int(11) DEFAULT NULL, |
1305 |
`extended_attributes` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1305 |
`extended_attributes` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1306 |
`gdpr_proc_consent` datetime DEFAULT NULL COMMENT 'data processing consent', |
1306 |
`gdpr_proc_consent` datetime DEFAULT NULL COMMENT 'data processing consent', |
|
|
1307 |
`primary_contact_method` varchar(45) DEFAULT NULL COMMENT 'useful for reporting purposes', |
1307 |
PRIMARY KEY (`verification_token`(191),`borrowernumber`), |
1308 |
PRIMARY KEY (`verification_token`(191),`borrowernumber`), |
1308 |
KEY `verification_token` (`verification_token`(191)), |
1309 |
KEY `verification_token` (`verification_token`(191)), |
1309 |
KEY `borrowernumber` (`borrowernumber`) |
1310 |
KEY `borrowernumber` (`borrowernumber`) |
Lines 1429-1434
CREATE TABLE `borrowers` (
Link Here
|
1429 |
`overdrive_auth_token` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'persist OverDrive auth token', |
1430 |
`overdrive_auth_token` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'persist OverDrive auth token', |
1430 |
`anonymized` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'flag for data anonymization', |
1431 |
`anonymized` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'flag for data anonymization', |
1431 |
`autorenew_checkouts` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'flag for allowing auto-renewal', |
1432 |
`autorenew_checkouts` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'flag for allowing auto-renewal', |
|
|
1433 |
`primary_contact_method` varchar(45) DEFAULT NULL COMMENT 'useful for reporting purposes', |
1432 |
PRIMARY KEY (`borrowernumber`), |
1434 |
PRIMARY KEY (`borrowernumber`), |
1433 |
UNIQUE KEY `cardnumber` (`cardnumber`), |
1435 |
UNIQUE KEY `cardnumber` (`cardnumber`), |
1434 |
UNIQUE KEY `userid` (`userid`), |
1436 |
UNIQUE KEY `userid` (`userid`), |
Lines 2430-2435
CREATE TABLE `deletedborrowers` (
Link Here
|
2430 |
`overdrive_auth_token` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'persist OverDrive auth token', |
2432 |
`overdrive_auth_token` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'persist OverDrive auth token', |
2431 |
`anonymized` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'flag for data anonymization', |
2433 |
`anonymized` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'flag for data anonymization', |
2432 |
`autorenew_checkouts` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'flag for allowing auto-renewal', |
2434 |
`autorenew_checkouts` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'flag for allowing auto-renewal', |
|
|
2435 |
`primary_contact_method` varchar(45) DEFAULT NULL COMMENT 'useful for reporting purposes', |
2433 |
KEY `borrowernumber` (`borrowernumber`), |
2436 |
KEY `borrowernumber` (`borrowernumber`), |
2434 |
KEY `cardnumber` (`cardnumber`), |
2437 |
KEY `cardnumber` (`cardnumber`), |
2435 |
KEY `sms_provider_id` (`sms_provider_id`) |
2438 |
KEY `sms_provider_id` (`sms_provider_id`) |