From f01b909c037283d57507fd863dc81b2404e012b4 Mon Sep 17 00:00:00 2001 From: Pedro Amorim Date: Mon, 3 Mar 2025 15:26:16 -0100 Subject: [PATCH] Bug 37901: Add 'illrequest_id' column to statistics Signed-off-by: Jeremy Evans --- installer/data/mysql/kohastructure.sql | 2 ++ 1 file changed, 2 insertions(+) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index e6d18e5ac7b..57effdd3f36 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -6058,6 +6058,7 @@ CREATE TABLE `statistics` ( `value` double(16,4) DEFAULT NULL COMMENT 'monetary value associated with the transaction', `type` varchar(16) DEFAULT NULL COMMENT 'transaction type (localuse, issue, return, renew, writeoff, payment)', `other` longtext DEFAULT NULL COMMENT 'used by SIP', + `illrequest_id` int(11) DEFAULT NULL COMMENT 'foreign key from the illrequests table, links transaction to a specific illrequest', `itemnumber` int(11) DEFAULT NULL COMMENT 'foreign key from the items table, links transaction to a specific item', `itemtype` varchar(10) DEFAULT NULL COMMENT 'foreign key from the itemtypes table, links transaction to a specific item type', `location` varchar(80) DEFAULT NULL COMMENT 'authorized value for the shelving location for this item (MARC21 952$c)', @@ -6068,6 +6069,7 @@ CREATE TABLE `statistics` ( KEY `timeidx` (`datetime`), KEY `branch_idx` (`branch`), KEY `type_idx` (`type`), + KEY `illrequest_idx` (`illrequest_id`), KEY `itemnumber_idx` (`itemnumber`), KEY `itemtype_idx` (`itemtype`), KEY `borrowernumber_idx` (`borrowernumber`), -- 2.39.5