From 3bf824c788c820d7218e9c6f054bd851838e881e Mon Sep 17 00:00:00 2001 From: Martin Renvoize Date: Fri, 26 Jul 2019 12:52:44 +0100 Subject: [PATCH] Bug 11573: (follow-up) Handle daily rental in db update Signed-off-by: Nick Clemens --- installer/data/mysql/atomicupdate/bug_11573.perl | 23 +++++++++++++++++++++++ 1 file changed, 23 insertions(+) diff --git a/installer/data/mysql/atomicupdate/bug_11573.perl b/installer/data/mysql/atomicupdate/bug_11573.perl index 93a002dca4..a09d1c4922 100644 --- a/installer/data/mysql/atomicupdate/bug_11573.perl +++ b/installer/data/mysql/atomicupdate/bug_11573.perl @@ -5,6 +5,29 @@ if ( CheckVersion($DBversion) ) { UPDATE accountlines SET + accounttype = 'RENT_DAILY_RENEW' + WHERE + accounttype = 'Rent' + AND + description LIKE 'Renewal of Daily Rental Item%'; + }); + + $dbh->do(qq{ + UPDATE + accountlines + SET + accounttype = 'RENT_DAILY' + WHERE + accounttype = 'Rent' + AND + description LIKE 'Daily rental'; + }); + + + $dbh->do(qq{ + UPDATE + accountlines + SET accounttype = 'RENT_RENEW' WHERE accounttype = 'Rent' -- 2.11.0