]> git.evergreen-ils.org Git - Evergreen.git/commit
projects / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: f44a91f) | patch
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 19:00:37 +0000 (15:00 -0400)
commitf6c840db69108234d754acdbd8335cbd8c605d4d
treed6ecbf8fee670ddeac5411256375201d76f6f9d3tree
parentf44a91fadb5de774f1cbdf1e1db605f688942e15commit | 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>
Signed-off-by: Kathy Lussier <klussier@masslnc.org>
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