Attachment 77825 Details for Bug 20581 – Bug 20581: DO NOT PUSH: Updated Schema Files.

[patch] Bug 20581: DO NOT PUSH: Updated Schema Files.

Bug-20581-DO-NOT-PUSH-Updated-Schema-Files.patch (text/plain), 2.95 KB, created by Andrew Isherwood on 2018-08-15 14:56:59 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Andrew Isherwood

Created: 2018-08-15 14:56:59 UTC

Size: 2.95 KB

patch

obsolete

>From 8046112769834f1fd396a5ae431b2f015dd43eac 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.
>
>---
> 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

Actions: View | Diff | Splinter Review

Attachments on bug 20581: 74323 | 74324 | 74325 | 74326 | 74327 | 74362 | 75333 | 75334 | 75810 | 77819 | 77820 | 77821 | 77822 | 77823 | 77824 | 77825 | 77826 | 78376 | 78377 | 78378 | 78379 | 78380 | 78381 | 78382 | 78383 | 78384 | 78431 | 78515 | 78516 | 78517 | 78518 | 78519 | 78520 | 78521 | 78522 | 78523 | 80279 | 80280 | 80281 | 80282 | 80283 | 80284 | 80285 | 80286 | 80474 | 80475 | 80501 | 80503 | 80505 | 80598 | 80599 | 80600 | 82063 | 82064 | 82065 | 82066 | 82067 | 82068 | 82069 | 82070 | 82071 | 82072 | 82073 | 82074 | 82075 | 82076 | 82443 | 82444 | 82445 | 82446 | 82447 | 82448 | 82449 | 82450 | 82451 | 82452 | 82453 | 82454 | 82455 | 82456 | 82457 | 82458 | 82459 | 82460 | 82461 | 82462 | 82463 | 82464 | 82465 | 82466 | 82467 | 82468 | 82472 | 82483 | 82484 | 82485 | 82486 | 82487 | 82488 | 82489 | 82490 | 82491 | 82492 | 82493 | 82494 | 82495 | 82496 | 82733 | 84202 | 84404 | 84768 | 84770 | 84771 | 84772 | 84773 | 84774 | 84775 | 84776 | 84777 | 84778 | 84779 | 84780 | 84781 | 84782 | 84783 | 84784 | 84785 | 84791 | 84814 | 84818 | 84819 | 84844 | 84911 | 84912 | 84913 | 84914 | 84915 | 84916 | 84917 | 84918 | 84919 | 84920 | 84921 | 84922 | 84923 | 84924 | 84925 | 84926 | 84927 | 84928 | 84929 | 84930 | 84931 | 84964 | 85075 | 85076 | 85077 | 85078 | 85079 | 85080 | 85081 | 85082 | 85083 | 85084 | 85085 | 85086 | 85087 | 85088 | 85089 | 85090 | 85091 | 85092 | 85093 | 85094 | 85095 | 85096