Attachment 77334 Details for Bug 21077 – Bug 21077: Fix database documentation for statistics.type

[patch] Bug 21077: Fix database documentation for statistics.type

Bug-21077-Fix-database-documentation-for-statistic.patch (text/plain), 1.57 KB, created by Jonathan Druart on 2018-07-31 15:02:12 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2018-07-31 15:02:12 UTC

Size: 1.57 KB

patch

obsolete

>From 3c1f6fbe80689f84982df2f08e0284cb78658fdf Mon Sep 17 00:00:00 2001
>From: Katrin Fischer <katrin.fischer.83@web.de>
>Date: Sun, 15 Jul 2018 19:27:03 +0200
>Subject: [PATCH] Bug 21077: Fix database documentation for statistics.type
>
>There's a typo for 'locause', this should be 'localuse'.
>Also, 'Credit*' is never used.
>
>Signed-off-by: Maryse Simard <maryse.simard@inlibro.com>
>
>Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>---
> 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 10b90bd15b..92b86350a1 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -1996,7 +1996,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.11.0

Actions: View | Diff | Splinter Review

Attachments on bug 21077: 76966 | 77320 | 77334