From 4dbf5ed168ed7ec2ef400f30bed4828fd22079b8 Mon Sep 17 00:00:00 2001 From: Nicole C. Engard 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 --- 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