Bugzilla – Attachment 187803 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: atomicupdate
Bug-40517-atomicupdate.patch (text/plain), 1.86 KB, created by
Pedro Amorim
on 2025-10-13 08:44:05 UTC
(
hide
)
Description:
Bug 40517: atomicupdate
Filename:
MIME Type:
Creator:
Pedro Amorim
Created:
2025-10-13 08:44:05 UTC
Size:
1.86 KB
patch
obsolete
>From 59aeb0b46861ff25f44308398b09ed8e83da1f66 Mon Sep 17 00:00:00 2001 >From: Pedro Amorim <pedro.amorim@openfifth.co.uk> >Date: Mon, 13 Oct 2025 08:39:54 +0000 >Subject: [PATCH] Bug 40517: atomicupdate > >--- > .../bug_40517_-_hold_group_table_updates.pl | 31 +++++++++++++++++++ > 1 file changed, 31 insertions(+) > create mode 100755 installer/data/mysql/atomicupdate/bug_40517_-_hold_group_table_updates.pl > >diff --git a/installer/data/mysql/atomicupdate/bug_40517_-_hold_group_table_updates.pl b/installer/data/mysql/atomicupdate/bug_40517_-_hold_group_table_updates.pl >new file mode 100755 >index 00000000000..e520c378a40 >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_40517_-_hold_group_table_updates.pl >@@ -0,0 +1,31 @@ >+use Modern::Perl; >+use Koha::Installer::Output qw(say_warning say_success say_info); >+ >+return { >+ bug_number => "40517", >+ description => "Add 'borrower' column to hold_groups", >+ up => sub { >+ my ($args) = @_; >+ my ( $dbh, $out ) = @$args{qw(dbh out)}; >+ >+ unless ( column_exists( 'hold_groups', 'borrowernumber' ) ) { >+ $dbh->do( >+ q{ALTER TABLE hold_groups ADD COLUMN borrowernumber int(11) DEFAULT NULL COMMENT 'foreign key, linking this to the borrowers table' AFTER hold_group_id} >+ ); >+ $dbh->do( >+ q{ >+ ALTER TABLE hold_groups ADD KEY `hold_groups_borrowernumber` (`borrowernumber`) >+ } >+ ); >+ $dbh->do( >+ q{ >+ ALTER TABLE hold_groups ADD CONSTRAINT hold_groups_ibfk_1 >+ FOREIGN KEY(`borrowernumber`) >+ REFERENCES `borrowers` (`borrowernumber`) >+ ON DELETE CASCADE; >+ } >+ ); >+ say_success( $out, "Added column 'borrowernumber' to hold_groups" ); >+ } >+ }, >+}; >-- >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