Bugzilla – Attachment 160211 Details for
Bug 32435
Add resolution types to catalog concerns
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 32435: Add status to ticket_updates table
Bug-32435-Add-status-to-ticketupdates-table.patch (text/plain), 2.17 KB, created by
Martin Renvoize
on 2023-12-21 16:53:17 UTC
(
hide
)
Description:
Bug 32435: Add status to ticket_updates table
Filename:
MIME Type:
Creator:
Martin Renvoize
Created:
2023-12-21 16:53:17 UTC
Size:
2.17 KB
patch
obsolete
>From ddd17d442259251d51788f9127227be6451ef615 Mon Sep 17 00:00:00 2001 >From: Martin Renvoize <martin.renvoize@ptfs-europe.com> >Date: Thu, 21 Dec 2023 15:57:41 +0000 >Subject: [PATCH] Bug 32435: Add status to ticket_updates table > >--- > .../data/mysql/atomicupdate/bug_32435.pl | 21 +++++++++++++++++++ > installer/data/mysql/kohastructure.sql | 1 + > 2 files changed, 22 insertions(+) > create mode 100644 installer/data/mysql/atomicupdate/bug_32435.pl > >diff --git a/installer/data/mysql/atomicupdate/bug_32435.pl b/installer/data/mysql/atomicupdate/bug_32435.pl >new file mode 100644 >index 00000000000..e9591b5e67c >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_32435.pl >@@ -0,0 +1,21 @@ >+use Modern::Perl; >+ >+return { >+ bug_number => "32435", >+ description => "Add resolution types to catalog concerns", >+ up => sub { >+ my ($args) = @_; >+ my ($dbh, $out) = @$args{qw(dbh out)}; >+ unless( column_exists('aqbooksellers','type') ){ >+ $dbh->do(q{ >+ ALTER TABLE ticket_updates ADD COLUMN status varchar(80) DEFAULT NULL COMMENT 'status of ticket at this update' AFTER message >+ }); >+ >+ say $out "Added column 'ticket_updates.status'"; >+ } >+ $dbh->do(q{ >+ INSERT IGNORE INTO authorised_value_categories( category_name, is_system ) VALUES ('TICKET_RESOLUTION', 1); >+ }); >+ say $out "Added TICKET_RESOLUTION authorised value category"; >+ }, >+}; >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 0b59ad8d85c..007f92719bc 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -6270,6 +6270,7 @@ CREATE TABLE `ticket_updates` ( > `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', >+ `status` varchar(80) DEFAULT NULL COMMENT 'status of ticket at this update', > PRIMARY KEY (`id`), > KEY `ticket_updates_ibfk_1` (`ticket_id`), > KEY `ticket_updates_ibfk_2` (`user_id`), >-- >2.43.0
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 32435
:
160211
|
160212
|
160213
|
160214
|
160260
|
160261
|
160291
|
160292
|
160306
|
160321
|
160322
|
162493
|
164919
|
164920
|
164921
|
164922
|
165558
|
165559
|
165565
|
165566
|
165567
|
165611
|
165612
|
165613
|
165656
|
165657
|
165658
|
165781
|
165782
|
165783