From bec61575582b6261fbb227d5f723a82c1093941c Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Mon, 2 Mar 2015 03:08:53 -0800 Subject: [PATCH] Bug 9303 [2] - relative's checkouts in the opac - Schema Updates e opac/svc/patron/ --- Koha/Schema/Result/Borrower.pm | 18 +++++++++++++++--- Koha/Schema/Result/Deletedborrower.pm | 12 ++++++++++-- Koha/Schema/Result/Issue.pm | 24 ++++++++++++++++++++++-- Koha/Schema/Result/OldIssue.pm | 24 ++++++++++++++++++++++-- 4 files changed, 69 insertions(+), 9 deletions(-) diff --git a/Koha/Schema/Result/Borrower.pm b/Koha/Schema/Result/Borrower.pm index 4dbd0ce..894d19e 100644 --- a/Koha/Schema/Result/Borrower.pm +++ b/Koha/Schema/Result/Borrower.pm @@ -407,6 +407,12 @@ __PACKAGE__->table("borrowers"); default_value: 1 is_nullable: 0 +=head2 privacy_guarantor_checkouts + + data_type: 'tinyint' + default_value: 0 + is_nullable: 0 + =cut __PACKAGE__->add_columns( @@ -576,6 +582,8 @@ __PACKAGE__->add_columns( { data_type => "varchar", is_nullable => 1, size => 50 }, "privacy", { data_type => "integer", default_value => 1, is_nullable => 0 }, + "privacy_guarantor_checkouts", + { data_type => "tinyint", default_value => 0, is_nullable => 0 }, ); =head1 PRIMARY KEY @@ -1129,9 +1137,13 @@ Composing rels: L -> course __PACKAGE__->many_to_many("courses", "course_instructors", "course"); -# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-12-31 14:08:18 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:mOTD/GsDpo3RPjUjTHrLRQ +# Created by DBIx::Class::Schema::Loader v0.07040 @ 2014-12-21 23:11:08 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:49MbDhILto8NukjDlkt8sA +__PACKAGE__->belongs_to( + "guarantor", + "Koha::Schema::Result::Borrower", + { borrowernumber => "guarantorid" }, +); -# You can replace this text with custom content, and it will be preserved on regeneration 1; diff --git a/Koha/Schema/Result/Deletedborrower.pm b/Koha/Schema/Result/Deletedborrower.pm index 8c438ba..f2c12c7 100644 --- a/Koha/Schema/Result/Deletedborrower.pm +++ b/Koha/Schema/Result/Deletedborrower.pm @@ -405,6 +405,12 @@ __PACKAGE__->table("deletedborrowers"); default_value: 1 is_nullable: 0 +=head2 privacy_guarantor_checkouts + + data_type: 'tinyint' + default_value: 0 + is_nullable: 0 + =cut __PACKAGE__->add_columns( @@ -562,11 +568,13 @@ __PACKAGE__->add_columns( { data_type => "varchar", is_nullable => 1, size => 50 }, "privacy", { data_type => "integer", default_value => 1, is_nullable => 0 }, + "privacy_guarantor_checkouts", + { data_type => "tinyint", default_value => 0, is_nullable => 0 }, ); -# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-08-18 13:01:05 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:cRaxMYFjVG7JB7AvsdCweg +# Created by DBIx::Class::Schema::Loader v0.07040 @ 2014-12-21 23:11:08 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ZbIeSjSJcOtYR/mSog6JGQ # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Issue.pm b/Koha/Schema/Result/Issue.pm index 5ec687e..86ead61 100644 --- a/Koha/Schema/Result/Issue.pm +++ b/Koha/Schema/Result/Issue.pm @@ -23,6 +23,12 @@ __PACKAGE__->table("issues"); =head1 ACCESSORS +=head2 issue_id + + data_type: 'integer' + is_auto_increment: 1 + is_nullable: 0 + =head2 borrowernumber data_type: 'integer' @@ -104,6 +110,8 @@ __PACKAGE__->table("issues"); =cut __PACKAGE__->add_columns( + "issue_id", + { data_type => "integer", is_auto_increment => 1, is_nullable => 0 }, "borrowernumber", { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, "itemnumber", @@ -153,6 +161,18 @@ __PACKAGE__->add_columns( { data_type => "integer", default_value => 0, is_nullable => 0 }, ); +=head1 PRIMARY KEY + +=over 4 + +=item * L + +=back + +=cut + +__PACKAGE__->set_primary_key("issue_id"); + =head1 RELATIONS =head2 borrowernumber @@ -196,8 +216,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-11-03 10:40:55 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7Y+5IerDnajn5GLwAY5thg +# Created by DBIx::Class::Schema::Loader v0.07040 @ 2014-12-21 23:11:08 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:XRRX1QRSzNEh8egdIu9JXw __PACKAGE__->belongs_to( "borrower", diff --git a/Koha/Schema/Result/OldIssue.pm b/Koha/Schema/Result/OldIssue.pm index b56db99..5585e5d 100644 --- a/Koha/Schema/Result/OldIssue.pm +++ b/Koha/Schema/Result/OldIssue.pm @@ -23,6 +23,12 @@ __PACKAGE__->table("old_issues"); =head1 ACCESSORS +=head2 issue_id + + data_type: 'integer' + is_auto_increment: 1 + is_nullable: 0 + =head2 borrowernumber data_type: 'integer' @@ -104,6 +110,8 @@ __PACKAGE__->table("old_issues"); =cut __PACKAGE__->add_columns( + "issue_id", + { data_type => "integer", is_auto_increment => 1, is_nullable => 0 }, "borrowernumber", { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, "itemnumber", @@ -153,6 +161,18 @@ __PACKAGE__->add_columns( { data_type => "integer", default_value => 0, is_nullable => 0 }, ); +=head1 PRIMARY KEY + +=over 4 + +=item * L + +=back + +=cut + +__PACKAGE__->set_primary_key("issue_id"); + =head1 RELATIONS =head2 borrowernumber @@ -196,8 +216,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-11-03 10:40:55 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:lNB9CDFcwG4DjD0pl14mvQ +# Created by DBIx::Class::Schema::Loader v0.07040 @ 2014-12-21 23:11:08 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:4xNiEAFgKgce//lrRYxwRA # You can replace this text with custom content, and it will be preserved on regeneration -- 1.7.10.4