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

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

Return to bug 37901