projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 5545c51) | patch
LP#1787274 Active copy transit unique constraint
authorBill Erickson <berickxx@gmail.com>
Mon, 17 Sep 2018 22:16:42 +0000 (18:16 -0400)
committerBill Erickson <berickxx@gmail.com>
Tue, 18 Sep 2018 14:55:14 +0000 (10:55 -0400)
commit4074fdbc029894397e1c5da625c15bbab451fae2
tree6c77f3c1e5ce256db49fc90e146a05a694032ae2tree
parent5545c51ab1fcc04577d408cb472fd2333b1a61dacommit | diff
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>
Open-ILS/src/sql/Pg/090.schema.action.sql diff | blob | history
Open-ILS/src/sql/Pg/095.schema.booking.sql diff | blob | history
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.no-dupe-transits.sql [new file with mode: 0644] blob
Evergreen ILS