projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 35c1958) | 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 18:56:35 +0000 (14:56 -0400)
commit4dd0d0cca13f199a1d05ac8e5990e54d287fb1e4
tree9ce52950d0cb7c1fb7eaa6018ee9e5ffd1735950tree
parent35c1958ef4500e7f1d67413a2e1694db7c5ab492commit | 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