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 |
- |
|
|