From e44b543c6e8cddc1653b7629b765f286328868b7 Mon Sep 17 00:00:00 2001 From: Martin Renvoize Date: Fri, 8 Mar 2024 16:00:57 +0000 Subject: [PATCH] Bug 36120: Ensure existing bookings are assigned a pickup library Sponsored-by: Cuyahoga County Public Library Signed-off-by: Lisette Scheer Signed-off-by: Kristi Krueger --- installer/data/mysql/atomicupdate/bug_36120.pl | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/installer/data/mysql/atomicupdate/bug_36120.pl b/installer/data/mysql/atomicupdate/bug_36120.pl index fd66b2dae81..02d8186363a 100755 --- a/installer/data/mysql/atomicupdate/bug_36120.pl +++ b/installer/data/mysql/atomicupdate/bug_36120.pl @@ -15,6 +15,10 @@ return { }); say $out "Added column 'bookings.pickup_library_id'"; + + $dbh->do( + q{UPDATE bookings JOIN items ON bookings.item_id = items.itemnumber SET bookings.pickup_library_id = items.homebranch } + ); } }, }; -- 2.44.0