@@ -, +, @@ library --- installer/data/mysql/atomicupdate/bug_36120.pl | 4 ++++ 1 file changed, 4 insertions(+) --- a/installer/data/mysql/atomicupdate/bug_36120.pl +++ a/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 } + ); } }, }; --