Bugzilla – Attachment 157433 Details for
Bug 33970
We need a "backend" column in "illrequestattributes" table
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 33970: Update DB
Bug-33970-Update-DB.patch (text/plain), 1.50 KB, created by
Martin Renvoize
on 2023-10-19 13:40:16 UTC
(
hide
)
Description:
Bug 33970: Update DB
Filename:
MIME Type:
Creator:
Martin Renvoize
Created:
2023-10-19 13:40:16 UTC
Size:
1.50 KB
patch
obsolete
>From 5ff308e5862f0361a71ba28433f9324cc11b7de6 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 > >Signed-off-by: Chris Walton <C.J.Walton@lboro.ac.uk> >Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com> >--- > 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 022dc50533b..78fb9f13fc2 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -3294,10 +3294,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.41.0
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 33970
:
152250
|
152251
|
152252
|
153263
|
153264
|
153265
|
154903
| 157433 |
157434
|
157435
|
157436
|
157437