]> git.evergreen-ils.org Git - Evergreen.git/blob - Open-ILS/src/sql/Pg/upgrade/0292.schema.action-target_copy-index.sql
LP#980296: Void Lost Fines if copy claims returned.
[Evergreen.git] / Open-ILS / src / sql / Pg / upgrade / 0292.schema.action-target_copy-index.sql
1 BEGIN;
2 INSERT INTO config.upgrade_log (version) VALUES ('0292'); -- dbs
3 CREATE UNIQUE INDEX only_one_concurrent_checkout_per_copy ON action.circulation(target_copy) WHERE checkin_time IS NULL;
4 COMMIT;