|
Lines 10462-10467
if ( CheckVersion($DBversion) ) {
Link Here
|
| 10462 |
SetVersion ($DBversion); |
10462 |
SetVersion ($DBversion); |
| 10463 |
} |
10463 |
} |
| 10464 |
|
10464 |
|
|
|
10465 |
|
| 10466 |
$DBversion = "3.21.00.XXX"; |
| 10467 |
if ( CheckVersion($DBversion) ) { |
| 10468 |
$dbh->do(q{ |
| 10469 |
UPDATE statistics |
| 10470 |
SET itemtype = |
| 10471 |
( |
| 10472 |
SELECT u.itype FROM |
| 10473 |
( |
| 10474 |
SELECT itype,itemnumber FROM items |
| 10475 |
UNION ALL |
| 10476 |
SELECT itype,itemnumber FROM deleteditems |
| 10477 |
) u |
| 10478 |
WHERE statistics.itemnumber = u.itemnumber |
| 10479 |
LIMIT 1 |
| 10480 |
) |
| 10481 |
WHERE type IN ('localuse', 'return') |
| 10482 |
}); |
| 10483 |
print "upgrade to $DBversion done (Bug 9351 - item type not recorded correctly in statistics for returns and some local use)\n"; |
| 10484 |
SetVersion ($DBversion); |
| 10485 |
} |
| 10486 |
|
| 10487 |
|
| 10465 |
# DEVELOPER PROCESS, search for anything to execute in the db_update directory |
10488 |
# DEVELOPER PROCESS, search for anything to execute in the db_update directory |
| 10466 |
# SEE bug 13068 |
10489 |
# SEE bug 13068 |
| 10467 |
# if there is anything in the atomicupdate, read and execute it. |
10490 |
# if there is anything in the atomicupdate, read and execute it. |
| 10468 |
- |
|
|