From 4effc96d5610e541935d55c918130f5b17dadf89 Mon Sep 17 00:00:00 2001 From: Martin Renvoize Date: Fri, 7 Feb 2025 11:20:21 +0000 Subject: [PATCH] Bug 38924: Add type and timestamp to usage table This allows us to more easily audit what actions incremented the usage and when. We will use this later in display --- installer/data/mysql/atomicupdate/bug_38924-patron_quotas.pl | 4 +++- installer/data/mysql/kohastructure.sql | 3 +++ 2 files changed, 6 insertions(+), 1 deletion(-) diff --git a/installer/data/mysql/atomicupdate/bug_38924-patron_quotas.pl b/installer/data/mysql/atomicupdate/bug_38924-patron_quotas.pl index fb1091ed1d..b1b2d4e3e0 100755 --- a/installer/data/mysql/atomicupdate/bug_38924-patron_quotas.pl +++ b/installer/data/mysql/atomicupdate/bug_38924-patron_quotas.pl @@ -45,10 +45,12 @@ return { `patron_quota_id` int(11) NOT NULL COMMENT 'foreign key linking to patron_quota.id', `issue_id` int(11) DEFAULT NULL COMMENT 'linking to issues.issue_id or old_issues.issue_id', `patron_id` int(11) NOT NULL COMMENT 'foreign key linking to borrowers.borrowernumber', + `type` enum('ISSUE','RENEW') NOT NULL COMMENT 'The type of usage this is', + `creation_date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'the timestamp for when a usage was recorded', PRIMARY KEY (`id`), KEY `patron_quota_usage_ibfk_1` (`patron_quota_id`), - KEY `patron_quota_usage_ibfk_2` (`patron_id`), + KEY `patron_quota_usage_issue_id` (`issue_id`), CONSTRAINT `patron_quota_usage_ibfk_1` FOREIGN KEY (`patron_quota_id`) REFERENCES `patron_quota` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `patron_quota_usage_ibfk_2` FOREIGN KEY (`patron_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index a3df649079..2307e799be 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -6826,9 +6826,12 @@ CREATE TABLE `patron_quota_usage` ( `patron_quota_id` int(11) NOT NULL COMMENT 'foreign key linking to patron_quota.id', `issue_id` int(11) DEFAULT NULL COMMENT 'linking to issues.issue_id or old_issues.issue_id', `patron_id` int(11) NOT NULL COMMENT 'foreign key linking to borrowers.borrowernumber', + `type` enum('ISSUE','RENEW') NOT NULL COMMENT 'The type of usage this is', + `creation_date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'the timestamp for when a usage was recorded', PRIMARY KEY (`id`), KEY `patron_quota_usage_ibfk_1` (`patron_quota_id`), KEY `patron_quota_usage_ibfk_2` (`patron_id`), + KEY `patron_quota_usage_issue_id` (`issue_id`), CONSTRAINT `patron_quota_usage_ibfk_1` FOREIGN KEY (`patron_quota_id`) REFERENCES `patron_quota` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `patron_quota_usage_ibfk_2` FOREIGN KEY (`patron_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- 2.50.1