From 1cf5a66126ae01e72b9ab29f73a2d1338121cd15 Mon Sep 17 00:00:00 2001
From: Andrew Isherwood <andrew.isherwood@ptfs-europe.com>
Date: Tue, 15 May 2018 15:17:04 +0100
Subject: [PATCH] Bug 20581: DO NOT PUSH: Updated Schema Files.

Signed-off-by: Niamh.Walker-Headon@it-tallaght.ie
---
 Koha/Schema/Result/AuthorisedValue.pm | 19 +++++++++++++++++--
 Koha/Schema/Result/Illrequest.pm      | 32 ++++++++++++++++++++++++++++++--
 2 files changed, 47 insertions(+), 4 deletions(-)

diff --git a/Koha/Schema/Result/AuthorisedValue.pm b/Koha/Schema/Result/AuthorisedValue.pm
index 7b978eb3b8..197bf04683 100644
--- a/Koha/Schema/Result/AuthorisedValue.pm
+++ b/Koha/Schema/Result/AuthorisedValue.pm
@@ -129,9 +129,24 @@ __PACKAGE__->belongs_to(
   { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
 );
 
+=head2 illrequests
 
-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-04-26 16:13:07
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YwvGOd/jzk71ekWfO56xrw
+Type: has_many
+
+Related object: L<Koha::Schema::Result::Illrequest>
+
+=cut
+
+__PACKAGE__->has_many(
+  "illrequests",
+  "Koha::Schema::Result::Illrequest",
+  { "foreign.status_alias" => "self.id" },
+  { cascade_copy => 0, cascade_delete => 0 },
+);
+
+
+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-05-15 15:13:30
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:EZxmz4Wcr3Pi4fiYQCq49A
 
 
 # You can replace this text with custom code or comments, and it will be preserved on regeneration
diff --git a/Koha/Schema/Result/Illrequest.pm b/Koha/Schema/Result/Illrequest.pm
index 1b207ff002..a91113af58 100644
--- a/Koha/Schema/Result/Illrequest.pm
+++ b/Koha/Schema/Result/Illrequest.pm
@@ -119,6 +119,12 @@ __PACKAGE__->table("illrequests");
   is_nullable: 1
   size: 20
 
+=head2 status_alias
+
+  data_type: 'integer'
+  is_foreign_key: 1
+  is_nullable: 1
+
 =cut
 
 __PACKAGE__->add_columns(
@@ -164,6 +170,8 @@ __PACKAGE__->add_columns(
   { data_type => "varchar", is_nullable => 1, size => 50 },
   "backend",
   { data_type => "varchar", is_nullable => 1, size => 20 },
+  "status_alias",
+  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
 );
 
 =head1 PRIMARY KEY
@@ -230,9 +238,29 @@ __PACKAGE__->has_many(
   { cascade_copy => 0, cascade_delete => 0 },
 );
 
+=head2 status_alias
+
+Type: belongs_to
+
+Related object: L<Koha::Schema::Result::AuthorisedValue>
+
+=cut
+
+__PACKAGE__->belongs_to(
+  "status_alias",
+  "Koha::Schema::Result::AuthorisedValue",
+  { id => "status_alias" },
+  {
+    is_deferrable => 1,
+    join_type     => "LEFT",
+    on_delete     => "SET NULL",
+    on_update     => "RESTRICT",
+  },
+);
+
 
-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Rh8DSs3xj3KRmyd7WNGDAg
+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-05-15 15:13:30
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:6QhckQiaGlBTB9TEPvXadg
 
 
 # You can replace this text with custom code or comments, and it will be preserved on regeneration
-- 
2.11.0