Bugzilla – Attachment 36641 Details for
Bug 10703
add/update database documentation
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 10703: Update stats table documentation
Bug-10703-Update-stats-table-documentation.patch (text/plain), 2.26 KB, created by
Brendan Gallagher
on 2015-03-06 08:55:39 UTC
(
hide
)
Description:
Bug 10703: Update stats table documentation
Filename:
MIME Type:
Creator:
Brendan Gallagher
Created:
2015-03-06 08:55:39 UTC
Size:
2.26 KB
patch
obsolete
>From b17c5f874378c7aca4e32a59d3b5830176f9ad06 Mon Sep 17 00:00:00 2001 >From: Nicole <nicole@bywatersolutions.com> >Date: Thu, 5 Mar 2015 05:55:28 -0800 >Subject: [PATCH] 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 <dpavlin@rot13.org> > >Signed-off-by: Brendan Gallagher <brendan@bywatersolutions.com> >--- > 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 e19a562..e30ae7b 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -2007,15 +2007,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.7.10.4
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 10703
:
20208
|
20209
|
20210
|
20248
|
20249
|
20250
|
20415
|
20416
|
20417
|
36582
|
36602
|
36603
|
36604
|
36605
|
36640
|
36641
|
36642
|
36648
|
36649
|
36650
|
36660
|
36669
|
36670
|
36910
|
36911
|
36912
|
36913