From c1e0b860742e86614806c2832074c028bab47080 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 --- Koha/Schema/Result/Deleteditem.pm | 11 +++++------ Koha/Schema/Result/Item.pm | 11 +++++------ Koha/Schema/Result/Itemtype.pm | 14 ++++++++++++-- 3 files changed, 22 insertions(+), 14 deletions(-) diff --git a/Koha/Schema/Result/Deleteditem.pm b/Koha/Schema/Result/Deleteditem.pm index a30646271c9..28c32c14aa1 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 @@ -398,7 +397,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", @@ -523,8 +522,8 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("itemnumber"); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-10-02 11:06:29 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Afgr1jl6aeSy/rS9RJGq2g +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2024-02-26 17:11:06 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:zX0VESQ43dK9B93+jjj8Lg __PACKAGE__->add_columns( '+bookable' => { is_boolean => 1 }, diff --git a/Koha/Schema/Result/Item.pm b/Koha/Schema/Result/Item.pm index 8320ce4c761..0f716f44443 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 @@ -412,7 +411,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", @@ -983,8 +982,8 @@ __PACKAGE__->might_have( ); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-11-03 14:18:06 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0jargxEw3HZOK57+ijsMHA +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2024-02-26 17:11:06 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:j8/IH2fOro69Owo92OkATA __PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" ); diff --git a/Koha/Schema/Result/Itemtype.pm b/Koha/Schema/Result/Itemtype.pm index d005da023f4..031edf866e5 100644 --- a/Koha/Schema/Result/Itemtype.pm +++ b/Koha/Schema/Result/Itemtype.pm @@ -175,6 +175,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( @@ -221,6 +229,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 @@ -333,8 +343,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-09-22 11:31:25 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:SoRKIMEqXE2+RkGq6zBejA +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2024-02-26 17:11:06 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:sgu5QbKVwomifJp1T8OZzA __PACKAGE__->add_columns( '+automatic_checkin' => { is_boolean => 1 }, -- 2.30.2