From 1a7d3efcabd30312b05ce5feb8350a03c586b83d Mon Sep 17 00:00:00 2001 From: Martin Renvoize Date: Tue, 9 May 2023 10:54:59 +0100 Subject: [PATCH] Bug 29002: Schema update DBIx::Class schema update for new 'bookable' field in the items table Signed-off-by: Tomas Cohen Arazi --- Koha/Schema/Result/Deleteditem.pm | 14 ++++++++++++-- Koha/Schema/Result/Item.pm | 14 ++++++++++++-- 2 files changed, 24 insertions(+), 4 deletions(-) diff --git a/Koha/Schema/Result/Deleteditem.pm b/Koha/Schema/Result/Deleteditem.pm index 7047142ba3..7183691433 100644 --- a/Koha/Schema/Result/Deleteditem.pm +++ b/Koha/Schema/Result/Deleteditem.pm @@ -55,6 +55,14 @@ foreign key from the biblioitems table to link to item to additional information item barcode (MARC21 952$p) +=head2 bookable + + data_type: 'tinyint' + default_value: 0 + is_nullable: 0 + +boolean value defining whether this this item is available for bookings or not + =head2 dateaccessioned data_type: 'date' @@ -389,6 +397,8 @@ __PACKAGE__->add_columns( { data_type => "integer", default_value => 0, is_nullable => 0 }, "barcode", { data_type => "varchar", is_nullable => 1, size => 20 }, + "bookable", + { data_type => "tinyint", default_value => 0, is_nullable => 0 }, "dateaccessioned", { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, "booksellerid", @@ -513,8 +523,8 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("itemnumber"); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-05-12 18:18:47 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:6TcVaUWoDdAGfBOr83ZOWQ +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-10-02 11:06:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Afgr1jl6aeSy/rS9RJGq2g __PACKAGE__->add_columns( '+exclude_from_local_holds_priority' => { is_boolean => 1 }, diff --git a/Koha/Schema/Result/Item.pm b/Koha/Schema/Result/Item.pm index b23a4388d3..55cdc1ca74 100644 --- a/Koha/Schema/Result/Item.pm +++ b/Koha/Schema/Result/Item.pm @@ -57,6 +57,14 @@ foreign key from the biblioitems table to link to item to additional information item barcode (MARC21 952$p) +=head2 bookable + + data_type: 'tinyint' + default_value: 0 + is_nullable: 0 + +boolean value defining whether this this item is available for bookings or not + =head2 dateaccessioned data_type: 'date' @@ -403,6 +411,8 @@ __PACKAGE__->add_columns( }, "barcode", { data_type => "varchar", is_nullable => 1, size => 20 }, + "bookable", + { data_type => "tinyint", default_value => 0, is_nullable => 0 }, "dateaccessioned", { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, "booksellerid", @@ -973,8 +983,8 @@ __PACKAGE__->might_have( ); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-07-31 11:33:55 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:w/riz2YWgVUds0eMqZuGTg +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-10-02 10:58:12 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:XTlINIMqB3LroE66IjZP3A __PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" ); -- 2.39.5