From e0386533edc6da0e2ec7e9f82689cdfb05a5ad5d Mon Sep 17 00:00:00 2001 From: miker Date: Tue, 6 Sep 2005 19:23:45 +0000 Subject: [PATCH] tracking more data git-svn-id: svn://svn.open-ils.org/ILS/trunk@1804 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/090.schema.action.sql | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/Open-ILS/src/sql/Pg/090.schema.action.sql b/Open-ILS/src/sql/Pg/090.schema.action.sql index 43889e9b2e..cab9cd82ac 100644 --- a/Open-ILS/src/sql/Pg/090.schema.action.sql +++ b/Open-ILS/src/sql/Pg/090.schema.action.sql @@ -59,6 +59,7 @@ CREATE TABLE action.circulation ( circ_lib INT NOT NULL, -- actor.org_unit.id circ_staff INT NOT NULL, -- actor.usr.id checkin_staff INT, -- actor.usr.id + checkin_lib INT, -- actor.org_unit.id renewal_remaining INT NOT NULL, -- derived from "circ duration" rule due_date TIMESTAMP WITH TIME ZONE NOT NULL, stop_fines_time TIMESTAMP WITH TIME ZONE, @@ -119,6 +120,9 @@ CREATE TABLE action.hold_request ( expire_time TIMESTAMP WITH TIME ZONE, target BIGINT NOT NULL, -- see hold_type current_copy BIGINT REFERENCES asset.copy (id) ON DELETE SET NULL, + fulfillment_staff INT REFERENCES actor.usr (id), + fulfillment_lib INT REFERENCES actor.org_unit (id), + request_lib INT NOT NULL REFERENCES actor.org_unit (id), requestor INT NOT NULL REFERENCES actor.usr (id), usr INT NOT NULL REFERENCES actor.usr (id), selection_depth INT NOT NULL DEFAULT 0, -- 2.43.2