]> git.evergreen-ils.org Git - working/Evergreen.git/commit
Create new table acq.fund_allocation_percent, to store the percentages by which
authorscottmk <scottmk@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Thu, 22 Oct 2009 18:55:14 +0000 (18:55 +0000)
committerscottmk <scottmk@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Thu, 22 Oct 2009 18:55:14 +0000 (18:55 +0000)
commit14ac2aa12dff2fe6b6fc57290a8af5a79aa0130c
tree7de178332654df1e41714662dd0179403a1cd358
parentfe6f886dbb360ea22e9371488036ab91dd00bef0
Create new table acq.fund_allocation_percent, to store the percentages by which
future funding credits will be allocated to funds.

Create a trigger to ensure that the percentages never add up to more than
100 for any given funding source.

Populate the new table from acq.fund_allocation.

In acq.fund_allocation: convert any percentages to amounts, and nullify the
percentages.

M    Open-ILS/src/sql/Pg/002.schema.config.sql
A    Open-ILS/src/sql/Pg/upgrade/0049.schema.acq_funding_allocation_percent.sql
M    Open-ILS/examples/fm_IDL.xml

git-svn-id: svn://svn.open-ils.org/ILS/trunk@14566 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/upgrade/0049.schema.acq_funding_allocation_percent.sql [new file with mode: 0644]