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

[patch] Bug 35906: Schema dump

Bug-35906-Schema-dump.patch (text/plain), 4.33 KB, created by Martin Renvoize (ashimema) on 2024-02-26 19:19:06 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Martin Renvoize (ashimema)

Created: 2024-02-26 19:19:06 UTC

Size: 4.33 KB

patch

obsolete

>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

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