Bugzilla – Attachment 160118 Details for
Bug 35616
Add a 'source' field to Koha::Tickets to denote the path taken to report the ticket
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 35616: Add source field to tickets table
Bug-35616-Add-source-field-to-tickets-table.patch (text/plain), 1.97 KB, created by
Martin Renvoize (ashimema)
on 2023-12-20 14:48:38 UTC
(
hide
)
Description:
Bug 35616: Add source field to tickets table
Filename:
MIME Type:
Creator:
Martin Renvoize (ashimema)
Created:
2023-12-20 14:48:38 UTC
Size:
1.97 KB
patch
obsolete
>From 707f860a504602480a7f28690936a176b1124302 Mon Sep 17 00:00:00 2001 >From: Martin Renvoize <martin.renvoize@ptfs-europe.com> >Date: Wed, 20 Dec 2023 14:42:20 +0000 >Subject: [PATCH] Bug 35616: Add source field to tickets table > >--- > installer/data/mysql/atomicupdate/bug_35616.pl | 17 +++++++++++++++++ > installer/data/mysql/kohastructure.sql | 1 + > 2 files changed, 18 insertions(+) > create mode 100644 installer/data/mysql/atomicupdate/bug_35616.pl > >diff --git a/installer/data/mysql/atomicupdate/bug_35616.pl b/installer/data/mysql/atomicupdate/bug_35616.pl >new file mode 100644 >index 00000000000..d9fb76857d2 >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_35616.pl >@@ -0,0 +1,17 @@ >+use Modern::Perl; >+ >+return { >+ bug_number => "35616", >+ description => "Add source column to tickets table", >+ up => sub { >+ my ($args) = @_; >+ my ( $dbh, $out ) = @$args{qw(dbh out)}; >+ >+ unless ( column_exists( 'tickets', 'source' ) ) { >+ $dbh->do( >+ "ALTER TABLE `tickets` ADD COLUMN `source` enum('catalog','sru') NOT NULL DEFAULT 'catalog' COMMENT 'source of ticket' AFTER `id`" >+ ); >+ say $out "Added column 'tickets.source'"; >+ } >+ }, >+}; >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 0b59ad8d85c..bf4f9d15bef 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -6287,6 +6287,7 @@ DROP TABLE IF EXISTS `tickets`; > /*!40101 SET character_set_client = utf8 */; > CREATE TABLE `tickets` ( > `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', >+ `source` enum('catalog') NOT NULL DEFAULT 'catalog' COMMENT 'source of ticket', > `reporter_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id of the patron who reported the ticket', > `reported_date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'date and time this ticket was reported', > `title` text NOT NULL COMMENT 'ticket title', >-- >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 35616
:
160118
|
160119
|
160120
|
160121
|
160127
|
160128
|
160129
|
160130
|
160143
|
160144
|
160145
|
160146
|
160164
|
160165
|
160166
|
160167
|
163482
|
163483
|
163484
|
163485
|
163486