From 401ba64a59800069b10b67f9c36bea0307f9e99d Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Tue, 21 May 2013 12:45:18 -0400 Subject: [PATCH] LP1182519 Per-Hold Behind Desk SQL/IDL Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/090.schema.action.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/090.schema.action.sql b/Open-ILS/src/sql/Pg/090.schema.action.sql index 9dec15f306..c2066f3ad4 100644 --- a/Open-ILS/src/sql/Pg/090.schema.action.sql +++ b/Open-ILS/src/sql/Pg/090.schema.action.sql @@ -402,7 +402,8 @@ CREATE TABLE action.hold_request ( cut_in_line BOOL, mint_condition BOOL NOT NULL DEFAULT TRUE, shelf_expire_time TIMESTAMPTZ, - current_shelf_lib INT REFERENCES actor.org_unit DEFERRABLE INITIALLY DEFERRED + current_shelf_lib INT REFERENCES actor.org_unit DEFERRABLE INITIALLY DEFERRED, + behind_desk BOOLEAN NOT NULL DEFAULT FALSE ); ALTER TABLE action.hold_request ADD CONSTRAINT sms_check CHECK ( sms_notify IS NULL -- 2.11.0