From 134ca3d84373d41826d7807d04b5162c28ab791b Mon Sep 17 00:00:00 2001 From: Aleisha Amohia Date: Tue, 27 Feb 2024 01:16:48 +0000 Subject: [PATCH] Bug 24718: Updated schema files --- Koha/Schema/Result/OldReserve.pm | 20 ++++++++++++++------ Koha/Schema/Result/Reserve.pm | 20 ++++++++++++++------ 2 files changed, 28 insertions(+), 12 deletions(-) diff --git a/Koha/Schema/Result/OldReserve.pm b/Koha/Schema/Result/OldReserve.pm index e78ea520c09..242b20198f6 100644 --- a/Koha/Schema/Result/OldReserve.pm +++ b/Koha/Schema/Result/OldReserve.pm @@ -40,7 +40,7 @@ foreign key from the borrowers table defining which patron this hold is for =head2 reservedate - data_type: 'date' + data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1 @@ -159,7 +159,7 @@ the date the item was marked as waiting for the patron at the library =head2 expirationdate - data_type: 'date' + data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1 @@ -231,7 +231,11 @@ __PACKAGE__->add_columns( "borrowernumber", { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, "reservedate", - { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, + { + data_type => "datetime", + datetime_undef_if_invalid => 1, + is_nullable => 1, + }, "biblionumber", { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, "item_group_id", @@ -266,7 +270,11 @@ __PACKAGE__->add_columns( "waitingdate", { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, "expirationdate", - { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, + { + data_type => "datetime", + datetime_undef_if_invalid => 1, + is_nullable => 1, + }, "patron_expiration_date", { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, "lowestPriority", @@ -407,8 +415,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-02-10 14:01:25 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:evv31XLI36n7e+oYL/hsug +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2024-02-27 01:16:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:AAF0+7CnidRHohiSb3qAog __PACKAGE__->belongs_to( "item", diff --git a/Koha/Schema/Result/Reserve.pm b/Koha/Schema/Result/Reserve.pm index b6402955c11..bda4f711dfb 100644 --- a/Koha/Schema/Result/Reserve.pm +++ b/Koha/Schema/Result/Reserve.pm @@ -42,7 +42,7 @@ foreign key from the borrowers table defining which patron this hold is for =head2 reservedate - data_type: 'date' + data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1 @@ -164,7 +164,7 @@ the date the item was marked as waiting for the patron at the library =head2 expirationdate - data_type: 'date' + data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1 @@ -235,7 +235,11 @@ __PACKAGE__->add_columns( is_nullable => 0, }, "reservedate", - { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, + { + data_type => "datetime", + datetime_undef_if_invalid => 1, + is_nullable => 1, + }, "biblionumber", { data_type => "integer", @@ -275,7 +279,11 @@ __PACKAGE__->add_columns( "waitingdate", { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, "expirationdate", - { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, + { + data_type => "datetime", + datetime_undef_if_invalid => 1, + is_nullable => 1, + }, "patron_expiration_date", { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, "lowestPriority", @@ -456,8 +464,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-11-01 18:21:38 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:6BAjuPSwjtyWJaJN9fcOtg +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2024-02-27 01:16:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kASiGJzgrxDCM6fH+arTRw __PACKAGE__->belongs_to( "item", -- 2.30.2