Bugzilla – Attachment 148298 Details for
Bug 24718
Introduce hour-based holds
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 24718: Updated schema files
Bug-24718-Updated-schema-files.patch (text/plain), 4.02 KB, created by
Aleisha Amohia
on 2023-03-16 23:25:33 UTC
(
hide
)
Description:
Bug 24718: Updated schema files
Filename:
MIME Type:
Creator:
Aleisha Amohia
Created:
2023-03-16 23:25:33 UTC
Size:
4.02 KB
patch
obsolete
>From 4a7b749e36d2ed5b433477b166f037285cfd0dce Mon Sep 17 00:00:00 2001 >From: Aleisha Amohia <aleishaamohia@hotmail.com> >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
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 24718
:
99540
|
99541
|
99542
|
99543
|
99544
|
99545
|
99548
|
103521
|
103522
|
103549
|
103550
|
103551
|
103552
|
103553
|
103554
|
103555
|
106270
|
106271
|
106272
|
106273
|
106274
|
106275
|
110084
|
110085
|
110086
|
110087
|
110088
|
110089
|
110090
|
110091
|
110098
|
110137
|
110161
|
110303
|
126559
|
126560
|
126561
|
126562
|
126563
|
126564
|
148293
|
148294
|
148295
|
148296
|
148297
|
148298
|
162474
|
162475
|
162476
|
162477
|
162478
|
162479