Attachment 165886 Details for Bug 35657 – Bug 35657: (follow-up) Add missing DB update

[patch] Bug 35657: (follow-up) Add missing DB update

Bug-35657-follow-up-Add-missing-DB-update.patch (text/plain), 2.26 KB, created by Marcel de Rooy on 2024-04-30 13:39:08 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Marcel de Rooy

Created: 2024-04-30 13:39:08 UTC

Size: 2.26 KB

patch

obsolete

>From 6ed08b5d87a1f8b99ca454cb3699e1df3e9e8b5a Mon Sep 17 00:00:00 2001
>From: Martin Renvoize <martin.renvoize@ptfs-europe.com>
>Date: Tue, 30 Apr 2024 13:58:38 +0100
>Subject: [PATCH] Bug 35657: (follow-up) Add missing DB update
>Content-Type: text/plain; charset=utf-8
>
>Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
>---
> .../data/mysql/atomicupdate/bug_35657.pl      | 42 +++++++++++++++++++
> 1 file changed, 42 insertions(+)
> create mode 100755 installer/data/mysql/atomicupdate/bug_35657.pl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_35657.pl b/installer/data/mysql/atomicupdate/bug_35657.pl
>new file mode 100755
>index 0000000000..c02a2ff69c
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_35657.pl
>@@ -0,0 +1,42 @@
>+use Modern::Perl;
>+
>+return {
>+    bug_number  => "35657",
>+    description => "Add assignee_id to tickets",
>+    up          => sub {
>+        my ($args) = @_;
>+        my ( $dbh, $out ) = @$args{qw(dbh out)};
>+
>+        unless ( column_exists( 'tickets', 'assignee_id' ) ) {
>+            $dbh->do(
>+                q{
>+                ALTER TABLE tickets ADD COLUMN assignee_id int(11) DEFAULT NULL COMMENT 'id of the user this ticket is assigned to' AFTER status
>+            }
>+            );
>+            $dbh->do(
>+                q{
>+                ALTER TABLE tickets
>+                ADD CONSTRAINT `tickets_ibfk_4` FOREIGN KEY (`assignee_id`)
>+                REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
>+            }
>+            );
>+            say $out "Added column 'tickets.assignee_id'";
>+        }
>+
>+        unless ( column_exists( 'ticket_updates', 'assignee_id' ) ) {
>+            $dbh->do(
>+                q{
>+                ALTER TABLE ticket_updates ADD COLUMN assignee_id int(11) DEFAULT NULL COMMENT 'id of the user this ticket was assigned to with this update' AFTER user_id
>+            }
>+            );
>+            $dbh->do(
>+                q{
>+                ALTER TABLE ticket_updates
>+                ADD CONSTRAINT `ticket_updates_ibfk_4` FOREIGN KEY (`assignee_id`)
>+                REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
>+            }
>+            );
>+            say $out "Added column 'ticket_updates.assignee_id'";
>+        }
>+    },
>+};
>-- 
>2.30.2

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