View | Details | Raw Unified | Return to bug 33970
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-2 / +2 lines)
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
- 

Return to bug 33970