From cd94e36fd0e410bf73754e112e1e52b7b28fc3e8 Mon Sep 17 00:00:00 2001
From: Martin Renvoize <martin.renvoize@ptfs-europe.com>
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 <lisette.scheer@bywatersolutions.com>
Signed-off-by: Kristi Krueger <kkrueger@cuyahogalibrary.org>
Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
---
 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