From 1ee81885b809a95fa12bf39dd0ce1bd839218aef Mon Sep 17 00:00:00 2001
From: Katrin Fischer <katrin.fischer.83@web.de>
Date: Sun, 13 Sep 2020 23:30:22 +0000
Subject: [PATCH] Bug 18050: DBIC schema changes

Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>

Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
---
 Koha/Schema/Result/Aqbudget.pm       | 27 ++++++++++++++++++++++++---
 Koha/Schema/Result/Aqbudgetperiod.pm | 21 +++++++++++++++++++--
 2 files changed, 43 insertions(+), 5 deletions(-)

diff --git a/Koha/Schema/Result/Aqbudget.pm b/Koha/Schema/Result/Aqbudget.pm
index f8f05f49c1..25a5a4c464 100644
--- a/Koha/Schema/Result/Aqbudget.pm
+++ b/Koha/Schema/Result/Aqbudget.pm
@@ -88,6 +88,7 @@ __PACKAGE__->table("aqbudgets");
 =head2 budget_period_id
 
   data_type: 'integer'
+  is_foreign_key: 1
   is_nullable: 1
 
 =head2 sort1_authcat
@@ -157,7 +158,7 @@ __PACKAGE__->add_columns(
     is_nullable => 0,
   },
   "budget_period_id",
-  { data_type => "integer", is_nullable => 1 },
+  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
   "sort1_authcat",
   { data_type => "varchar", is_nullable => 1, size => 80 },
   "sort2_authcat",
@@ -257,6 +258,26 @@ __PACKAGE__->has_many(
   { cascade_copy => 0, cascade_delete => 0 },
 );
 
+=head2 budget_period
+
+Type: belongs_to
+
+Related object: L<Koha::Schema::Result::Aqbudgetperiod>
+
+=cut
+
+__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",
+  },
+);
+
 =head2 suggestions
 
 Type: has_many
@@ -298,8 +319,8 @@ Composing rels: L</aqbudgetborrowers> -> borrowernumber
 __PACKAGE__->many_to_many("borrowernumbers", "aqbudgetborrowers", "borrowernumber");
 
 
-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-07-16 13:50:45
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:zB7ox8a4KdDGq5fsbQfLGQ
+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-09-13 23:03:50
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kmzXRyD6aNqPr5C6u9GBHA
 
 
 sub koha_object_class {
diff --git a/Koha/Schema/Result/Aqbudgetperiod.pm b/Koha/Schema/Result/Aqbudgetperiod.pm
index 06c1492824..5ae2c98e81 100644
--- a/Koha/Schema/Result/Aqbudgetperiod.pm
+++ b/Koha/Schema/Result/Aqbudgetperiod.pm
@@ -110,9 +110,26 @@ __PACKAGE__->add_columns(
 
 __PACKAGE__->set_primary_key("budget_period_id");
 
+=head1 RELATIONS
 
-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:M13qdhmXgKilais2IFkXFw
+=head2 aqbudgets
+
+Type: has_many
+
+Related object: L<Koha::Schema::Result::Aqbudget>
+
+=cut
+
+__PACKAGE__->has_many(
+  "aqbudgets",
+  "Koha::Schema::Result::Aqbudget",
+  { "foreign.budget_period_id" => "self.budget_period_id" },
+  { cascade_copy => 0, cascade_delete => 0 },
+);
+
+
+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-09-13 23:03:50
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0xS/Pc8hoKlNKfW9zDd4Gg
 
 sub koha_object_class {
     'Koha::Acquisition::Budget';
-- 
2.39.5