From c001a545e4d4b5e084b114e9691a95afb35a91a7 Mon Sep 17 00:00:00 2001
From: Kyle M Hall <kyle@bywatersolutions.com>
Date: Mon, 16 Jul 2018 14:20:21 -0400
Subject: [PATCH] Bug 14570: Update schema files [Do Not Push]

---
 Koha/Schema/Result/Borrower.pm             | 41 +++++++++++++++++++++++-------
 Koha/Schema/Result/BorrowerModification.pm |  4 +--
 Koha/Schema/Result/Deletedborrower.pm      | 11 ++------
 3 files changed, 36 insertions(+), 20 deletions(-)

diff --git a/Koha/Schema/Result/Borrower.pm b/Koha/Schema/Result/Borrower.pm
index e88fdd2b18..45bc8f34ca 100644
--- a/Koha/Schema/Result/Borrower.pm
+++ b/Koha/Schema/Result/Borrower.pm
@@ -275,11 +275,6 @@ __PACKAGE__->table("borrowers");
   data_type: 'mediumtext'
   is_nullable: 1
 
-=head2 guarantorid
-
-  data_type: 'integer'
-  is_nullable: 1
-
 =head2 borrowernotes
 
   data_type: 'longtext'
@@ -574,8 +569,6 @@ __PACKAGE__->add_columns(
   { data_type => "mediumtext", is_nullable => 1 },
   "contacttitle",
   { data_type => "mediumtext", is_nullable => 1 },
-  "guarantorid",
-  { data_type => "integer", is_nullable => 1 },
   "borrowernotes",
   { data_type => "longtext", is_nullable => 1 },
   "relationship",
@@ -860,6 +853,36 @@ __PACKAGE__->has_many(
   { cascade_copy => 0, cascade_delete => 0 },
 );
 
+=head2 borrower_relationships_guarantees
+
+Type: has_many
+
+Related object: L<Koha::Schema::Result::BorrowerRelationship>
+
+=cut
+
+__PACKAGE__->has_many(
+  "borrower_relationships_guarantees",
+  "Koha::Schema::Result::BorrowerRelationship",
+  { "foreign.guarantee_id" => "self.borrowernumber" },
+  { cascade_copy => 0, cascade_delete => 0 },
+);
+
+=head2 borrower_relationships_guarantors
+
+Type: has_many
+
+Related object: L<Koha::Schema::Result::BorrowerRelationship>
+
+=cut
+
+__PACKAGE__->has_many(
+  "borrower_relationships_guarantors",
+  "Koha::Schema::Result::BorrowerRelationship",
+  { "foreign.guarantor_id" => "self.borrowernumber" },
+  { cascade_copy => 0, cascade_delete => 0 },
+);
+
 =head2 borrower_syncs
 
 Type: has_many
@@ -1416,8 +1439,8 @@ Composing rels: L</aqorder_users> -> ordernumber
 __PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");
 
 
-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-07-06 14:12:40
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:LaQWPXzF1Amzt8fgEEyHdg
+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-07-18 13:21:15
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:5PfG8Glz4h6UlJjRK0Hh1g
 
 __PACKAGE__->add_columns(
     '+lost' => { is_boolean => 1 },
diff --git a/Koha/Schema/Result/BorrowerModification.pm b/Koha/Schema/Result/BorrowerModification.pm
index 013da7753a..72e7c88af5 100644
--- a/Koha/Schema/Result/BorrowerModification.pm
+++ b/Koha/Schema/Result/BorrowerModification.pm
@@ -598,8 +598,8 @@ __PACKAGE__->add_columns(
 __PACKAGE__->set_primary_key("verification_token", "borrowernumber");
 
 
-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Vv0bJqR71Ust1MZAkYqTig
+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-07-18 13:21:15
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:OVrqAY9dj0OFMHbaiBAFwg
 
 
 # You can replace this text with custom content, and it will be preserved on regeneration
diff --git a/Koha/Schema/Result/Deletedborrower.pm b/Koha/Schema/Result/Deletedborrower.pm
index 4d15e35c1f..ffb0f23594 100644
--- a/Koha/Schema/Result/Deletedborrower.pm
+++ b/Koha/Schema/Result/Deletedborrower.pm
@@ -273,11 +273,6 @@ __PACKAGE__->table("deletedborrowers");
   data_type: 'mediumtext'
   is_nullable: 1
 
-=head2 guarantorid
-
-  data_type: 'integer'
-  is_nullable: 1
-
 =head2 borrowernotes
 
   data_type: 'longtext'
@@ -559,8 +554,6 @@ __PACKAGE__->add_columns(
   { data_type => "mediumtext", is_nullable => 1 },
   "contacttitle",
   { data_type => "mediumtext", is_nullable => 1 },
-  "guarantorid",
-  { data_type => "integer", is_nullable => 1 },
   "borrowernotes",
   { data_type => "longtext", is_nullable => 1 },
   "relationship",
@@ -641,8 +634,8 @@ __PACKAGE__->add_columns(
 );
 
 
-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:DNkNHNcv0lkMH6/seu89hg
+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-07-18 13:21:15
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:IAXQcqaoCDra+WVkyaikng
 
 
 # You can replace this text with custom code or comments, and it will be preserved on regeneration
-- 
2.11.0