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

(-)a/installer/data/mysql/updatedatabase.pl (-1 / +21 lines)
Lines 9732-9737 if ( CheckVersion($DBversion) ) { Link Here
9732
    SetVersion($DBversion);
9732
    SetVersion($DBversion);
9733
}
9733
}
9734
9734
9735
$DBversion = "3.19.00.XXX";
9736
if ( CheckVersion($DBversion) ) {
9737
    $dbh->do(q{
9738
        UPDATE statistics
9739
        SET itemtype =
9740
        (
9741
            SELECT u.itype FROM
9742
            (
9743
                SELECT itype,itemnumber FROM items
9744
                UNION ALL
9745
                SELECT itype,itemnumber FROM deleteditems
9746
            ) u
9747
            WHERE statistics.itemnumber = u.itemnumber
9748
            LIMIT 1
9749
        )
9750
        WHERE type IN ('localuse', 'return')
9751
    });
9752
    print "upgrade to $DBversion done (Bug 9351 - item type not recorded correctly in statistics for returns and some local use)\n";
9753
    SetVersion ($DBversion);
9754
}
9755
9735
=head1 FUNCTIONS
9756
=head1 FUNCTIONS
9736
9757
9737
=head2 TableExists($table)
9758
=head2 TableExists($table)
9738
- 

Return to bug 9351