From 34a42570dcf52087b15aeb3605dbb27da9a18a82 Mon Sep 17 00:00:00 2001 From: Agustin Moyano Date: Wed, 10 Jun 2020 16:14:41 -0300 Subject: [PATCH] Bug 19889: set exclude_from_local_holds_priority columns as boolean in schema Sponsored-by: Cooperative Information Network (CIN) Signed-off-by: Christopher Brannon Signed-off-by: Christopher Brannon Signed-off-by: Nick Clemens JD Amended patch: fix md5sum Signed-off-by: Jonathan Druart --- Koha/Schema/Result/Category.pm | 15 +++++++++++++-- Koha/Schema/Result/Deleteditem.pm | 15 +++++++++++++-- Koha/Schema/Result/Item.pm | 15 +++++++++++++-- Koha/Schema/Result/OldReserve.pm | 4 ++-- Koha/Schema/Result/Reserve.pm | 4 ++-- 5 files changed, 43 insertions(+), 10 deletions(-) diff --git a/Koha/Schema/Result/Category.pm b/Koha/Schema/Result/Category.pm index 16d7a2228c..c714a6dce1 100644 --- a/Koha/Schema/Result/Category.pm +++ b/Koha/Schema/Result/Category.pm @@ -133,6 +133,11 @@ __PACKAGE__->table("categories"); data_type: 'tinyint' is_nullable: 1 +=head2 exclude_from_local_holds_priority + + data_type: 'tinyint' + is_nullable: 1 + =cut __PACKAGE__->add_columns( @@ -189,6 +194,8 @@ __PACKAGE__->add_columns( { data_type => "tinyint", is_nullable => 1 }, "change_password", { data_type => "tinyint", is_nullable => 1 }, + "exclude_from_local_holds_priority", + { data_type => "tinyint", is_nullable => 1 }, ); =head1 PRIMARY KEY @@ -281,8 +288,12 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-01-11 15:54:08 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:mWu3jtWB0NXhGMjoapGfSg +# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-07-22 17:36:24 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:p5Jzm0gHhk42fcLikwUnWw + +__PACKAGE__->add_columns( + '+exclude_from_local_holds_priority' => { is_boolean => 1 }, +); sub koha_object_class { 'Koha::Patron::Category'; diff --git a/Koha/Schema/Result/Deleteditem.pm b/Koha/Schema/Result/Deleteditem.pm index c7de98dd4a..4cb78ccd8e 100644 --- a/Koha/Schema/Result/Deleteditem.pm +++ b/Koha/Schema/Result/Deleteditem.pm @@ -282,6 +282,11 @@ __PACKAGE__->table("deleteditems"); is_nullable: 1 size: 32 +=head2 exclude_from_local_holds_priority + + data_type: 'tinyint' + is_nullable: 1 + =cut __PACKAGE__->add_columns( @@ -392,6 +397,8 @@ __PACKAGE__->add_columns( { data_type => "varchar", is_nullable => 1, size => 32 }, "new_status", { data_type => "varchar", is_nullable => 1, size => 32 }, + "exclude_from_local_holds_priority", + { data_type => "tinyint", is_nullable => 1 }, ); =head1 PRIMARY KEY @@ -407,8 +414,12 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("itemnumber"); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-27 10:38:13 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:MsPWE8Trd034UYFcZVbCtw +# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-06-05 20:21:47 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:4xydPpkFXE+oOR46jY5L8Q + +__PACKAGE__->add_columns( + '+exclude_from_local_holds_priority' => { is_boolean => 1 }, +); sub koha_objects_class { 'Koha::Old::Items'; diff --git a/Koha/Schema/Result/Item.pm b/Koha/Schema/Result/Item.pm index cb77d96ee0..7d8b9a6cc6 100644 --- a/Koha/Schema/Result/Item.pm +++ b/Koha/Schema/Result/Item.pm @@ -286,6 +286,11 @@ __PACKAGE__->table("items"); is_nullable: 1 size: 32 +=head2 exclude_from_local_holds_priority + + data_type: 'tinyint' + is_nullable: 1 + =cut __PACKAGE__->add_columns( @@ -406,6 +411,8 @@ __PACKAGE__->add_columns( { data_type => "varchar", is_nullable => 1, size => 32 }, "new_status", { data_type => "varchar", is_nullable => 1, size => 32 }, + "exclude_from_local_holds_priority", + { data_type => "tinyint", is_nullable => 1 }, ); =head1 PRIMARY KEY @@ -747,8 +754,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-27 10:38:13 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:IpI7wRweeZCbCeU1LhZbRQ +# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-06-05 20:21:47 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:9AxhV/hJnavWY4OTDTNRcQ __PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" ); @@ -759,6 +766,10 @@ __PACKAGE__->belongs_to( { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, ); +__PACKAGE__->add_columns( + '+exclude_from_local_holds_priority' => { is_boolean => 1 }, +); + use C4::Context; sub effective_itemtype { my ( $self ) = @_; diff --git a/Koha/Schema/Result/OldReserve.pm b/Koha/Schema/Result/OldReserve.pm index 940455298e..2cc0e2f425 100644 --- a/Koha/Schema/Result/OldReserve.pm +++ b/Koha/Schema/Result/OldReserve.pm @@ -314,8 +314,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-08-19 19:20:37 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Dov8h1qPOTI4pWBFUuaV2Q +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-08-31 14:16:48 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:DnOerXRIsIGIRKl9I0HZUQ __PACKAGE__->add_columns( '+item_level_hold' => { is_boolean => 1 }, diff --git a/Koha/Schema/Result/Reserve.pm b/Koha/Schema/Result/Reserve.pm index afe250da6d..2d7b397ec3 100644 --- a/Koha/Schema/Result/Reserve.pm +++ b/Koha/Schema/Result/Reserve.pm @@ -353,8 +353,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-08-19 19:20:37 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:o9wUv86AL1c/mje4GCW8Zw +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-08-31 14:16:48 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:goRy3ZQWpGNmicok5Av37Q __PACKAGE__->belongs_to( "item", -- 2.39.5