Attachment 152250 Details for Bug 33970 – Bug 33970: update DB

[patch] Bug 33970: update DB

Bug-33970-update-DB.patch (text/plain), 1.38 KB, created by Pedro Amorim on 2023-06-09 14:16:05 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Pedro Amorim

Created: 2023-06-09 14:16:05 UTC

Size: 1.38 KB

patch

obsolete

>From 74ffdedffff1e491c6d073dcbd658da088e64bc7 Mon Sep 17 00:00:00 2001
>From: Pedro Amorim <pedro.amorim@ptfs-europe.com>
>Date: Fri, 9 Jun 2023 14:14:05 +0000
>Subject: [PATCH] Bug 33970: update DB
>
>---
> 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 7e93b6ffc7..25970f145e 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

Actions: View | Diff | Splinter Review

Attachments on bug 33970: 152250 | 152251 | 152252 | 153263 | 153264 | 153265 | 154903 | 157433 | 157434 | 157435 | 157436 | 157437