From 4a9993bf2722062eca8e667a1d0f1916b3b5f0f9 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 4d0b8ff20d3..10cd2905a22 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -6057,6 +6057,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)', @@ -6067,6 +6068,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