From 8d9246ffee92c74f315f3ffdc852f0e2d0d61c36 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 d45e542d441..5a0acf75826 100644 --- a/Koha/Schema/Result/Ticket.pm +++ b/Koha/Schema/Result/Ticket.pm @@ -63,6 +63,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' @@ -110,6 +118,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", @@ -207,8 +217,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-10-24 21:15:34 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0Nm+y1BHJicrpeq3kuU1VA +# 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