@@ -, +, @@ --- .../data/mysql/atomicupdate/bug_11573.perl | 23 +++++++++++++++++++ 1 file changed, 23 insertions(+) --- a/installer/data/mysql/atomicupdate/bug_11573.perl +++ a/installer/data/mysql/atomicupdate/bug_11573.perl @@ -1,6 +1,29 @@ $DBversion = 'XXX'; # will be replaced by the RM if ( CheckVersion($DBversion) ) { + $dbh->do(qq{ + 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 --