From 5d8695d9e9698a9ff53a2639ab39ba0c2331975f Mon Sep 17 00:00:00 2001 From: Pedro Amorim Date: Fri, 9 Jun 2023 14:14:05 +0000 Subject: [PATCH] Bug 33970: update DB Signed-off-by: Chris Walton --- installer/data/mysql/kohastructure.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 8c05d11cd9..9a0a12d513 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -3275,10 +3275,11 @@ DROP TABLE IF EXISTS `illrequestattributes`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `illrequestattributes` ( `illrequest_id` bigint(20) unsigned NOT NULL COMMENT 'ILL request number', + `backend` varchar(80) NOT NULL COMMENT 'API ILL backend name', `type` varchar(200) NOT NULL COMMENT 'API ILL property name', `value` mediumtext NOT NULL COMMENT 'API ILL property value', `readonly` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Is this attribute read only', - PRIMARY KEY (`illrequest_id`,`type`(191)), + PRIMARY KEY (`illrequest_id`,`backend`,`type`(191)), CONSTRAINT `illrequestattributes_ifk` FOREIGN KEY (`illrequest_id`) REFERENCES `illrequests` (`illrequest_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- 2.30.2