Merge remote-tracking branch 'eg-working/user/berick/hold-current-shelf-lib'
[Evergreen.git] / Open-ILS / src / sql / Pg / 090.schema.action.sql
index eae256a..0ead480 100644 (file)
@@ -399,7 +399,8 @@ CREATE TABLE action.hold_request (
        shelf_time              TIMESTAMP WITH TIME ZONE,
     cut_in_line     BOOL,
        mint_condition  BOOL NOT NULL DEFAULT TRUE,
-       shelf_expire_time TIMESTAMPTZ
+       shelf_expire_time TIMESTAMPTZ,
+       current_shelf_lib INT REFERENCES actor.org_unit DEFERRABLE INITIALLY DEFERRED
 );
 
 CREATE INDEX hold_request_target_idx ON action.hold_request (target);