LP#1564079 Checkout history handles serials
authorBill Erickson <berickxx@gmail.com>
Wed, 30 Mar 2016 21:49:26 +0000 (17:49 -0400)
committerBill Erickson <berickxx@gmail.com>
Wed, 30 Mar 2016 21:49:26 +0000 (17:49 -0400)
commita3434fc89779d731c71f0bcc468c2d560a5c5ee4
tree6c6a1ae99fc8b95c84c17bef1fa5a93e0a5cf62f
parenteadd9458856920bf4e2a6972e5b572a7fae69b57
LP#1564079 Checkout history handles serials

Remove the target_copy foreign key constraint on action.usr_circ_history
so that it does not prevent creation of rows from circulation's that
link to serial.unit objects.  Similar to action.circulation, the foreign
key constraint is enforced via a evergreen.fake_fkey_tgr trigger
instead.

This modifies the 2.9.3-2.10.0-upgrade-db.sql and 0960 upgrade scripts,
since without this change, the scripts may fail.

A separate upgrade script is added to drop the constraint for those who
have already successfully run the the 2.9.3-2.10.0-upgrade-db.sql script
(i.e. those who don't use serials).  For simplicity, the
evergreen.fake_fkey_tgr trigger is only applied in this separate upgrade
script (in addition to the base schema, of course).

Signed-off-by: Bill Erickson <berickxx@gmail.com>
Open-ILS/src/sql/Pg/090.schema.action.sql
Open-ILS/src/sql/Pg/upgrade/0960.schema.decouple_co_history.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.fix_circ_history_copy_ref.sql [new file with mode: 0644]
Open-ILS/src/sql/Pg/version-upgrade/2.9.3-2.10.0-upgrade-db.sql