Lines 3294-3303
DROP TABLE IF EXISTS `illrequestattributes`;
Link Here
|
3294 |
/*!40101 SET character_set_client = utf8 */; |
3294 |
/*!40101 SET character_set_client = utf8 */; |
3295 |
CREATE TABLE `illrequestattributes` ( |
3295 |
CREATE TABLE `illrequestattributes` ( |
3296 |
`illrequest_id` bigint(20) unsigned NOT NULL COMMENT 'ILL request number', |
3296 |
`illrequest_id` bigint(20) unsigned NOT NULL COMMENT 'ILL request number', |
|
|
3297 |
`backend` varchar(80) NOT NULL COMMENT 'API ILL backend name', |
3297 |
`type` varchar(200) NOT NULL COMMENT 'API ILL property name', |
3298 |
`type` varchar(200) NOT NULL COMMENT 'API ILL property name', |
3298 |
`value` mediumtext NOT NULL COMMENT 'API ILL property value', |
3299 |
`value` mediumtext NOT NULL COMMENT 'API ILL property value', |
3299 |
`readonly` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Is this attribute read only', |
3300 |
`readonly` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Is this attribute read only', |
3300 |
PRIMARY KEY (`illrequest_id`,`type`(191)), |
3301 |
PRIMARY KEY (`illrequest_id`,`backend`,`type`(191)), |
3301 |
CONSTRAINT `illrequestattributes_ifk` FOREIGN KEY (`illrequest_id`) REFERENCES `illrequests` (`illrequest_id`) ON DELETE CASCADE ON UPDATE CASCADE |
3302 |
CONSTRAINT `illrequestattributes_ifk` FOREIGN KEY (`illrequest_id`) REFERENCES `illrequests` (`illrequest_id`) ON DELETE CASCADE ON UPDATE CASCADE |
3302 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
3303 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
3303 |
/*!40101 SET character_set_client = @saved_cs_client */; |
3304 |
/*!40101 SET character_set_client = @saved_cs_client */; |
3304 |
- |
|
|