Attachment 165666 Details for Bug 35657 – Bug 35657: Add assignee_id to tickets and ticket_updates

[patch] Bug 35657: Add assignee_id to tickets and ticket_updates

Bug-35657-Add-assigneeid-to-tickets-and-ticketupda.patch (text/plain), 3.72 KB, created by Martin Renvoize (ashimema) on 2024-04-26 16:09:08 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Martin Renvoize (ashimema)

Created: 2024-04-26 16:09:08 UTC

Size: 3.72 KB

patch

obsolete

>From 089ccfa043b60bb2aca9d4869154fa6b67f9903f Mon Sep 17 00:00:00 2001
>From: Martin Renvoize <martin.renvoize@ptfs-europe.com>
>Date: Thu, 28 Dec 2023 15:02:36 +0000
>Subject: [PATCH] Bug 35657: Add assignee_id to tickets and ticket_updates
>
>This patch updates the tickets and ticket_updates tables to include a
>assignee_id.
>---
> installer/data/mysql/kohastructure.sql | 10 ++++++++--
> 1 file changed, 8 insertions(+), 2 deletions(-)
>
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index d2c49a99a40..5d21e0415d3 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -6284,6 +6284,7 @@ CREATE TABLE `ticket_updates` (
>   `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key',
>   `ticket_id` int(11) NOT NULL COMMENT 'id of catalog ticket the update relates to',
>   `user_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id of the user who logged the update',
>+  `assignee_id` int(11) DEFAULT NULL COMMENT 'id of the user who this ticket was assigned to at this update',
>   `public` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'boolean flag to denote whether this update is public',
>   `date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'date and time this update was logged',
>   `message` text NOT NULL COMMENT 'update message content',
>@@ -6291,8 +6292,10 @@ CREATE TABLE `ticket_updates` (
>   PRIMARY KEY (`id`),
>   KEY `ticket_updates_ibfk_1` (`ticket_id`),
>   KEY `ticket_updates_ibfk_2` (`user_id`),
>+  KEY `ticket_updates_ibfk_3` (`assignee_id`),
>   CONSTRAINT `ticket_updates_ibfk_1` FOREIGN KEY (`ticket_id`) REFERENCES `tickets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
>-  CONSTRAINT `ticket_updates_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
>+  CONSTRAINT `ticket_updates_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
>+  CONSTRAINT `ticket_updates_ibfk_3` FOREIGN KEY (`assignee_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> /*!40101 SET character_set_client = @saved_cs_client */;
> 
>@@ -6311,6 +6314,7 @@ CREATE TABLE `tickets` (
>   `title` text NOT NULL COMMENT 'ticket title',
>   `body` text NOT NULL COMMENT 'ticket details',
>   `status` varchar(80) DEFAULT NULL COMMENT 'current status of the ticket',
>+  `assignee_id` int(11) DEFAULT NULL COMMENT 'id of the user who this ticket is assigned to',
>   `resolver_id` int(11) DEFAULT NULL COMMENT 'id of the user who resolved the ticket',
>   `resolved_date` datetime DEFAULT NULL COMMENT 'date and time this ticket was resolved',
>   `biblio_id` int(11) DEFAULT NULL COMMENT 'id of biblio linked',
>@@ -6318,9 +6322,11 @@ CREATE TABLE `tickets` (
>   KEY `tickets_ibfk_1` (`reporter_id`),
>   KEY `tickets_ibfk_2` (`resolver_id`),
>   KEY `tickets_ibfk_3` (`biblio_id`),
>+  KEY `tickets_ibfk_4` (`assignee_id`),
>   CONSTRAINT `tickets_ibfk_1` FOREIGN KEY (`reporter_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
>   CONSTRAINT `tickets_ibfk_2` FOREIGN KEY (`resolver_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
>-  CONSTRAINT `tickets_ibfk_3` FOREIGN KEY (`biblio_id`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
>+  CONSTRAINT `tickets_ibfk_3` FOREIGN KEY (`biblio_id`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE,
>+  CONSTRAINT `tickets_ibfk_4` FOREIGN KEY (`assignee_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> /*!40101 SET character_set_client = @saved_cs_client */;
> 
>-- 
>2.44.0

Actions: View | Diff | Splinter Review

Attachments on bug 35657: 160365 | 160366 | 160367 | 160368 | 160369 | 160372 | 160373 | 160374 | 160375 | 160376 | 160377 | 164923 | 164924 | 164925 | 164926 | 164927 | 164928 | 164932 | 164933 | 164934 | 164935 | 164974 | 164975 | 164976 | 164977 | 165666 | 165667 | 165668 | 165669 | 165670 | 165671 | 165672 | 165673 | 165674 | 165675 | 165676 | 165677 | 165678 | 165679 | 165786 | 165787 | 165788 | 165789 | 165790 | 165791 | 165792 | 165878 | 165879 | 165880 | 165881 | 165882 | 165883 | 165884 | 165885 | 165886 | 166067