From 1f9e6402f84e5634c3f8d0c26f9d6a2c5b679751 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 --- 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 b9d9796f44c..2508b4db64f 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -6056,6 +6056,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)', @@ -6066,6 +6067,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