Attachment 107284 Details for Bug 21946 – Bug 21946: DO NOT PUSH - Schema changes

[patch] Bug 21946: DO NOT PUSH - Schema changes

Bug-21946-DO-NOT-PUSH---Schema-changes.patch (text/plain), 2.42 KB, created by Alex Arnaud on 2020-07-24 08:32:51 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Alex Arnaud

Created: 2020-07-24 08:32:51 UTC

Size: 2.42 KB

patch

obsolete

>From 55fc02b69886a806887a7bc1f871d0b0f8c78fb4 Mon Sep 17 00:00:00 2001
>From: Nick Clemens <nick@bywatersolutions.com>
>Date: Fri, 17 Jul 2020 15:18:33 +0000
>Subject: [PATCH] Bug 21946: DO NOT PUSH - Schema changes
>
>---
> 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 b180a90c49..eca2e46151 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'
>@@ -129,6 +136,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",
>@@ -197,6 +206,21 @@ __PACKAGE__->has_many(
>   { 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 itemtypes_branches
> 
> Type: has_many
>@@ -227,6 +251,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
>@@ -243,8 +287,8 @@ __PACKAGE__->has_many(
> );
> 
> 
>-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-03-09 17:13:18
>-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7ojvTzsDvdHPAJMwJrAZ7A
>+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-07-17 15:17:36
>+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:hYueR4cyonLynlcgm6THNg
> 
> __PACKAGE__->add_columns(
>     '+rentalcharge_hourly_calendar' => { is_boolean => 1 },
>-- 
>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