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