old-git.evergreen-ils.org Git - evergreen/tadl.git/commit

author	Bill Erickson <berick@esilibrary.com>
	Thu, 22 Sep 2011 15:10:09 +0000 (11:10 -0400)
committer	Bill Erickson <berick@esilibrary.com>
	Thu, 22 Sep 2011 15:23:29 +0000 (11:23 -0400)
commit	c4d92bcf1ca43d9630636637edd6cb9617fc0187
tree	bf1d85af8c8a8878746b019dc8387dd66bc6dd84	tree
parent	16923a798c7febf5c1c9424d7e8cec4e9d304ae2	commit \| 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