Lines 9628-9633
if ( CheckVersion($DBversion) ) {
Link Here
|
9628 |
SetVersion($DBversion); |
9628 |
SetVersion($DBversion); |
9629 |
} |
9629 |
} |
9630 |
|
9630 |
|
|
|
9631 |
$DBversion = "3.19.00.XXX"; |
9632 |
if ( CheckVersion($DBversion) ) { |
9633 |
$dbh->do(q{ |
9634 |
UPDATE statistics |
9635 |
SET itemtype = |
9636 |
( |
9637 |
SELECT u.itype FROM |
9638 |
( |
9639 |
SELECT itype,itemnumber FROM items |
9640 |
UNION ALL |
9641 |
SELECT itype,itemnumber FROM deleteditems |
9642 |
) u |
9643 |
WHERE statistics.itemnumber = u.itemnumber |
9644 |
LIMIT 1 |
9645 |
) |
9646 |
WHERE type IN ('localuse', 'return') |
9647 |
}); |
9648 |
print "upgrade to $DBversion done (Bug 9351 - item type not recorded correctly in statistics for returns and some local use)\n"; |
9649 |
SetVersion ($DBversion); |
9650 |
} |
9651 |
|
9631 |
=head1 FUNCTIONS |
9652 |
=head1 FUNCTIONS |
9632 |
|
9653 |
|
9633 |
=head2 TableExists($table) |
9654 |
=head2 TableExists($table) |
9634 |
- |
|
|