Attachment 12792 Details for Bug 4118 – Bug 4118: Follow up: Add ccode to kohastructure for stats

[patch] Bug 4118: Follow up: Add ccode to kohastructure for stats

Bug-4118-Follow-up-Add-ccode-to-kohastructure-for-.patch (text/plain), 1.27 KB, created by Nicole C. Engard on 2012-10-12 15:08:00 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Nicole C. Engard

Created: 2012-10-12 15:08:00 UTC

Size: 1.27 KB

patch

obsolete

>From a014945f9832d46b920915540f6fe8327990ee64 Mon Sep 17 00:00:00 2001
>From: Nicole C. Engard <nengard@bywatersolutions.com>
>Date: Thu, 11 Oct 2012 20:45:31 -0400
>Subject: [PATCH] Bug 4118: Follow up: Add ccode to kohastructure for stats
>
>CCode was added to the statistics table in this bug, but
>was not added to kohastructure.sql. This patch adds it
>with comment to the kohastructure.
>---
> installer/data/mysql/kohastructure.sql |    1 +
> 1 files changed, 1 insertions(+), 0 deletions(-)
>
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index 5f6739f..29ee782 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -1848,6 +1848,7 @@ CREATE TABLE `statistics` ( -- information related to transactions (circulation
>   `itemtype` varchar(10) default NULL, -- foreign key from the itemtypes table, links transaction to a specific item type
>   `borrowernumber` int(11) default NULL, -- foreign key from the borrowers table, links transaction to a specific borrower
>   `associatedborrower` int(11) default NULL,
>+  `ccode` int(11) default NULL, -- foreign key from the items table, links transaction to a specific collection code
>   KEY `timeidx` (`datetime`)
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
> 
>-- 
>1.7.2.3

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