Attachment 92963 Details for Bug 14697 – Bug 14697: Add new schema file

[patch] Bug 14697: Add new schema file

Bug-14697-Add-new-schema-file.patch (text/plain), 5.94 KB, created by Kyle M Hall (khall) on 2019-09-19 11:21:47 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Kyle M Hall (khall)

Created: 2019-09-19 11:21:47 UTC

Size: 5.94 KB

patch

obsolete

>From b4b8f6b6c890e51b8c1d86cece0d4f698946ffb4 Mon Sep 17 00:00:00 2001
>From: Kyle M Hall <kyle@bywatersolutions.com>
>Date: Fri, 22 Feb 2019 09:40:35 -0500
>Subject: [PATCH] Bug 14697: Add new schema file
>
>---
> Koha/Schema/Result/ReturnClaim.pm | 296 ++++++++++++++++++++++++++++++
> 1 file changed, 296 insertions(+)
> create mode 100644 Koha/Schema/Result/ReturnClaim.pm
>
>diff --git a/Koha/Schema/Result/ReturnClaim.pm b/Koha/Schema/Result/ReturnClaim.pm
>new file mode 100644
>index 0000000000..fdd671c0e1
>--- /dev/null
>+++ b/Koha/Schema/Result/ReturnClaim.pm
>@@ -0,0 +1,296 @@
>+use utf8;
>+package Koha::Schema::Result::ReturnClaim;
>+
>+# Created by DBIx::Class::Schema::Loader
>+# DO NOT MODIFY THE FIRST PART OF THIS FILE
>+
>+=head1 NAME
>+
>+Koha::Schema::Result::ReturnClaim
>+
>+=cut
>+
>+use strict;
>+use warnings;
>+
>+use base 'DBIx::Class::Core';
>+
>+=head1 TABLE: C<return_claims>
>+
>+=cut
>+
>+__PACKAGE__->table("return_claims");
>+
>+=head1 ACCESSORS
>+
>+=head2 id
>+
>+  data_type: 'integer'
>+  is_auto_increment: 1
>+  is_nullable: 0
>+
>+=head2 itemnumber
>+
>+  data_type: 'integer'
>+  is_foreign_key: 1
>+  is_nullable: 0
>+
>+=head2 issue_id
>+
>+  data_type: 'integer'
>+  is_foreign_key: 1
>+  is_nullable: 1
>+
>+=head2 old_issue_id
>+
>+  data_type: 'integer'
>+  is_foreign_key: 1
>+  is_nullable: 1
>+
>+=head2 borrowernumber
>+
>+  data_type: 'integer'
>+  is_foreign_key: 1
>+  is_nullable: 0
>+
>+=head2 notes
>+
>+  data_type: 'mediumtext'
>+  is_nullable: 1
>+
>+=head2 created_on
>+
>+  data_type: 'timestamp'
>+  datetime_undef_if_invalid: 1
>+  is_nullable: 1
>+
>+=head2 created_by
>+
>+  data_type: 'integer'
>+  is_foreign_key: 1
>+  is_nullable: 1
>+
>+=head2 updated_on
>+
>+  data_type: 'timestamp'
>+  datetime_undef_if_invalid: 1
>+  is_nullable: 1
>+
>+=head2 updated_by
>+
>+  data_type: 'integer'
>+  is_foreign_key: 1
>+  is_nullable: 1
>+
>+=head2 resolution
>+
>+  data_type: 'varchar'
>+  is_nullable: 1
>+  size: 80
>+
>+=head2 resolved_on
>+
>+  data_type: 'timestamp'
>+  datetime_undef_if_invalid: 1
>+  is_nullable: 1
>+
>+=head2 resolved_by
>+
>+  data_type: 'integer'
>+  is_foreign_key: 1
>+  is_nullable: 1
>+
>+=cut
>+
>+__PACKAGE__->add_columns(
>+  "id",
>+  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
>+  "itemnumber",
>+  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
>+  "issue_id",
>+  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
>+  "old_issue_id",
>+  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
>+  "borrowernumber",
>+  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
>+  "notes",
>+  { data_type => "mediumtext", is_nullable => 1 },
>+  "created_on",
>+  {
>+    data_type => "timestamp",
>+    datetime_undef_if_invalid => 1,
>+    is_nullable => 1,
>+  },
>+  "created_by",
>+  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
>+  "updated_on",
>+  {
>+    data_type => "timestamp",
>+    datetime_undef_if_invalid => 1,
>+    is_nullable => 1,
>+  },
>+  "updated_by",
>+  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
>+  "resolution",
>+  { data_type => "varchar", is_nullable => 1, size => 80 },
>+  "resolved_on",
>+  {
>+    data_type => "timestamp",
>+    datetime_undef_if_invalid => 1,
>+    is_nullable => 1,
>+  },
>+  "resolved_by",
>+  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
>+);
>+
>+=head1 PRIMARY KEY
>+
>+=over 4
>+
>+=item * L</id>
>+
>+=back
>+
>+=cut
>+
>+__PACKAGE__->set_primary_key("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, on_delete => "CASCADE", on_update => "CASCADE" },
>+);
>+
>+=head2 created_by
>+
>+Type: belongs_to
>+
>+Related object: L<Koha::Schema::Result::Borrower>
>+
>+=cut
>+
>+__PACKAGE__->belongs_to(
>+  "created_by",
>+  "Koha::Schema::Result::Borrower",
>+  { borrowernumber => "created_by" },
>+  {
>+    is_deferrable => 1,
>+    join_type     => "LEFT",
>+    on_delete     => "SET NULL",
>+    on_update     => "CASCADE",
>+  },
>+);
>+
>+=head2 issue
>+
>+Type: belongs_to
>+
>+Related object: L<Koha::Schema::Result::Issue>
>+
>+=cut
>+
>+__PACKAGE__->belongs_to(
>+  "issue",
>+  "Koha::Schema::Result::Issue",
>+  { issue_id => "issue_id" },
>+  {
>+    is_deferrable => 1,
>+    join_type     => "LEFT",
>+    on_delete     => "SET NULL",
>+    on_update     => "CASCADE",
>+  },
>+);
>+
>+=head2 itemnumber
>+
>+Type: belongs_to
>+
>+Related object: L<Koha::Schema::Result::Item>
>+
>+=cut
>+
>+__PACKAGE__->belongs_to(
>+  "itemnumber",
>+  "Koha::Schema::Result::Item",
>+  { itemnumber => "itemnumber" },
>+  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
>+);
>+
>+=head2 old_issue
>+
>+Type: belongs_to
>+
>+Related object: L<Koha::Schema::Result::Issue>
>+
>+=cut
>+
>+__PACKAGE__->belongs_to(
>+  "old_issue",
>+  "Koha::Schema::Result::Issue",
>+  { issue_id => "old_issue_id" },
>+  {
>+    is_deferrable => 1,
>+    join_type     => "LEFT",
>+    on_delete     => "SET NULL",
>+    on_update     => "CASCADE",
>+  },
>+);
>+
>+=head2 resolved_by
>+
>+Type: belongs_to
>+
>+Related object: L<Koha::Schema::Result::Borrower>
>+
>+=cut
>+
>+__PACKAGE__->belongs_to(
>+  "resolved_by",
>+  "Koha::Schema::Result::Borrower",
>+  { borrowernumber => "resolved_by" },
>+  {
>+    is_deferrable => 1,
>+    join_type     => "LEFT",
>+    on_delete     => "SET NULL",
>+    on_update     => "CASCADE",
>+  },
>+);
>+
>+=head2 updated_by
>+
>+Type: belongs_to
>+
>+Related object: L<Koha::Schema::Result::Borrower>
>+
>+=cut
>+
>+__PACKAGE__->belongs_to(
>+  "updated_by",
>+  "Koha::Schema::Result::Borrower",
>+  { borrowernumber => "updated_by" },
>+  {
>+    is_deferrable => 1,
>+    join_type     => "LEFT",
>+    on_delete     => "SET NULL",
>+    on_update     => "CASCADE",
>+  },
>+);
>+
>+
>+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-06-21 10:21:06
>+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:MTy2jl5ksdYfSIpYr7q1yg
>+
>+
>+# You can replace this text with custom code or comments, and it will be preserved on regeneration
>+1;
>-- 
>2.20.1 (Apple Git-117)

Actions: View | Diff | Splinter Review

Attachments on bug 14697: 92407 | 92408 | 92409 | 92410 | 92962 | 92963 | 92964 | 92965 | 93005 | 93006 | 93007 | 93008 | 93012 | 93013 | 93014 | 93015 | 93017 | 93038 | 93039 | 93040 | 93041 | 93042 | 93061 | 93062 | 93063 | 93064 | 93065 | 93952 | 93953 | 93954 | 93955 | 93956 | 93957 | 93959 | 94842 | 94843 | 94844 | 94845 | 94846 | 94847 | 94848 | 94849 | 94850 | 94851 | 94852 | 94853 | 94854 | 94857 | 94877 | 94878