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