Attachment 10605 Details for Bug 4118 – Bugfix 4118 - Add Collection Code to Statistics Table - Fix DB Update

[patch] Bugfix 4118 - Add Collection Code to Statistics Table - Fix DB Update

Bugfix-4118---Add-Collection-Code-to-Statistics-Ta.patch (text/plain), 1.44 KB, created by Kyle M Hall on 2012-07-02 13:05:22 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Kyle M Hall

Created: 2012-07-02 13:05:22 UTC

Size: 1.44 KB

patch

obsolete

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

Actions: View | Diff | Splinter Review

Attachments on bug 4118: 1848 | 1849 | 10164 | 10165 | 10213 | 10214 | 10602 | 10603 | 10604 | 10605 | 10887 | 11322 | 12172 | 12173 | 12792 | 12793 | 12795