From 4a7b749e36d2ed5b433477b166f037285cfd0dce Mon Sep 17 00:00:00 2001 From: Aleisha Amohia Date: Thu, 16 Mar 2023 23:25:06 +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..8f33b01e28b 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 @ 2023-03-16 23:24:50 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:DY39VWxFc3HDoR4n/4F64A __PACKAGE__->belongs_to( "item", diff --git a/Koha/Schema/Result/Reserve.pm b/Koha/Schema/Result/Reserve.pm index 12b7855af82..4d3cec1b082 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-02-10 14:01:25 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:NO6FSSL1Hw3wBRGG6B5BnQ +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-03-16 23:24:50 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:rFtu/1fmq6f2pwYLJAKE9w __PACKAGE__->belongs_to( "item", -- 2.20.1