View | Details | Raw Unified | Return to bug 21077
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 1996-2002 CREATE TABLE `statistics` ( -- information related to transactions (circulation Link Here
1996
  `branch` varchar(10) default NULL, -- foreign key, branch where the transaction occurred
1996
  `branch` varchar(10) default NULL, -- foreign key, branch where the transaction occurred
1997
  `proccode` varchar(4) default NULL, -- type of procedure used when making payments (does not appear in the code)
1997
  `proccode` varchar(4) default NULL, -- type of procedure used when making payments (does not appear in the code)
1998
  `value` double(16,4) default NULL, -- monetary value associated with the transaction
1998
  `value` double(16,4) default NULL, -- monetary value associated with the transaction
1999
  `type` varchar(16) default NULL, -- transaction type (locause, issue, return, renew, writeoff, payment, Credit*)
1999
  `type` varchar(16) default NULL, -- transaction type (localuse, issue, return, renew, writeoff, payment)
2000
  `other` LONGTEXT, -- used by SIP
2000
  `other` LONGTEXT, -- used by SIP
2001
  `usercode` varchar(10) default NULL, -- unused in Koha
2001
  `usercode` varchar(10) default NULL, -- unused in Koha
2002
  `itemnumber` int(11) default NULL, -- foreign key from the items table, links transaction to a specific item
2002
  `itemnumber` int(11) default NULL, -- foreign key from the items table, links transaction to a specific item
2003
- 

Return to bug 21077