Bugzilla – Attachment 187914 Details for
Bug 40504
ILL requests should have ability to assign staff to manage
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 40504: atomicupdate
Bug-40504-atomicupdate.patch (text/plain), 1.55 KB, created by
Pedro Amorim
on 2025-10-15 13:32:50 UTC
(
hide
)
Description:
Bug 40504: atomicupdate
Filename:
MIME Type:
Creator:
Pedro Amorim
Created:
2025-10-15 13:32:50 UTC
Size:
1.55 KB
patch
obsolete
>From 8bbd4e763bb1dd05454fed5364be341c2d73219c Mon Sep 17 00:00:00 2001 >From: Pedro Amorim <pedro.amorim@openfifth.co.uk> >Date: Wed, 15 Oct 2025 11:12:44 +0000 >Subject: [PATCH] Bug 40504: atomicupdate > >--- > .../data/mysql/atomicupdate/bug_40504.pl | 23 +++++++++++++++++++ > 1 file changed, 23 insertions(+) > create mode 100755 installer/data/mysql/atomicupdate/bug_40504.pl > >diff --git a/installer/data/mysql/atomicupdate/bug_40504.pl b/installer/data/mysql/atomicupdate/bug_40504.pl >new file mode 100755 >index 00000000000..6b4cb3f42fb >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_40504.pl >@@ -0,0 +1,23 @@ >+use Modern::Perl; >+use Koha::Installer::Output qw(say_warning say_success say_info); >+ >+return { >+ bug_number => "40504", >+ description => "Add managedby column to illrequests table", >+ up => sub { >+ my ($args) = @_; >+ my ( $dbh, $out ) = @$args{qw(dbh out)}; >+ >+ unless ( column_exists( 'illrequests', 'managedby' ) ) { >+ $dbh->do( >+ q{ALTER TABLE illrequests ADD COLUMN managedby int(11) DEFAULT NULL COMMENT ''Staff member manager of request'' AFTER borrowernumber} >+ ); >+ $dbh->do(q{ALTER TABLE reserves ADD KEY illrequests_manfk (managedby)}); >+ $dbh->do( >+ q{ALTER TABLE reserves ADD CONSTRAINT illrequests_manfk FOREIGN KEY (managedby) REFERENCES borrowers (borrowernumber) ON DELETE SET NULL ON UPDATE CASCADE} >+ ); >+ >+ say_success( $out, "Added column 'illrequests.managedby'" ); >+ } >+ }, >+}; >-- >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 40504
:
187906
|
187907
|
187908
|
187909
|
187910
|
187911
|
187912
|
187913
|
187914
|
187915
|
188365
|
188563
|
188565
|
188566
|
188567
|
188568
|
188569
|
188570
|
188571
|
188572
|
188573
|
188574
|
188624
|
188625
|
188935
|
188936