Lines 3275-3284
DROP TABLE IF EXISTS `illrequestattributes`;
Link Here
|
3275 |
/*!40101 SET character_set_client = utf8 */; |
3275 |
/*!40101 SET character_set_client = utf8 */; |
3276 |
CREATE TABLE `illrequestattributes` ( |
3276 |
CREATE TABLE `illrequestattributes` ( |
3277 |
`illrequest_id` bigint(20) unsigned NOT NULL COMMENT 'ILL request number', |
3277 |
`illrequest_id` bigint(20) unsigned NOT NULL COMMENT 'ILL request number', |
|
|
3278 |
`backend` varchar(80) NOT NULL COMMENT 'API ILL backend name', |
3278 |
`type` varchar(200) NOT NULL COMMENT 'API ILL property name', |
3279 |
`type` varchar(200) NOT NULL COMMENT 'API ILL property name', |
3279 |
`value` mediumtext NOT NULL COMMENT 'API ILL property value', |
3280 |
`value` mediumtext NOT NULL COMMENT 'API ILL property value', |
3280 |
`readonly` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Is this attribute read only', |
3281 |
`readonly` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Is this attribute read only', |
3281 |
PRIMARY KEY (`illrequest_id`,`type`(191)), |
3282 |
PRIMARY KEY (`illrequest_id`,`backend`,`type`(191)), |
3282 |
CONSTRAINT `illrequestattributes_ifk` FOREIGN KEY (`illrequest_id`) REFERENCES `illrequests` (`illrequest_id`) ON DELETE CASCADE ON UPDATE CASCADE |
3283 |
CONSTRAINT `illrequestattributes_ifk` FOREIGN KEY (`illrequest_id`) REFERENCES `illrequests` (`illrequest_id`) ON DELETE CASCADE ON UPDATE CASCADE |
3283 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
3284 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
3284 |
/*!40101 SET character_set_client = @saved_cs_client */; |
3285 |
/*!40101 SET character_set_client = @saved_cs_client */; |
3285 |
- |
|
|