Bugzilla – Attachment 181013 Details for
Bug 37901
Add ILL pseudonymization
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 37901: Add 'illrequest_id' column to statistics
Bug-37901-Add-illrequestid-column-to-statistics.patch (text/plain), 1.63 KB, created by
Pedro Amorim
on 2025-04-16 15:43:48 UTC
(
hide
)
Description:
Bug 37901: Add 'illrequest_id' column to statistics
Filename:
MIME Type:
Creator:
Pedro Amorim
Created:
2025-04-16 15:43:48 UTC
Size:
1.63 KB
patch
obsolete
>From ea2187bcbc730934b7fa649ecff9840d9f06a5f9 Mon Sep 17 00:00:00 2001 >From: Pedro Amorim <pedro.amorim@ptfs-europe.com> >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
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 37901
:
178356
|
178956
|
178957
|
178958
|
178959
|
178960
|
178961
|
178962
|
178963
|
178964
|
178965
|
178966
|
178967
|
178968
|
178980
|
178981
|
178982
|
178983
|
178984
|
178985
|
178986
|
178987
|
178988
|
178989
|
178990
|
178991
|
178992
|
181008
|
181009
|
181010
|
181011
|
181012
| 181013 |
181014
|
181015
|
181016
|
181017
|
181018
|
181019
|
181020