]> git.evergreen-ils.org Git - working/Evergreen.git/commit
projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 4bd5e0b) | patch
Stamped upgrade script for ACQ fund view repairs
authorBill Erickson <berick@esilibrary.com>
Thu, 22 Sep 2011 15:10:09 +0000 (11:10 -0400)
committerBill Erickson <berick@esilibrary.com>
Thu, 22 Sep 2011 15:18:45 +0000 (11:18 -0400)
commit9b4693f07a26eed41dfdd98cbc8a59a1a6070962
tree5c73ad5fcbcb401cc6eb45297ce64ac4f3f7bb8ctree
parent4bd5e0b84af5c14cd9e4edbe631e193df4de4274commit | diff
Stamped upgrade script for ACQ fund view repairs

At the heart of this change is the need to force acq.fund_debit_total to
return exactly 1 row per fund, instead of 1 per fund + encumbrance
value.  However, such a change required rearranging a number of
dependent views.

Also added acq.fund_spent_balance to the set of views that needs
dropping and re-building.

Minor SQL format change to match surrounding code in schema file

See also https://bugs.launchpad.net/evergreen/+bug/800477

Signed-off-by: Bill Erickson <berick@esilibrary.com>
Open-ILS/src/sql/Pg/002.schema.config.sql diff | blob | history
Open-ILS/src/sql/Pg/200.schema.acq.sql diff | blob | history
Open-ILS/src/sql/Pg/upgrade/0628.schema.acq_fund_view_repairs.sql [new file with mode: 0644] blob
Open-ILS/src/sql/Pg/upgrade/xxxx.schema.acq_lp800477 [deleted file] blob | history
Evergreen ILS