Attachment 168121 Details for Bug 35906 – Bug 35906: Schema dump

[patch] Bug 35906: Schema dump

Bug-35906-Schema-dump.patch (text/plain), 3.00 KB, created by Thibaud Guillot (thibaud_g) on 2024-06-26 08:11:46 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Thibaud Guillot (thibaud_g)

Created: 2024-06-26 08:11:46 UTC

Size: 3.00 KB

patch

obsolete

>From 5b9b2c1d0466cdf5715767209cf16aba68ca58ad 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 |  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

Actions: View | Diff | Splinter Review

Attachments on bug 35906: 161397 | 161638 | 161744 | 161961 | 162242 | 162365 | 162465 | 162466 | 162467 | 162468 | 162469 | 162470 | 162472 | 163291 | 163292 | 163293 | 163294 | 163295 | 163547 | 163548 | 163549 | 163550 | 163551 | 164579 | 164580 | 164581 | 164582 | 164583 | 164584 | 164585 | 165437 | 166866 | 166867 | 166868 | 166869 | 166870 | 166871 | 168120 | 168121 | 168122 | 168160 | 168161 | 168162 | 168163 | 168164 | 170187 | 170188 | 170189 | 170190 | 170191 | 170582 | 170583 | 170584 | 170585 | 170586 | 172127 | 172128 | 172129 | 172130 | 172131 | 172132 | 172941 | 172945 | 172950 | 172951 | 172952 | 172953 | 172954 | 172955 | 172956 | 172957 | 172958 | 172959 | 172960 | 172961 | 173324 | 173325 | 173326 | 173327 | 173328 | 173329 | 173330 | 173331 | 173332 | 173333 | 173334 | 173335 | 173893