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

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

Return to bug 33970