From 3e8a4ad1762293e6b6fed60192b712335883ed73 Mon Sep 17 00:00:00 2001 From: Arthur Suzuki Date: Mon, 14 Nov 2022 14:59:09 +0100 Subject: [PATCH] Bug 30483: DBIC Signed-off-by: Arthur Suzuki --- Koha/Schema/Result/Issue.pm | 26 ++++++++------------------ 1 file changed, 8 insertions(+), 18 deletions(-) diff --git a/Koha/Schema/Result/Issue.pm b/Koha/Schema/Result/Issue.pm index 5d26b5b563..d0cb17ed89 100644 --- a/Koha/Schema/Result/Issue.pm +++ b/Koha/Schema/Result/Issue.pm @@ -35,7 +35,7 @@ primary key for issues table data_type: 'integer' is_foreign_key: 1 - is_nullable: 1 + is_nullable: 0 foreign key, linking this to the borrowers table for the patron this item was checked out to @@ -51,7 +51,7 @@ foreign key, linking this to the borrowers table for the user who checked out th data_type: 'integer' is_foreign_key: 1 - is_nullable: 1 + is_nullable: 0 foreign key, linking this to the items table for the item that was checked out @@ -172,11 +172,11 @@ __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 }, + { data_type => "integer", is_foreign_key => 1, is_nullable => 0 }, "issuer_id", { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, "itemnumber", - { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, + { data_type => "integer", is_foreign_key => 1, is_nullable => 0 }, "date_due", { data_type => "datetime", @@ -272,12 +272,7 @@ __PACKAGE__->belongs_to( "borrowernumber", "Koha::Schema::Result::Borrower", { borrowernumber => "borrowernumber" }, - { - is_deferrable => 1, - join_type => "LEFT", - on_delete => "RESTRICT", - on_update => "CASCADE", - }, + { is_deferrable => 1, on_delete => "RESTRICT", on_update => "CASCADE" }, ); =head2 issuer @@ -312,17 +307,12 @@ __PACKAGE__->belongs_to( "itemnumber", "Koha::Schema::Result::Item", { itemnumber => "itemnumber" }, - { - is_deferrable => 1, - join_type => "LEFT", - on_delete => "RESTRICT", - on_update => "CASCADE", - }, + { is_deferrable => 1, on_delete => "RESTRICT", on_update => "CASCADE" }, ); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-11-17 10:01:24 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kDcP8DNMT8sLUmzBFfz3fg +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-11-14 13:56:21 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Yv2x/hurJxn1J/hdNGqrpw __PACKAGE__->add_columns( '+auto_renew' => { is_boolean => 1 }, -- 2.39.5