From 0ce4016313e508acd653ffa9415f436bf8fa32c3 Mon Sep 17 00:00:00 2001 From: Martin Renvoize Date: Fri, 22 Dec 2023 15:19:34 +0000 Subject: [PATCH] Bug 35628: Schema update Signed-off-by: Esther Melander Signed-off-by: Ray Delahunty --- 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 f8f428dab98..c5d54e10a85 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.07049 @ 2023-12-22 14:51:40 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:lcKWaA+k/0lw5/6JrFhB1A # 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 bc8a6caf42c..a27ec6e11a4 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.07049 @ 2023-12-22 14:51:40 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:5fRHoeJ8uIAnOmxll7BsnA __PACKAGE__->add_columns( '+public' => { is_boolean => 1 }, ); -- 2.44.0