|
Lines 4638-4644
DROP TABLE IF EXISTS `patron_consent`;
Link Here
|
| 4638 |
CREATE TABLE `patron_consent` ( |
4638 |
CREATE TABLE `patron_consent` ( |
| 4639 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
4639 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
| 4640 |
`borrowernumber` int(11) NOT NULL, |
4640 |
`borrowernumber` int(11) NOT NULL, |
| 4641 |
`type` enum('GDPR_PROCESSING') DEFAULT NULL COMMENT 'allows for future extension', |
4641 |
`type` tinytext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'consent type, could be custom type', |
| 4642 |
`given_on` datetime DEFAULT NULL, |
4642 |
`given_on` datetime DEFAULT NULL, |
| 4643 |
`refused_on` datetime DEFAULT NULL, |
4643 |
`refused_on` datetime DEFAULT NULL, |
| 4644 |
PRIMARY KEY (`id`), |
4644 |
PRIMARY KEY (`id`), |
| 4645 |
- |
|
|