|
Lines 5538-5550
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
Link Here
|
| 5538 |
|
5538 |
|
| 5539 |
$DBversion = '3.09.00.XXX'; |
5539 |
$DBversion = '3.09.00.XXX'; |
| 5540 |
if (C4::Context->preference("Version") < TransformToNum($DBversion)) { |
5540 |
if (C4::Context->preference("Version") < TransformToNum($DBversion)) { |
| 5541 |
$dbh->do("ALTER TABLE `statistics` ADD `ccode` VARCHAR( 80 ) NULL ;"); |
5541 |
$dbh->do("ALTER TABLE statistics ADD COLUMN ccode VARCHAR ( 10 ) NULL AFTER associatedborrower"); |
| 5542 |
$dbh->do("UPDATE statistics SET statistics.ccode = ( SELECT items.ccode FROM items WHERE statistics.itemnumber = items.itemnumber )"); |
5542 |
$dbh->do("UPDATE statistics SET statistics.ccode = ( SELECT items.ccode FROM items WHERE statistics.itemnumber = items.itemnumber )"); |
| 5543 |
$dbh->do("UPDATE statistics SET statistics.ccode = ( |
5543 |
$dbh->do("UPDATE statistics SET statistics.ccode = ( |
| 5544 |
SELECT deleteditems.ccode FROM deleteditems |
5544 |
SELECT deleteditems.ccode FROM deleteditems |
| 5545 |
WHERE statistics.itemnumber = deleteditems.itemnumber |
5545 |
WHERE statistics.itemnumber = deleteditems.itemnumber |
| 5546 |
) WHERE statistics.ccode IS NULL"); |
5546 |
) WHERE statistics.ccode IS NULL"); |
| 5547 |
print "Upgrade done ( Added Category Code to Statistics table. )\n"; |
5547 |
print "Upgrade done ( Added Collection Code to Statistics table. )\n"; |
| 5548 |
SetVersion ($DBversion); |
5548 |
SetVersion ($DBversion); |
| 5549 |
} |
5549 |
} |
| 5550 |
|
5550 |
|
| 5551 |
- |
|
|