From a30043d4d8366b56ec87bbad5c2695f1d6bff1ae Mon Sep 17 00:00:00 2001 From: Emmi Takkinen Date: Fri, 16 Feb 2024 08:10:34 +0200 Subject: [PATCH 2/2] Bug 32132: DO NOT PUSH! Schema changes --- Koha/Schema/Result/Aqbudget.pm | 45 ++++------------------------------ 1 file changed, 5 insertions(+), 40 deletions(-) diff --git a/Koha/Schema/Result/Aqbudget.pm b/Koha/Schema/Result/Aqbudget.pm index 182a7e39c5..56a8559703 100644 --- a/Koha/Schema/Result/Aqbudget.pm +++ b/Koha/Schema/Result/Aqbudget.pm @@ -29,39 +29,29 @@ __PACKAGE__->table("aqbudgets"); is_auto_increment: 1 is_nullable: 0 -primary key and unique number assigned to each fund by Koha - =head2 budget_parent_id data_type: 'integer' is_nullable: 1 -if this fund is a child of another this will include the parent id (aqbudgets.budget_id) - =head2 budget_code data_type: 'varchar' is_nullable: 1 size: 30 -code assigned to the fund by the user - =head2 budget_name data_type: 'varchar' is_nullable: 1 size: 80 -name assigned to the fund by the user - =head2 budget_branchcode data_type: 'varchar' is_nullable: 1 size: 10 -branch that this fund belongs to (branches.branchcode) - =head2 budget_amount data_type: 'decimal' @@ -69,8 +59,6 @@ branch that this fund belongs to (branches.branchcode) is_nullable: 1 size: [28,6] -total amount for this fund - =head2 budget_encumb data_type: 'decimal' @@ -78,8 +66,6 @@ total amount for this fund is_nullable: 1 size: [28,6] -budget warning at percentage - =head2 budget_expend data_type: 'decimal' @@ -87,15 +73,11 @@ budget warning at percentage is_nullable: 1 size: [28,6] -budget warning at amount - =head2 budget_notes data_type: 'longtext' is_nullable: 1 -notes related to this fund - =head2 timestamp data_type: 'timestamp' @@ -103,15 +85,11 @@ notes related to this fund default_value: current_timestamp is_nullable: 0 -date and time this fund was last touched (created or modified) - =head2 budget_period_id data_type: 'integer' is_foreign_key: 1 - is_nullable: 1 - -id of the budget that this fund belongs to (aqbudgetperiods.budget_period_id) + is_nullable: 0 =head2 sort1_authcat @@ -119,31 +97,23 @@ id of the budget that this fund belongs to (aqbudgetperiods.budget_period_id) is_nullable: 1 size: 80 -statistical category for this fund - =head2 sort2_authcat data_type: 'varchar' is_nullable: 1 size: 80 -second statistical category for this fund - =head2 budget_owner_id data_type: 'integer' is_nullable: 1 -borrowernumber of the person who owns this fund (borrowers.borrowernumber) - =head2 budget_permission data_type: 'integer' default_value: 0 is_nullable: 1 -level of permission for this fund (used only by the owner, only by the library, or anyone) - =cut __PACKAGE__->add_columns( @@ -188,7 +158,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 +270,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 +314,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-02-16 08:09:10 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:4dPgExt3A7IMjKRyB8u1zA __PACKAGE__->belongs_to( "budget", -- 2.34.1