]> git.evergreen-ils.org Git - working/Evergreen.git/commit
Redefine the view acq.fund_debit_total:
authorscottmk <scottmk@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Wed, 27 Jan 2010 21:31:12 +0000 (21:31 +0000)
committerscottmk <scottmk@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Wed, 27 Jan 2010 21:31:12 +0000 (21:31 +0000)
commit0f8d3e793182a6fa9f5e4016f947d864946db50e
tree80a613160944186bc67652f6bc9cafff1ce32306
parentb68e1d439eef0f1eb960a33aaafc42a814bc086b
Redefine the view acq.fund_debit_total:

1. Correct the mistaken use of acq.fund_debit.id for fund,
instead of acq.fund_debit.fund.

2. Join to acq.fund so that we get a zero total for a fund
with no debits in acq.fund_debit.

Four other views are affected indirectly because they are defined
in terms of acq.fund_debit_total:

fund_encumbrance_total
fund_spent_total
fund_spent_balance
fund_combined_balance

M    Open-ILS/src/sql/Pg/200.schema.acq.sql
M    Open-ILS/src/sql/Pg/002.schema.config.sql
A    Open-ILS/src/sql/Pg/upgrade/0141.schema.acq.fund_debit_total_view.sql

git-svn-id: svn://svn.open-ils.org/ILS/trunk@15393 dcc99617-32d9-48b4-a31d-7c20da2025e4
Open-ILS/src/sql/Pg/002.schema.config.sql
Open-ILS/src/sql/Pg/200.schema.acq.sql
Open-ILS/src/sql/Pg/upgrade/0141.schema.acq.fund_debit_total_view.sql [new file with mode: 0644]