projects / evergreen / pines.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 793a95a) | patch
LP#1787274 Active copy transit unique constraint
authorBill Erickson <berickxx@gmail.com>
Mon, 17 Sep 2018 22:16:42 +0000 (18:16 -0400)
committerChris Sharp <csharp@georgialibraries.org>
Tue, 25 Sep 2018 10:55:14 +0000 (06:55 -0400)
commit21120dac4335463a64d4233684f71a94747b7271
tree0646f5126b692982ca152079b249a2eaf62bfe51tree
parent793a95aa3a8bd300b38a8d3bf87fcdf7afa5a76acommit | 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 working repo (PINES)