From d7d22d38b89a91d987ab2b9c46ac5aaca6db5c38 Mon Sep 17 00:00:00 2001 From: Katrin Fischer Date: Fri, 19 Apr 2024 17:03:30 +0000 Subject: [PATCH] Bug 32132: DBIC schema update Signed-off-by: Katrin Fischer --- Koha/Schema/Result/Aqbudget.pm | 15 +++++---------- 1 file changed, 5 insertions(+), 10 deletions(-) diff --git a/Koha/Schema/Result/Aqbudget.pm b/Koha/Schema/Result/Aqbudget.pm index 182a7e39c5..07612aa149 100644 --- a/Koha/Schema/Result/Aqbudget.pm +++ b/Koha/Schema/Result/Aqbudget.pm @@ -109,7 +109,7 @@ date and time this fund was last touched (created or modified) data_type: 'integer' is_foreign_key: 1 - is_nullable: 1 + is_nullable: 0 id of the budget that this fund belongs to (aqbudgetperiods.budget_period_id) @@ -188,7 +188,7 @@ __PACKAGE__->add_columns( is_nullable => 0, }, "budget_period_id", - { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, + { data_type => "integer", is_foreign_key => 1, is_nullable => 0 }, "sort1_authcat", { data_type => "varchar", is_nullable => 1, size => 80 }, "sort2_authcat", @@ -300,12 +300,7 @@ __PACKAGE__->belongs_to( "budget_period", "Koha::Schema::Result::Aqbudgetperiod", { budget_period_id => "budget_period_id" }, - { - is_deferrable => 1, - join_type => "LEFT", - on_delete => "CASCADE", - on_update => "CASCADE", - }, + { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, ); =head2 suggestions @@ -349,8 +344,8 @@ Composing rels: L -> borrowernumber __PACKAGE__->many_to_many("borrowernumbers", "aqbudgetborrowers", "borrowernumber"); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:sl+TGQXY85UWwS+Ld/vvyQ +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2024-04-19 17:02:59 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:5solU2GxDRyXxtWgpbcGVQ __PACKAGE__->belongs_to( "budget", -- 2.39.2