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>
Tue, 4 Oct 2011 03:22:24 +0000 (23:22 -0400)
commitcc8896aea62cbe15c903015f55b24735371ffd9c
tree0c91228c3c6b9a156686789de9b1d7aa9cefc22a
parent16d72220c512fd03c387f0b4c2aeb70288ed4629
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/200.schema.acq.sql
Open-ILS/src/sql/Pg/upgrade/xxxx.schema.acq_lp800477 [deleted file]