LP1779158 Vandelay workstation setting repairs/additions

[Evergreen.git] / Open-ILS / src / sql / Pg / upgrade / 0920.schema.disallow-double-capture.sql

BEGIN;

SELECT evergreen.upgrade_deps_block_check('0920', :eg_version);

CREATE UNIQUE INDEX
    hold_request_capture_protect_idx ON action.hold_request (current_copy)
    WHERE   current_copy IS NOT NULL -- sometimes null in old/bad data
            AND capture_time IS NOT NULL
            AND cancel_time IS NULL
            AND fulfillment_time IS NULL;

COMMIT;