From c9356377540c70803e8885ddec7691ea7248bf4c Mon Sep 17 00:00:00 2001 From: Fridolin Somers Date: Sun, 5 Mar 2023 21:37:07 -1000 Subject: [PATCH] Bug 33075: DBIC Updates --- Koha/Schema/Result/Deleteditem.pm | 24 ++++++++++++++++++++++++ Koha/Schema/Result/Item.pm | 24 ++++++++++++++++++++++++ 2 files changed, 48 insertions(+) diff --git a/Koha/Schema/Result/Deleteditem.pm b/Koha/Schema/Result/Deleteditem.pm index 45673bb84f1..c3148696e60 100644 --- a/Koha/Schema/Result/Deleteditem.pm +++ b/Koha/Schema/Result/Deleteditem.pm @@ -186,6 +186,22 @@ authorized value defining this item as withdrawn (MARC21 952$0) the date and time an item was last marked as withdrawn, NULL if not withdrawn +=head2 floating + + data_type: 'tinyint' + default_value: 0 + is_nullable: 0 + +if set, the item does not return to its homebranch after being returned (overrides circulation rules) + +=head2 floating_on + + data_type: 'datetime' + datetime_undef_if_invalid: 1 + is_nullable: 1 + +the date and time an item was last marked as floating, NULL if not floating + =head2 itemcallnumber data_type: 'varchar' @@ -453,6 +469,14 @@ __PACKAGE__->add_columns( datetime_undef_if_invalid => 1, is_nullable => 1, }, + "floating", + { data_type => "tinyint", default_value => 0, is_nullable => 0 }, + "floating_on", + { + data_type => "datetime", + datetime_undef_if_invalid => 1, + is_nullable => 1, + }, "itemcallnumber", { data_type => "varchar", is_nullable => 1, size => 255 }, "coded_location_qualifier", diff --git a/Koha/Schema/Result/Item.pm b/Koha/Schema/Result/Item.pm index e8ad9b3828b..59537ce19ef 100644 --- a/Koha/Schema/Result/Item.pm +++ b/Koha/Schema/Result/Item.pm @@ -189,6 +189,22 @@ authorized value defining this item as withdrawn (MARC21 952$0) the date and time an item was last marked as withdrawn, NULL if not withdrawn +=head2 floating + + data_type: 'tinyint' + default_value: 0 + is_nullable: 0 + +if set, the item does not return to its homebranch after being returned (overrides circulation rules) + +=head2 floating_on + + data_type: 'datetime' + datetime_undef_if_invalid: 1 + is_nullable: 1 + +the date and time an item was last marked as floating, NULL if not floating + =head2 itemcallnumber data_type: 'varchar' @@ -467,6 +483,14 @@ __PACKAGE__->add_columns( datetime_undef_if_invalid => 1, is_nullable => 1, }, + "floating", + { data_type => "tinyint", default_value => 0, is_nullable => 0 }, + "floating_on", + { + data_type => "datetime", + datetime_undef_if_invalid => 1, + is_nullable => 1, + }, "itemcallnumber", { data_type => "varchar", is_nullable => 1, size => 255 }, "coded_location_qualifier", -- 2.43.0