From f56bbeb6238721e3c0821e3b2936086c1fd504e7 Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Mon, 2 Jul 2012 09:04:06 -0400 Subject: [PATCH] Bugfix 4118 - Add Collection Code to Statistics Table - Fix DB Update --- installer/data/mysql/updatedatabase.pl | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index d8dd4d7..43beec6 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -5454,13 +5454,13 @@ if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { $DBversion = '3.09.00.XXX'; if (C4::Context->preference("Version") < TransformToNum($DBversion)) { - $dbh->do("ALTER TABLE `statistics` ADD `ccode` VARCHAR( 80 ) NULL ;"); + $dbh->do("ALTER TABLE statistics ADD COLUMN ccode VARCHAR ( 10 ) NULL AFTER associatedborrower"); $dbh->do("UPDATE statistics SET statistics.ccode = ( SELECT items.ccode FROM items WHERE statistics.itemnumber = items.itemnumber )"); $dbh->do("UPDATE statistics SET statistics.ccode = ( SELECT deleteditems.ccode FROM deleteditems WHERE statistics.itemnumber = deleteditems.itemnumber ) WHERE statistics.ccode IS NULL"); - print "Upgrade done ( Added Category Code to Statistics table. )\n"; + print "Upgrade done ( Added Collection Code to Statistics table. )\n"; SetVersion ($DBversion); } -- 1.7.2.5