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

(-)a/installer/data/mysql/updatedatabase.pl (-1 / +23 lines)
Lines 10462-10467 if ( CheckVersion($DBversion) ) { Link Here
10462
    SetVersion ($DBversion);
10462
    SetVersion ($DBversion);
10463
}
10463
}
10464
10464
10465
10466
$DBversion = "3.21.00.XXX";
10467
if ( CheckVersion($DBversion) ) {
10468
    $dbh->do(q{
10469
        UPDATE statistics
10470
        SET itemtype =
10471
        (
10472
            SELECT u.itype FROM
10473
            (
10474
                SELECT itype,itemnumber FROM items
10475
                UNION ALL
10476
                SELECT itype,itemnumber FROM deleteditems
10477
            ) u
10478
            WHERE statistics.itemnumber = u.itemnumber
10479
            LIMIT 1
10480
        )
10481
        WHERE type IN ('localuse', 'return')
10482
    });
10483
    print "upgrade to $DBversion done (Bug 9351 - item type not recorded correctly in statistics for returns and some local use)\n";
10484
    SetVersion ($DBversion);
10485
}
10486
10487
10465
# DEVELOPER PROCESS, search for anything to execute in the db_update directory
10488
# DEVELOPER PROCESS, search for anything to execute in the db_update directory
10466
# SEE bug 13068
10489
# SEE bug 13068
10467
# if there is anything in the atomicupdate, read and execute it.
10490
# if there is anything in the atomicupdate, read and execute it.
10468
- 

Return to bug 9351