View | Details | Raw Unified | Return to bug 11573
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_11573.perl (-1 / +23 lines)
Lines 1-6 Link Here
1
$DBversion = 'XXX';    # will be replaced by the RM
1
$DBversion = 'XXX';    # will be replaced by the RM
2
if ( CheckVersion($DBversion) ) {
2
if ( CheckVersion($DBversion) ) {
3
3
4
    $dbh->do(qq{
5
        UPDATE
6
          accountlines
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
4
    $dbh->do(qq{
27
    $dbh->do(qq{
5
        UPDATE
28
        UPDATE
6
          accountlines
29
          accountlines
7
- 

Return to bug 11573