Bugzilla – Attachment 162233 Details for
Bug 32132
Missing budget_period_id in aqbudgets kills lateorders.pl
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 32132: DO NOT PUSH! Schema changes
0002-Bug-32132-DO-NOT-PUSH-Schema-changes.patch (text/plain), 4.08 KB, created by
Emmi Takkinen
on 2024-02-16 06:12:58 UTC
(
hide
)
Description:
Bug 32132: DO NOT PUSH! Schema changes
Filename:
MIME Type:
Creator:
Emmi Takkinen
Created:
2024-02-16 06:12:58 UTC
Size:
4.08 KB
patch
obsolete
>From a30043d4d8366b56ec87bbad5c2695f1d6bff1ae Mon Sep 17 00:00:00 2001 >From: Emmi Takkinen <emmi.takkinen@koha-suomi.fi> >Date: Fri, 16 Feb 2024 08:10:34 +0200 >Subject: [PATCH 2/2] Bug 32132: DO NOT PUSH! Schema changes > >--- > Koha/Schema/Result/Aqbudget.pm | 45 ++++------------------------------ > 1 file changed, 5 insertions(+), 40 deletions(-) > >diff --git a/Koha/Schema/Result/Aqbudget.pm b/Koha/Schema/Result/Aqbudget.pm >index 182a7e39c5..56a8559703 100644 >--- a/Koha/Schema/Result/Aqbudget.pm >+++ b/Koha/Schema/Result/Aqbudget.pm >@@ -29,39 +29,29 @@ __PACKAGE__->table("aqbudgets"); > is_auto_increment: 1 > is_nullable: 0 > >-primary key and unique number assigned to each fund by Koha >- > =head2 budget_parent_id > > data_type: 'integer' > is_nullable: 1 > >-if this fund is a child of another this will include the parent id (aqbudgets.budget_id) >- > =head2 budget_code > > data_type: 'varchar' > is_nullable: 1 > size: 30 > >-code assigned to the fund by the user >- > =head2 budget_name > > data_type: 'varchar' > is_nullable: 1 > size: 80 > >-name assigned to the fund by the user >- > =head2 budget_branchcode > > data_type: 'varchar' > is_nullable: 1 > size: 10 > >-branch that this fund belongs to (branches.branchcode) >- > =head2 budget_amount > > data_type: 'decimal' >@@ -69,8 +59,6 @@ branch that this fund belongs to (branches.branchcode) > is_nullable: 1 > size: [28,6] > >-total amount for this fund >- > =head2 budget_encumb > > data_type: 'decimal' >@@ -78,8 +66,6 @@ total amount for this fund > is_nullable: 1 > size: [28,6] > >-budget warning at percentage >- > =head2 budget_expend > > data_type: 'decimal' >@@ -87,15 +73,11 @@ budget warning at percentage > is_nullable: 1 > size: [28,6] > >-budget warning at amount >- > =head2 budget_notes > > data_type: 'longtext' > is_nullable: 1 > >-notes related to this fund >- > =head2 timestamp > > data_type: 'timestamp' >@@ -103,15 +85,11 @@ notes related to this fund > default_value: current_timestamp > is_nullable: 0 > >-date and time this fund was last touched (created or modified) >- > =head2 budget_period_id > > data_type: 'integer' > is_foreign_key: 1 >- is_nullable: 1 >- >-id of the budget that this fund belongs to (aqbudgetperiods.budget_period_id) >+ is_nullable: 0 > > =head2 sort1_authcat > >@@ -119,31 +97,23 @@ id of the budget that this fund belongs to (aqbudgetperiods.budget_period_id) > is_nullable: 1 > size: 80 > >-statistical category for this fund >- > =head2 sort2_authcat > > data_type: 'varchar' > is_nullable: 1 > size: 80 > >-second statistical category for this fund >- > =head2 budget_owner_id > > data_type: 'integer' > is_nullable: 1 > >-borrowernumber of the person who owns this fund (borrowers.borrowernumber) >- > =head2 budget_permission > > data_type: 'integer' > default_value: 0 > is_nullable: 1 > >-level of permission for this fund (used only by the owner, only by the library, or anyone) >- > =cut > > __PACKAGE__->add_columns( >@@ -188,7 +158,7 @@ __PACKAGE__->add_columns( > is_nullable => 0, > }, > "budget_period_id", >- { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, >+ { data_type => "integer", is_foreign_key => 1, is_nullable => 0 }, > "sort1_authcat", > { data_type => "varchar", is_nullable => 1, size => 80 }, > "sort2_authcat", >@@ -300,12 +270,7 @@ __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", >- }, >+ { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, > ); > > =head2 suggestions >@@ -349,8 +314,8 @@ Composing rels: L</aqbudgetborrowers> -> borrowernumber > __PACKAGE__->many_to_many("borrowernumbers", "aqbudgetborrowers", "borrowernumber"); > > >-# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:sl+TGQXY85UWwS+Ld/vvyQ >+# Created by DBIx::Class::Schema::Loader v0.07049 @ 2024-02-16 08:09:10 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:4dPgExt3A7IMjKRyB8u1zA > > __PACKAGE__->belongs_to( > "budget", >-- >2.34.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 32132
:
143988
|
161721
|
162232
| 162233 |
162241
|
162584
|
165373
|
165374