Bugzilla – Attachment 153263 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.44 KB, created by
Pedro Amorim
on 2023-07-10 09:30:11 UTC
(
hide
)
Description:
Bug 33970: update DB
Filename:
MIME Type:
Creator:
Pedro Amorim
Created:
2023-07-10 09:30:11 UTC
Size:
1.44 KB
patch
obsolete
>From 5d8695d9e9698a9ff53a2639ab39ba0c2331975f 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> >--- > 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
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