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

(-)a/installer/data/mysql/atomicupdate/bug_11573.perl (-1 / +23 lines)
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
- 

Return to bug 11573