From 7d5bb7c9428b4386ed2baad5b0458e84611e99fb Mon Sep 17 00:00:00 2001 From: Katrin Fischer Date: Tue, 30 Apr 2024 09:13:35 +0000 Subject: [PATCH] Bug 35628: DBIC schema update Signed-off-by: Katrin Fischer --- Koha/Schema/Result/Ticket.pm | 14 ++++++++++++-- Koha/Schema/Result/TicketUpdate.pm | 14 ++++++++++++-- 2 files changed, 24 insertions(+), 4 deletions(-) diff --git a/Koha/Schema/Result/Ticket.pm b/Koha/Schema/Result/Ticket.pm index f8f428dab9..949d1d0888 100644 --- a/Koha/Schema/Result/Ticket.pm +++ b/Koha/Schema/Result/Ticket.pm @@ -72,6 +72,14 @@ ticket title ticket details +=head2 status + + data_type: 'varchar' + is_nullable: 1 + size: 80 + +current status of the ticket + =head2 resolver_id data_type: 'integer' @@ -126,6 +134,8 @@ __PACKAGE__->add_columns( { data_type => "text", is_nullable => 0 }, "body", { data_type => "text", is_nullable => 0 }, + "status", + { data_type => "varchar", is_nullable => 1, size => 80 }, "resolver_id", { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, "resolved_date", @@ -223,8 +233,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2024-04-21 16:39:22 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:A0jSRniIlOf/H5zB6PGH3g +# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-04-30 09:10:16 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:j1Ey1v55g3qw7ws03w7isQ # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/TicketUpdate.pm b/Koha/Schema/Result/TicketUpdate.pm index bc8a6caf42..d987e6a628 100644 --- a/Koha/Schema/Result/TicketUpdate.pm +++ b/Koha/Schema/Result/TicketUpdate.pm @@ -72,6 +72,14 @@ date and time this update was logged update message content +=head2 status + + data_type: 'varchar' + is_nullable: 1 + size: 80 + +status of ticket at this update + =cut __PACKAGE__->add_columns( @@ -97,6 +105,8 @@ __PACKAGE__->add_columns( }, "message", { data_type => "text", is_nullable => 0 }, + "status", + { data_type => "varchar", is_nullable => 1, size => 80 }, ); =head1 PRIMARY KEY @@ -144,8 +154,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-10-24 18:31:28 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:8YG3jhlqbHWptc28pvBmrg +# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-04-30 09:10:16 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ytO0skgfeeAKxubBk+4wtw __PACKAGE__->add_columns( '+public' => { is_boolean => 1 }, ); -- 2.39.5