Bugzilla – Attachment 187802 Details for
Bug 40517
Allow grouping existing holds
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 40517: DB changes
Bug-40517-DB-changes.patch (text/plain), 1.13 KB, created by
Pedro Amorim
on 2025-10-13 08:44:01 UTC
(
hide
)
Description:
Bug 40517: DB changes
Filename:
MIME Type:
Creator:
Pedro Amorim
Created:
2025-10-13 08:44:01 UTC
Size:
1.13 KB
patch
obsolete
>From fee45a12dee88fe8cc0aa60b1c3cacfbcb794014 Mon Sep 17 00:00:00 2001 >From: Pedro Amorim <pedro.amorim@openfifth.co.uk> >Date: Mon, 13 Oct 2025 08:39:40 +0000 >Subject: [PATCH] Bug 40517: DB changes > >--- > installer/data/mysql/kohastructure.sql | 3 +++ > 1 file changed, 3 insertions(+) > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index fe7454cfe2f..c6fc8abd9e9 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -3551,6 +3551,9 @@ DROP TABLE IF EXISTS `hold_groups`; > /*!40101 SET character_set_client = utf8mb4 */; > CREATE TABLE `hold_groups` ( > `hold_group_id` int(10) unsigned NOT NULL AUTO_INCREMENT, >+ `borrowernumber` int(11) DEFAULT NULL COMMENT 'foreign key, linking this to the borrowers table', >+ KEY `hold_groups_borrowernumber` (`borrowernumber`), >+ CONSTRAINT `hold_groups_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE, > PRIMARY KEY (`hold_group_id`) > ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; > /*!40101 SET character_set_client = @saved_cs_client */; >-- >2.39.5
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 40517
:
184640
|
184641
|
184642
|
184643
|
184644
|
184645
|
184646
|
184729
|
184732
|
184733
|
184734
|
184735
|
184736
|
184737
|
184738
|
184739
|
185217
|
186672
|
186673
|
186674
|
186675
|
186676
|
186677
|
186678
|
186679
|
186680
|
186745
|
186746
|
186747
|
186748
|
186749
|
186750
|
186751
|
186752
|
186753
|
187789
|
187790
|
187791
|
187792
|
187793
|
187794
|
187795
|
187796
|
187797
|
187801
|
187802
|
187803
|
187804
|
187805
|
187806
|
187807
|
187808
|
187809
|
187810
|
187811
|
187812
|
187965
|
187966
|
187967
|
187968
|
187969
|
187970
|
187971
|
187972
|
187973
|
187974
|
187975
|
187976
|
188293
|
188294
|
188343
|
188422