Lines 5-10
if ( CheckVersion($DBversion) ) {
Link Here
|
5 |
UPDATE |
5 |
UPDATE |
6 |
accountlines |
6 |
accountlines |
7 |
SET |
7 |
SET |
|
|
8 |
accounttype = 'RENT_DAILY_RENEW' |
9 |
WHERE |
10 |
accounttype = 'Rent' |
11 |
AND |
12 |
description LIKE 'Renewal of Daily Rental Item%'; |
13 |
}); |
14 |
|
15 |
$dbh->do(qq{ |
16 |
UPDATE |
17 |
accountlines |
18 |
SET |
19 |
accounttype = 'RENT_DAILY' |
20 |
WHERE |
21 |
accounttype = 'Rent' |
22 |
AND |
23 |
description LIKE 'Daily rental'; |
24 |
}); |
25 |
|
26 |
|
27 |
$dbh->do(qq{ |
28 |
UPDATE |
29 |
accountlines |
30 |
SET |
8 |
accounttype = 'RENT_RENEW' |
31 |
accounttype = 'RENT_RENEW' |
9 |
WHERE |
32 |
WHERE |
10 |
accounttype = 'Rent' |
33 |
accounttype = 'Rent' |
11 |
- |
|
|