From 19b6e6f2cfff9494520d700967317cbfe9a4c088 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