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

(-)a/installer/data/mysql/kohastructure.sql (-5 / +4 lines)
Lines 2009-2023 DROP TABLE IF EXISTS `statistics`; Link Here
2009
CREATE TABLE `statistics` ( -- information related to transactions (circulation and fines) in Koha
2009
CREATE TABLE `statistics` ( -- information related to transactions (circulation and fines) in Koha
2010
  `datetime` datetime default NULL, -- date and time of the transaction
2010
  `datetime` datetime default NULL, -- date and time of the transaction
2011
  `branch` varchar(10) default NULL, -- foreign key, branch where the transaction occurred
2011
  `branch` varchar(10) default NULL, -- foreign key, branch where the transaction occurred
2012
  `proccode` varchar(4) default NULL, -- proceedure code 
2012
  `proccode` varchar(4) default NULL, -- type of procedure used when making payments (does not appear in the code)
2013
  `value` double(16,4) default NULL, -- monetary value associated with the transaction
2013
  `value` double(16,4) default NULL, -- monetary value associated with the transaction
2014
  `type` varchar(16) default NULL, -- transaction type (locause, issue, return, renew, writeoff, payment, Credit*)
2014
  `type` varchar(16) default NULL, -- transaction type (locause, issue, return, renew, writeoff, payment, Credit*)
2015
  `other` mediumtext,
2015
  `other` mediumtext, -- used by SIP
2016
  `usercode` varchar(10) default NULL,
2016
  `usercode` varchar(10) default NULL, -- unused in Koha
2017
  `itemnumber` int(11) default NULL, -- foreign key from the items table, links transaction to a specific item
2017
  `itemnumber` int(11) default NULL, -- foreign key from the items table, links transaction to a specific item
2018
  `itemtype` varchar(10) default NULL, -- foreign key from the itemtypes table, links transaction to a specific item type
2018
  `itemtype` varchar(10) default NULL, -- foreign key from the itemtypes table, links transaction to a specific item type
2019
  `borrowernumber` int(11) default NULL, -- foreign key from the borrowers table, links transaction to a specific borrower
2019
  `borrowernumber` int(11) default NULL, -- foreign key from the borrowers table, links transaction to a specific borrower
2020
  `associatedborrower` int(11) default NULL,
2020
  `associatedborrower` int(11) default NULL, -- unused in Koha
2021
  `ccode` varchar(10) default NULL, -- foreign key from the items table, links transaction to a specific collection code
2021
  `ccode` varchar(10) default NULL, -- foreign key from the items table, links transaction to a specific collection code
2022
  KEY `timeidx` (`datetime`),
2022
  KEY `timeidx` (`datetime`),
2023
  KEY `branch_idx` (`branch`),
2023
  KEY `branch_idx` (`branch`),
2024
- 

Return to bug 10703