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