From eb878d19d2642efd29e66b587a9c92ea417bc0c1 Mon Sep 17 00:00:00 2001
From: Magnus Enger <magnus@libriotech.no>
Date: Sat, 11 Nov 2017 14:02:56 +0000
Subject: [PATCH] Update Schema - DO NOT PUSH
https://bugs.koha-community.org/show_bug.cgi?id=18591
---
Koha/Schema/Result/Borrower.pm | 15 +++++
Koha/Schema/Result/Illcomment.pm | 137 +++++++++++++++++++++++++++++++++++++++
Koha/Schema/Result/Illrequest.pm | 19 +++++-
3 files changed, 169 insertions(+), 2 deletions(-)
create mode 100644 Koha/Schema/Result/Illcomment.pm
diff --git a/Koha/Schema/Result/Borrower.pm b/Koha/Schema/Result/Borrower.pm
index 236c917912..be09ba6a23 100644
--- a/Koha/Schema/Result/Borrower.pm
+++ b/Koha/Schema/Result/Borrower.pm
@@ -1025,6 +1025,21 @@ __PACKAGE__->has_many(
{ cascade_copy => 0, cascade_delete => 0 },
);
+=head2 illcomments
+
+Type: has_many
+
+Related object: L<Koha::Schema::Result::Illcomment>
+
+=cut
+
+__PACKAGE__->has_many(
+ "illcomments",
+ "Koha::Schema::Result::Illcomment",
+ { "foreign.borrowernumber" => "self.borrowernumber" },
+ { cascade_copy => 0, cascade_delete => 0 },
+);
+
=head2 illrequests
Type: has_many
diff --git a/Koha/Schema/Result/Illcomment.pm b/Koha/Schema/Result/Illcomment.pm
new file mode 100644
index 0000000000..76f150f7a1
--- /dev/null
+++ b/Koha/Schema/Result/Illcomment.pm
@@ -0,0 +1,137 @@
+use utf8;
+package Koha::Schema::Result::Illcomment;
+
+# Created by DBIx::Class::Schema::Loader
+# DO NOT MODIFY THE FIRST PART OF THIS FILE
+
+=head1 NAME
+
+Koha::Schema::Result::Illcomment
+
+=cut
+
+use strict;
+use warnings;
+
+use base 'DBIx::Class::Core';
+
+=head1 TABLE: C<illcomments>
+
+=cut
+
+__PACKAGE__->table("illcomments");
+
+=head1 ACCESSORS
+
+=head2 illcomment_id
+
+ data_type: 'integer'
+ is_auto_increment: 1
+ is_nullable: 0
+
+=head2 illrequest_id
+
+ data_type: 'bigint'
+ extra: {unsigned => 1}
+ is_foreign_key: 1
+ is_nullable: 0
+
+=head2 borrowernumber
+
+ data_type: 'integer'
+ is_foreign_key: 1
+ is_nullable: 1
+
+=head2 comment
+
+ data_type: 'text'
+ is_nullable: 1
+
+=head2 timestamp
+
+ data_type: 'timestamp'
+ datetime_undef_if_invalid: 1
+ default_value: current_timestamp
+ is_nullable: 0
+
+=cut
+
+__PACKAGE__->add_columns(
+ "illcomment_id",
+ { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
+ "illrequest_id",
+ {
+ data_type => "bigint",
+ extra => { unsigned => 1 },
+ is_foreign_key => 1,
+ is_nullable => 0,
+ },
+ "borrowernumber",
+ { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
+ "comment",
+ { data_type => "text", is_nullable => 1 },
+ "timestamp",
+ {
+ data_type => "timestamp",
+ datetime_undef_if_invalid => 1,
+ default_value => \"current_timestamp",
+ is_nullable => 0,
+ },
+);
+
+=head1 PRIMARY KEY
+
+=over 4
+
+=item * L</illcomment_id>
+
+=back
+
+=cut
+
+__PACKAGE__->set_primary_key("illcomment_id");
+
+=head1 RELATIONS
+
+=head2 borrowernumber
+
+Type: belongs_to
+
+Related object: L<Koha::Schema::Result::Borrower>
+
+=cut
+
+__PACKAGE__->belongs_to(
+ "borrowernumber",
+ "Koha::Schema::Result::Borrower",
+ { borrowernumber => "borrowernumber" },
+ {
+ is_deferrable => 1,
+ join_type => "LEFT",
+ on_delete => "CASCADE",
+ on_update => "CASCADE",
+ },
+);
+
+=head2 illrequest
+
+Type: belongs_to
+
+Related object: L<Koha::Schema::Result::Illrequest>
+
+=cut
+
+__PACKAGE__->belongs_to(
+ "illrequest",
+ "Koha::Schema::Result::Illrequest",
+ { illrequest_id => "illrequest_id" },
+ { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
+);
+
+
+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-11-11 13:57:28
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:jlDjszfw2Q5k5FDnDD9FQg
+
+
+# You can replace this text with custom code or comments, and it will be preserved on regeneration
+1;
diff --git a/Koha/Schema/Result/Illrequest.pm b/Koha/Schema/Result/Illrequest.pm
index 1b207ff002..c6b689dc42 100644
--- a/Koha/Schema/Result/Illrequest.pm
+++ b/Koha/Schema/Result/Illrequest.pm
@@ -215,6 +215,21 @@ __PACKAGE__->belongs_to(
{ is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
);
+=head2 illcomments
+
+Type: has_many
+
+Related object: L<Koha::Schema::Result::Illcomment>
+
+=cut
+
+__PACKAGE__->has_many(
+ "illcomments",
+ "Koha::Schema::Result::Illcomment",
+ { "foreign.illrequest_id" => "self.illrequest_id" },
+ { cascade_copy => 0, cascade_delete => 0 },
+);
+
=head2 illrequestattributes
Type: has_many
@@ -231,8 +246,8 @@ __PACKAGE__->has_many(
);
-# 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.07042 @ 2017-11-11 13:57:28
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:rzJewf8BoBn9LieLzOa12w
# You can replace this text with custom code or comments, and it will be preserved on regeneration
--
2.11.0