Attachment 12793 Details for Bug 4118 – [SIGNED-OFF] Bug 4118: Follow up: Add ccode to kohastructure for stats

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

Bug-4118-Follow-up-Add-ccode-to-kohastructure-for-.patch (text/plain), 1.36 KB, created by Kyle M Hall (khall) on 2012-10-12 15:09:27 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Kyle M Hall (khall)

Created: 2012-10-12 15:09:27 UTC

Size: 1.36 KB

patch

obsolete

>From 4dbf5ed168ed7ec2ef400f30bed4828fd22079b8 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
>Content-Type: text/plain; charset="utf-8"
>
>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.
>
>Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
>---
> 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.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