From 4bbba75ef0f8ff3d7286b54b1cc6a8012756e8e8 Mon Sep 17 00:00:00 2001 From: Martin Renvoize Date: Mon, 26 Feb 2024 17:12:57 +0000 Subject: [PATCH] Bug 35906: Schema dump Signed-off-by: Esther --- Koha/Schema/Result/CourseItem.pm | 4 ++-- Koha/Schema/Result/Deleteditem.pm | 11 +++++------ Koha/Schema/Result/Item.pm | 11 +++++------ Koha/Schema/Result/Itemtype.pm | 14 ++++++++++++-- 4 files changed, 24 insertions(+), 16 deletions(-) diff --git a/Koha/Schema/Result/CourseItem.pm b/Koha/Schema/Result/CourseItem.pm index 435c2db64e2..4e16128f01d 100644 --- a/Koha/Schema/Result/CourseItem.pm +++ b/Koha/Schema/Result/CourseItem.pm @@ -380,8 +380,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-06-11 18:35:38 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:3fFJ3uJr+5pMZniZ1glIpg +# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-06-26 13:35:02 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:oKWb55tzmvBnaM3Xx7aTkw __PACKAGE__->add_columns( '+itype_enabled' => { is_boolean => 1 }, diff --git a/Koha/Schema/Result/Deleteditem.pm b/Koha/Schema/Result/Deleteditem.pm index 118b2251217..36d7389bb8f 100644 --- a/Koha/Schema/Result/Deleteditem.pm +++ b/Koha/Schema/Result/Deleteditem.pm @@ -58,10 +58,9 @@ item barcode (MARC21 952$p) =head2 bookable data_type: 'tinyint' - default_value: 0 - is_nullable: 0 + is_nullable: 1 -boolean value defining whether this this item is available for bookings or not +nullable boolean value defining whether this this item is available for bookings or not =head2 dateaccessioned @@ -405,7 +404,7 @@ __PACKAGE__->add_columns( "barcode", { data_type => "varchar", is_nullable => 1, size => 20 }, "bookable", - { data_type => "tinyint", default_value => 0, is_nullable => 0 }, + { data_type => "tinyint", is_nullable => 1 }, "dateaccessioned", { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, "booksellerid", @@ -532,8 +531,8 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("itemnumber"); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2024-04-26 13:26:37 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:13COB8Ty6QDInmxN/zvEig +# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-06-26 13:35:02 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:1DwSBCE1xmO32FHJofFG6Q __PACKAGE__->add_columns( '+bookable' => { is_boolean => 1 }, diff --git a/Koha/Schema/Result/Item.pm b/Koha/Schema/Result/Item.pm index dcbd2275a82..d8cc5c84fbc 100644 --- a/Koha/Schema/Result/Item.pm +++ b/Koha/Schema/Result/Item.pm @@ -60,10 +60,9 @@ item barcode (MARC21 952$p) =head2 bookable data_type: 'tinyint' - default_value: 0 - is_nullable: 0 + is_nullable: 1 -boolean value defining whether this this item is available for bookings or not +nullable boolean value defining whether this this item is available for bookings or not =head2 dateaccessioned @@ -419,7 +418,7 @@ __PACKAGE__->add_columns( "barcode", { data_type => "varchar", is_nullable => 1, size => 20 }, "bookable", - { data_type => "tinyint", default_value => 0, is_nullable => 0 }, + { data_type => "tinyint", is_nullable => 1 }, "dateaccessioned", { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, "booksellerid", @@ -992,8 +991,8 @@ __PACKAGE__->might_have( ); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2024-04-26 13:26:37 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:8BzPWv3gqdhfLNz+Il93cw +# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-06-26 13:35:02 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:IgHEWfpSO2nOjgde1/fsvg __PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" ); diff --git a/Koha/Schema/Result/Itemtype.pm b/Koha/Schema/Result/Itemtype.pm index 22880fdb438..358f35ac2d7 100644 --- a/Koha/Schema/Result/Itemtype.pm +++ b/Koha/Schema/Result/Itemtype.pm @@ -176,6 +176,14 @@ Group this item type with others with the same value on OPAC search options If automatic checkin is enabled for items of this type +=head2 bookable + + data_type: 'tinyint' + default_value: 0 + is_nullable: 0 + +Activate bookable feature for items related to this item type + =cut __PACKAGE__->add_columns( @@ -222,6 +230,8 @@ __PACKAGE__->add_columns( { data_type => "varchar", is_nullable => 1, size => 80 }, "automatic_checkin", { data_type => "tinyint", default_value => 0, is_nullable => 0 }, + "bookable", + { data_type => "tinyint", default_value => 0, is_nullable => 0 }, ); =head1 PRIMARY KEY @@ -334,8 +344,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-05-08 14:38:07 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:9NChRQA4eBUqHpLXUFmOuw +# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-06-26 13:35:02 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Rjk3kfSQmwkcgjoykCX9dg __PACKAGE__->add_columns( '+automatic_checkin' => { is_boolean => 1 }, -- 2.45.2