projects / evergreen / equinox.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: c04df8a) | 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)
committerMike Rylander <mrylander@gmail.com>
Fri, 23 Sep 2011 19:59:12 +0000 (15:59 -0400)
commit560ce40e90ba499bd83c3ec83ddf744286710778
tree5c73ad5fcbcb401cc6eb45297ce64ac4f3f7bb8ctree
parentc04df8a7449aeeba3c748e86157da065f367e61fcommit | 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 working repo (Equinox)