LP#1787274 Active copy transit unique constraint
authorBill Erickson <berickxx@gmail.com>
Mon, 17 Sep 2018 22:16:42 +0000 (18:16 -0400)
committerKathy Lussier <klussier@masslnc.org>
Tue, 18 Sep 2018 18:44:54 +0000 (14:44 -0400)
commit87bc5e52e2958a1904bebd43747c31a24951e981
tree9c63ba57cf6757f4388aaf7b07237423cb80a536
parenta03994fe3ba4b6cf0d18f9fa6b6c0f245ead67ef
LP#1787274 Active copy transit unique constraint

Adds constraint triggers to action.*transit_copy tables to prevent
creation of new transits for a copies when an existing transit of any
type exists for the copy with a NULL dest_recv_time and cancel_time
values (i.e. an open transit).

Signed-off-by: Bill Erickson <berickxx@gmail.com>
Signed-off-by: Kathy Lussier <klussier@masslnc.org>
Open-ILS/src/sql/Pg/090.schema.action.sql
Open-ILS/src/sql/Pg/095.schema.booking.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.no-dupe-transits.sql [new file with mode: 0644]