Bugzilla – Attachment 110170 Details for
Bug 18050
Missing constraint on aqbudgets.budget_period_id in aqbudgets
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 18050: [Do not push] Schema update
Bug-18050-Do-not-push-Schema-update.patch (text/plain), 3.06 KB, created by
Martin Renvoize (ashimema)
on 2020-09-16 11:14:13 UTC
(
hide
)
Description:
Bug 18050: [Do not push] Schema update
Filename:
MIME Type:
Creator:
Martin Renvoize (ashimema)
Created:
2020-09-16 11:14:13 UTC
Size:
3.06 KB
patch
obsolete
>From c2d60a8f1b590f92361a5f627ceec69fa738e75e Mon Sep 17 00:00:00 2001 >From: Katrin Fischer <katrin.fischer.83@web.de> >Date: Sun, 13 Sep 2020 23:30:22 +0000 >Subject: [PATCH] Bug 18050: [Do not push] Schema update > >Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com> >--- > Koha/Schema/Result/Aqbudget.pm | 27 ++++++++++++++++++++++++--- > Koha/Schema/Result/Aqbudgetperiod.pm | 21 +++++++++++++++++++-- > 2 files changed, 43 insertions(+), 5 deletions(-) > >diff --git a/Koha/Schema/Result/Aqbudget.pm b/Koha/Schema/Result/Aqbudget.pm >index f8f05f49c1..25a5a4c464 100644 >--- a/Koha/Schema/Result/Aqbudget.pm >+++ b/Koha/Schema/Result/Aqbudget.pm >@@ -88,6 +88,7 @@ __PACKAGE__->table("aqbudgets"); > =head2 budget_period_id > > data_type: 'integer' >+ is_foreign_key: 1 > is_nullable: 1 > > =head2 sort1_authcat >@@ -157,7 +158,7 @@ __PACKAGE__->add_columns( > is_nullable => 0, > }, > "budget_period_id", >- { data_type => "integer", is_nullable => 1 }, >+ { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, > "sort1_authcat", > { data_type => "varchar", is_nullable => 1, size => 80 }, > "sort2_authcat", >@@ -257,6 +258,26 @@ __PACKAGE__->has_many( > { cascade_copy => 0, cascade_delete => 0 }, > ); > >+=head2 budget_period >+ >+Type: belongs_to >+ >+Related object: L<Koha::Schema::Result::Aqbudgetperiod> >+ >+=cut >+ >+__PACKAGE__->belongs_to( >+ "budget_period", >+ "Koha::Schema::Result::Aqbudgetperiod", >+ { budget_period_id => "budget_period_id" }, >+ { >+ is_deferrable => 1, >+ join_type => "LEFT", >+ on_delete => "CASCADE", >+ on_update => "CASCADE", >+ }, >+); >+ > =head2 suggestions > > Type: has_many >@@ -298,8 +319,8 @@ Composing rels: L</aqbudgetborrowers> -> borrowernumber > __PACKAGE__->many_to_many("borrowernumbers", "aqbudgetborrowers", "borrowernumber"); > > >-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-07-16 13:50:45 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:zB7ox8a4KdDGq5fsbQfLGQ >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-09-13 23:03:50 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kmzXRyD6aNqPr5C6u9GBHA > > > sub koha_object_class { >diff --git a/Koha/Schema/Result/Aqbudgetperiod.pm b/Koha/Schema/Result/Aqbudgetperiod.pm >index 06c1492824..5ae2c98e81 100644 >--- a/Koha/Schema/Result/Aqbudgetperiod.pm >+++ b/Koha/Schema/Result/Aqbudgetperiod.pm >@@ -110,9 +110,26 @@ __PACKAGE__->add_columns( > > __PACKAGE__->set_primary_key("budget_period_id"); > >+=head1 RELATIONS > >-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:M13qdhmXgKilais2IFkXFw >+=head2 aqbudgets >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::Aqbudget> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "aqbudgets", >+ "Koha::Schema::Result::Aqbudget", >+ { "foreign.budget_period_id" => "self.budget_period_id" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+ >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-09-13 23:03:50 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0xS/Pc8hoKlNKfW9zDd4Gg > > sub koha_object_class { > 'Koha::Acquisition::Budget'; >-- >2.20.1
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 18050
:
110076
|
110078
|
110079
|
110080
|
110169
|
110170
|
110171
|
111429
|
111712
|
111713
|
111751
|
111752
|
111753
|
111754
|
111755
|
112529
|
112530