From 9d9a8ea891a3e8c0b05c85a9fc35cd6b1a9f1636 Mon Sep 17 00:00:00 2001 From: Katrin Fischer Date: Sun, 15 Jul 2018 19:27:03 +0200 Subject: [PATCH] Bug 21017: Fix database documentation for statistics.type There's a typo for 'locause', this should be 'localuse'. Also, 'Credit*' is never used. https://bugs.koha-community.org/show_bug.cgi?id=20177 https://bugs.koha-community.org/show_bug.cgi?id=21077 --- installer/data/mysql/kohastructure.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 20b1a5716e..17d37a8142 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -1994,7 +1994,7 @@ CREATE TABLE `statistics` ( -- information related to transactions (circulation `branch` varchar(10) default NULL, -- foreign key, branch where the transaction occurred `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*) + `type` varchar(16) default NULL, -- transaction type (localuse, issue, return, renew, writeoff, payment) `other` LONGTEXT, -- 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 -- 2.17.1