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

(-)a/installer/data/mysql/kohastructure.sql (-1 / +2 lines)
Lines 6056-6061 CREATE TABLE `statistics` ( Link Here
6056
  `value` double(16,4) DEFAULT NULL COMMENT 'monetary value associated with the transaction',
6056
  `value` double(16,4) DEFAULT NULL COMMENT 'monetary value associated with the transaction',
6057
  `type` varchar(16) DEFAULT NULL COMMENT 'transaction type (localuse, issue, return, renew, writeoff, payment)',
6057
  `type` varchar(16) DEFAULT NULL COMMENT 'transaction type (localuse, issue, return, renew, writeoff, payment)',
6058
  `other` longtext DEFAULT NULL COMMENT 'used by SIP',
6058
  `other` longtext DEFAULT NULL COMMENT 'used by SIP',
6059
  `illrequest_id` int(11) DEFAULT NULL COMMENT 'foreign key from the illrequests table, links transaction to a specific illrequest',
6059
  `itemnumber` int(11) DEFAULT NULL COMMENT 'foreign key from the items table, links transaction to a specific item',
6060
  `itemnumber` int(11) DEFAULT NULL COMMENT 'foreign key from the items table, links transaction to a specific item',
6060
  `itemtype` varchar(10) DEFAULT NULL COMMENT 'foreign key from the itemtypes table, links transaction to a specific item type',
6061
  `itemtype` varchar(10) DEFAULT NULL COMMENT 'foreign key from the itemtypes table, links transaction to a specific item type',
6061
  `location` varchar(80) DEFAULT NULL COMMENT 'authorized value for the shelving location for this item (MARC21 952$c)',
6062
  `location` varchar(80) DEFAULT NULL COMMENT 'authorized value for the shelving location for this item (MARC21 952$c)',
Lines 6066-6071 CREATE TABLE `statistics` ( Link Here
6066
  KEY `timeidx` (`datetime`),
6067
  KEY `timeidx` (`datetime`),
6067
  KEY `branch_idx` (`branch`),
6068
  KEY `branch_idx` (`branch`),
6068
  KEY `type_idx` (`type`),
6069
  KEY `type_idx` (`type`),
6070
  KEY `illrequest_idx` (`illrequest_id`),
6069
  KEY `itemnumber_idx` (`itemnumber`),
6071
  KEY `itemnumber_idx` (`itemnumber`),
6070
  KEY `itemtype_idx` (`itemtype`),
6072
  KEY `itemtype_idx` (`itemtype`),
6071
  KEY `borrowernumber_idx` (`borrowernumber`),
6073
  KEY `borrowernumber_idx` (`borrowernumber`),
6072
- 

Return to bug 37901