Bugzilla – Attachment 162479 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 2024-02-27 01:17:40 UTC
(
hide
)
Description:
Bug 24718: Updated schema files
Filename:
MIME Type:
Creator:
Aleisha Amohia
Created:
2024-02-27 01:17:40 UTC
Size:
4.02 KB
patch
obsolete
>From 134ca3d84373d41826d7807d04b5162c28ab791b Mon Sep 17 00:00:00 2001 >From: Aleisha Amohia <aleishaamohia@hotmail.com> >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
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