From 1cf5a66126ae01e72b9ab29f73a2d1338121cd15 Mon Sep 17 00:00:00 2001 From: Andrew Isherwood 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 + +=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 + +=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