From 94bf1a6e3947d6f56a624e0ae218587c1f22f286 Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Mon, 21 Jul 2014 11:33:21 -0400 Subject: [PATCH] [SIGNED OFF] Bug 9011 [QA Followup 3] - Update database schema files Signed-off-by: Nick Clemens --- C4/Circulation.pm | 3 +-- Koha/Schema/Result/Issue.pm | 24 ++++++++++++++++++++++-- Koha/Schema/Result/OldIssue.pm | 24 ++++++++++++++++++++++-- 3 files changed, 45 insertions(+), 6 deletions(-) diff --git a/C4/Circulation.pm b/C4/Circulation.pm index 426f501..80f9649 100644 --- a/C4/Circulation.pm +++ b/C4/Circulation.pm @@ -3809,8 +3809,7 @@ sub AnonymizeItemIssueHistory { } if ( $oi && $oi->borrower()->privacy() == 2 ) { - $oi->set_column( 'borrowernumber', $a ); - $oi->update(); + $oi->update( { 'borrowernumber' => $a } ); } } diff --git a/Koha/Schema/Result/Issue.pm b/Koha/Schema/Result/Issue.pm index 2b3e3fd..2d6b867 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' @@ -92,6 +98,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", @@ -137,6 +145,18 @@ __PACKAGE__->add_columns( }, ); +=head1 PRIMARY KEY + +=over 4 + +=item * L + +=back + +=cut + +__PACKAGE__->set_primary_key("issue_id"); + =head1 RELATIONS =head2 borrowernumber @@ -180,8 +200,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-07-11 09:26:55 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:2SJJ3az4Ml9hKEQvNH3+Kw +# Created by DBIx::Class::Schema::Loader v0.07040 @ 2014-07-21 11:04:23 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:edKldSv9Wx8jFrfA7jfTnw __PACKAGE__->belongs_to( "borrower", diff --git a/Koha/Schema/Result/OldIssue.pm b/Koha/Schema/Result/OldIssue.pm index 6105731..acc9ad3 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' @@ -92,6 +98,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", @@ -137,6 +145,18 @@ __PACKAGE__->add_columns( }, ); +=head1 PRIMARY KEY + +=over 4 + +=item * L + +=back + +=cut + +__PACKAGE__->set_primary_key("issue_id"); + =head1 RELATIONS =head2 borrowernumber @@ -180,8 +200,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-07-11 09:26:55 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:sgsDHihVYHrTycbaqoGbaQ +# Created by DBIx::Class::Schema::Loader v0.07040 @ 2014-07-21 11:04:23 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:i+abQcASmLxXKsJPwJCcjQ __PACKAGE__->belongs_to( "borrower", -- 1.7.10.4