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

(-)a/installer/data/mysql/updatedatabase.pl (-1 / +21 lines)
Lines 9656-9661 if(CheckVersion($DBversion)) { Link Here
9656
    SetVersion($DBversion);
9656
    SetVersion($DBversion);
9657
}
9657
}
9658
9658
9659
$DBversion = "3.19.00.XXX";
9660
if ( CheckVersion($DBversion) ) {
9661
    $dbh->do(q{
9662
        UPDATE statistics
9663
        SET itemtype =
9664
        (
9665
            SELECT u.itype FROM
9666
            (
9667
                SELECT itype,itemnumber FROM items
9668
                UNION ALL
9669
                SELECT itype,itemnumber FROM deleteditems
9670
            ) u
9671
            WHERE statistics.itemnumber = u.itemnumber
9672
            LIMIT 1
9673
        )
9674
        WHERE type IN ('localuse', 'return')
9675
    });
9676
    print "upgrade to $DBversion done (Bug 9351 - item type not recorded correctly in statistics for returns and some local use)\n";
9677
    SetVersion ($DBversion);
9678
}
9679
9659
=head1 FUNCTIONS
9680
=head1 FUNCTIONS
9660
9681
9661
=head2 TableExists($table)
9682
=head2 TableExists($table)
9662
- 

Return to bug 9351