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

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

Bug-21017-Fix-database-documentation-for-statistic.patch (text/plain), 1.60 KB, created by Maryse Simard on 2018-07-27 20:50:00 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Maryse Simard

Created: 2018-07-27 20:50:00 UTC

Size: 1.60 KB

patch

obsolete

>From 750251299f249ec3a65dee21e3c1e5946af43763 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 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
>
>Signed-off-by: Maryse Simard <maryse.simard@inlibro.com>
>---
> 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 206959f..3249c25 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.7.4

Actions: View | Diff | Splinter Review

Attachments on bug 21077: 76966 | 77320 | 77334