From 5b9b2c1d0466cdf5715767209cf16aba68ca58ad 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 | 7 +++---- Koha/Schema/Result/Item.pm | 7 +++---- Koha/Schema/Result/Itemtype.pm | 10 ++++++++++ 3 files changed, 16 insertions(+), 8 deletions(-) diff --git a/Koha/Schema/Result/Deleteditem.pm b/Koha/Schema/Result/Deleteditem.pm index 118b2251217..934c88f308c 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", diff --git a/Koha/Schema/Result/Item.pm b/Koha/Schema/Result/Item.pm index dcbd2275a82..a05bb659358 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", diff --git a/Koha/Schema/Result/Itemtype.pm b/Koha/Schema/Result/Itemtype.pm index 22880fdb438..67906a45d86 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 -- 2.30.2