Bugzilla – Attachment 163482 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), 2.06 KB, created by
Victor Grousset/tuxayo
on 2024-03-20 01:53:46 UTC
(
hide
)
Description:
Bug 35616: Add source field to tickets table
Filename:
MIME Type:
Creator:
Victor Grousset/tuxayo
Created:
2024-03-20 01:53:46 UTC
Size:
2.06 KB
patch
obsolete
>From 3221744b8eeb432fc41d7422d699b00143e5ac0c 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 > >Signed-off-by: David Nind <david@davidnind.com> >Signed-off-by: Victor Grousset/tuxayo <victor@tuxayo.net> >--- > 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 0000000000..714ca08a8e >--- /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') 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 16310f0f44..db072e2f3d 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.44.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