]> git.evergreen-ils.org Git - working/Evergreen.git/commit
Added five new views to the acq schema:
authorscottmk <scottmk@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Thu, 25 Feb 2010 20:37:21 +0000 (20:37 +0000)
committerscottmk <scottmk@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Thu, 25 Feb 2010 20:37:21 +0000 (20:37 +0000)
commit0a7220e09a8455a78de87df14c71c3e5bc2f166a
treefa34bf7df634e5a48e3aac6ec0cf80597a20a62d
parent5e94651f8ea592faab8b4465f8e9b0046f297e6d
Added five new views to the acq schema:

all_fund_allocation_total
all_fund_encumbrance_total
all_fund_spent_total
all_fund_spent_balance
all_fund_combined_balance

These views are similar to the correspondingly named views without the
"all_" prefix (i.e. acq.fund_allocation_total, etc) except that the
return a row for every fund in acq.fund, even if the fund is not
represented in acq.fund_debit or acq.fund_allocation.

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/0173.schema.acq.all-fund-views.sql
M    Open-ILS/examples/fm_IDL.xml

git-svn-id: svn://svn.open-ils.org/ILS/trunk@15642 dcc99617-32d9-48b4-a31d-7c20da2025e4
Open-ILS/examples/fm_IDL.xml
Open-ILS/src/sql/Pg/002.schema.config.sql
Open-ILS/src/sql/Pg/200.schema.acq.sql
Open-ILS/src/sql/Pg/upgrade/0173.schema.acq.all-fund-views.sql [new file with mode: 0644]