From b0b927f4f21e3ad479faa7edacd6c83bc1e6255a 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 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 Signed-off-by: Paul Poulain --- installer/data/mysql/kohastructure.sql | 1 + 1 file changed, 1 insertion(+) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 1dc17ba764..4fa0332fb8 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -1826,6 +1826,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; -- 2.39.2