Attachment 87714 Details for Bug 21946 – Bug 21946: SCHEMA UPDATES DO NOT PUSH

[patch] Bug 21946: SCHEMA UPDATES DO NOT PUSH

Bug-21946-SCHEMA-UPDATES-DO-NOT-PUSH.patch (text/plain), 2.41 KB, created by Nick Clemens (kidclamp) on 2019-04-10 13:36:29 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Nick Clemens (kidclamp)

Created: 2019-04-10 13:36:29 UTC

Size: 2.41 KB

patch

obsolete

>From abc2031800455b2cbe9ba62049d7f3e9dc3ee8d0 Mon Sep 17 00:00:00 2001
>From: Nick Clemens <nick@bywatersolutions.com>
>Date: Wed, 13 Mar 2019 00:37:26 +0000
>Subject: [PATCH] Bug 21946: SCHEMA UPDATES DO NOT PUSH
>
>---
> Koha/Schema/Result/Itemtype.pm | 48 ++++++++++++++++++++++++++++++++++++++++--
> 1 file changed, 46 insertions(+), 2 deletions(-)
>
>diff --git a/Koha/Schema/Result/Itemtype.pm b/Koha/Schema/Result/Itemtype.pm
>index 55331fe32a..9f36cb5a42 100644
>--- a/Koha/Schema/Result/Itemtype.pm
>+++ b/Koha/Schema/Result/Itemtype.pm
>@@ -30,6 +30,13 @@ __PACKAGE__->table("itemtypes");
>   is_nullable: 0
>   size: 10
> 
>+=head2 parent_type
>+
>+  data_type: 'varchar'
>+  is_foreign_key: 1
>+  is_nullable: 1
>+  size: 10
>+
> =head2 description
> 
>   data_type: 'longtext'
>@@ -117,6 +124,8 @@ __PACKAGE__->table("itemtypes");
> __PACKAGE__->add_columns(
>   "itemtype",
>   { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },
>+  "parent_type",
>+  { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
>   "description",
>   { data_type => "longtext", is_nullable => 1 },
>   "rentalcharge",
>@@ -211,6 +220,21 @@ __PACKAGE__->might_have(
>   { cascade_copy => 0, cascade_delete => 0 },
> );
> 
>+=head2 itemtypes
>+
>+Type: has_many
>+
>+Related object: L<Koha::Schema::Result::Itemtype>
>+
>+=cut
>+
>+__PACKAGE__->has_many(
>+  "itemtypes",
>+  "Koha::Schema::Result::Itemtype",
>+  { "foreign.parent_type" => "self.itemtype" },
>+  { cascade_copy => 0, cascade_delete => 0 },
>+);
>+
> =head2 old_reserves
> 
> Type: has_many
>@@ -226,6 +250,26 @@ __PACKAGE__->has_many(
>   { cascade_copy => 0, cascade_delete => 0 },
> );
> 
>+=head2 parent_type
>+
>+Type: belongs_to
>+
>+Related object: L<Koha::Schema::Result::Itemtype>
>+
>+=cut
>+
>+__PACKAGE__->belongs_to(
>+  "parent_type",
>+  "Koha::Schema::Result::Itemtype",
>+  { itemtype => "parent_type" },
>+  {
>+    is_deferrable => 1,
>+    join_type     => "LEFT",
>+    on_delete     => "CASCADE",
>+    on_update     => "CASCADE",
>+  },
>+);
>+
> =head2 reserves
> 
> Type: has_many
>@@ -242,8 +286,8 @@ __PACKAGE__->has_many(
> );
> 
> 
>-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-03-07 17:30:46
>-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:CDIOU6LmF7suaujk1NQOeg
>+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2019-03-13 00:35:58
>+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Gg6idjbhkKwVaD4yhYF+Kw
> 
> # Use the ItemtypeLocalization view to create the join on localization
> our $LANGUAGE;
>-- 
>2.11.0

Actions: View | Diff | Splinter Review

Attachments on bug 21946: 87713 | 87714 | 87715 | 87716 | 87717 | 87718 | 87719 | 88392 | 88574 | 88575 | 88576 | 88577 | 88578 | 88579 | 88580 | 88581 | 88926 | 88927 | 88928 | 88929 | 88930 | 88931 | 88932 | 88933 | 88934 | 89167 | 89168 | 89169 | 89170 | 89171 | 89172 | 89173 | 89174 | 89175 | 89176 | 93075 | 93076 | 93077 | 93078 | 93079 | 93080 | 93081 | 93082 | 93083 | 93084 | 93086 | 93087 | 93088 | 93089 | 93090 | 93091 | 93092 | 93093 | 93094 | 93095 | 93096 | 93097 | 93098 | 93099 | 93100 | 93101 | 93102 | 93103 | 93104 | 93105 | 96977 | 96978 | 96979 | 96980 | 96981 | 96982 | 96983 | 96984 | 96985 | 96986 | 96987 | 99419 | 99420 | 99421 | 99422 | 99423 | 99424 | 107035 | 107036 | 107037 | 107038 | 107039 | 107040 | 107041 | 107278 | 107279 | 107280 | 107281 | 107282 | 107283 | 107284 | 107467 | 107489 | 107686 | 107687 | 107688 | 107689 | 107690 | 107691 | 107692 | 107693 | 107694 | 107701 | 107733