From 62bde5f03baa95d70039e723436be12b9599bf18 Mon Sep 17 00:00:00 2001
From: Martin Renvoize <martin.renvoize@ptfs-europe.com>
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.43.2