From 7c5e0c8bd169c6ff8fb963e466f88eb360ade36c 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/Deleteditem.pm | 7 +++---- Koha/Schema/Result/Item.pm | 7 +++---- Koha/Schema/Result/Itemtype.pm | 14 ++++++++++++-- 3 files changed, 18 insertions(+), 10 deletions(-) diff --git a/Koha/Schema/Result/Deleteditem.pm b/Koha/Schema/Result/Deleteditem.pm index a681163b1e..cf4c62ff07 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 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", diff --git a/Koha/Schema/Result/Item.pm b/Koha/Schema/Result/Item.pm index 92fe4d1088..4d80f673dd 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 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", diff --git a/Koha/Schema/Result/Itemtype.pm b/Koha/Schema/Result/Itemtype.pm index 22880fdb43..358f35ac2d 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.25.1