Lines 3269-3275
CREATE TABLE `erm_usage_data_providers` (
Link Here
|
3269 |
`requestor_email` varchar(80) DEFAULT NULL COMMENT 'requestor email', |
3269 |
`requestor_email` varchar(80) DEFAULT NULL COMMENT 'requestor email', |
3270 |
`report_types` varchar(255) DEFAULT NULL COMMENT 'report types provided by the harvester', |
3270 |
`report_types` varchar(255) DEFAULT NULL COMMENT 'report types provided by the harvester', |
3271 |
`service_platform` varchar(80) DEFAULT NULL COMMENT 'platform if provider requires it', |
3271 |
`service_platform` varchar(80) DEFAULT NULL COMMENT 'platform if provider requires it', |
3272 |
PRIMARY KEY (`erm_usage_data_provider_id`) |
3272 |
`vendor_id` int(11) DEFAULT NULL COMMENT 'foreign key to aqbooksellers', |
|
|
3273 |
PRIMARY KEY (`erm_usage_data_provider_id`), |
3274 |
KEY `erm_usage_data_provider_ibfk_1` (`vendor_id`), |
3275 |
CONSTRAINT `erm_usage_data_provider_ibfk_1` FOREIGN KEY (`vendor_id`) REFERENCES `aqbooksellers` (`id`) ON DELETE SET NULL ON UPDATE CASCADE |
3273 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
3276 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
3274 |
/*!40101 SET character_set_client = @saved_cs_client */; |
3277 |
/*!40101 SET character_set_client = @saved_cs_client */; |
3275 |
|
3278 |
|
3276 |
- |
|
|