Bugzilla – Attachment 36911 Details for
Bug 10703
add/update database documentation
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
[PASSED QA] Bug 10703: Update stats table documentation
PASSED-QA-Bug-10703-Update-stats-table-documentati.patch (text/plain), 2.38 KB, created by
Katrin Fischer
on 2015-03-15 23:43:01 UTC
(
hide
)
Description:
[PASSED QA] Bug 10703: Update stats table documentation
Filename:
MIME Type:
Creator:
Katrin Fischer
Created:
2015-03-15 23:43:01 UTC
Size:
2.38 KB
patch
obsolete
>From 1fcfc34c2e3ca0e1a8a04b354fc6f9616b7ac8e7 Mon Sep 17 00:00:00 2001 >From: Nicole <nicole@bywatersolutions.com> >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 <dpavlin@rot13.org> > >Signed-off-by: Brendan Gallagher <brendan@bywatersolutions.com> > >Signed-off-by: Jonathan Druart <jonathan.druart@biblibre.com> > >Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de> >--- > 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
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