From 69100cfaab143e2bd2939125b6bf1c85e9da72e3 Mon Sep 17 00:00:00 2001
From: Kyle M Hall <kyle@bywatersolutions.com>
Date: Mon, 2 Jul 2012 09:04:06 -0400
Subject: [PATCH] Bugfix 4118 - Add Collection Code to Statistics Table - Fix
 DB Update

Signed-off-by: Jonathan Druart <jonathan.druart@biblibre.com>
---
 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 dcda86f..d1f2311 100755
--- a/installer/data/mysql/updatedatabase.pl
+++ b/installer/data/mysql/updatedatabase.pl
@@ -5538,13 +5538,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.7.3