From 1fcfc34c2e3ca0e1a8a04b354fc6f9616b7ac8e7 Mon Sep 17 00:00:00 2001 From: Nicole Date: Thu, 5 Mar 2015 05:55:28 -0800 Subject: [PATCH] [PASSED QA] Bug 10703: Update stats table documentation This patch updates the DB documentation for the statistics table. To test review the file and cofirm that documentation is there Signed-off-by: Dobrica Pavlinusic Signed-off-by: Brendan Gallagher Signed-off-by: Jonathan Druart Signed-off-by: Katrin Fischer --- installer/data/mysql/kohastructure.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 70b3a09..e2c2be0 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -2009,15 +2009,15 @@ DROP TABLE IF EXISTS `statistics`; CREATE TABLE `statistics` ( -- information related to transactions (circulation and fines) in Koha `datetime` datetime default NULL, -- date and time of the transaction `branch` varchar(10) default NULL, -- foreign key, branch where the transaction occurred - `proccode` varchar(4) default NULL, -- proceedure code + `proccode` varchar(4) default NULL, -- type of procedure used when making payments (does not appear in the code) `value` double(16,4) default NULL, -- monetary value associated with the transaction `type` varchar(16) default NULL, -- transaction type (locause, issue, return, renew, writeoff, payment, Credit*) - `other` mediumtext, - `usercode` varchar(10) default NULL, + `other` mediumtext, -- used by SIP + `usercode` varchar(10) default NULL, -- unused in Koha `itemnumber` int(11) default NULL, -- foreign key from the items table, links transaction to a specific item `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, + `associatedborrower` int(11) default NULL, -- unused in Koha `ccode` varchar(10) default NULL, -- foreign key from the items table, links transaction to a specific collection code KEY `timeidx` (`datetime`), KEY `branch_idx` (`branch`), -- 1.9.1