From 1f6442c64330d30a74ee6a57f6de119304ea529e Mon Sep 17 00:00:00 2001 From: miker Date: Tue, 12 Jul 2005 19:11:14 +0000 Subject: [PATCH] updating transit schema git-svn-id: svn://svn.open-ils.org/ILS/trunk@1148 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Postgres/090.schema.action.sql | 9 ++++++--- 1 file changed, 6 insertions(+), 3 deletions(-) diff --git a/Open-ILS/src/sql/Postgres/090.schema.action.sql b/Open-ILS/src/sql/Postgres/090.schema.action.sql index e2c7c61039..9362d900f2 100644 --- a/Open-ILS/src/sql/Postgres/090.schema.action.sql +++ b/Open-ILS/src/sql/Postgres/090.schema.action.sql @@ -126,16 +126,19 @@ CREATE TABLE action.hold_copy_map ( CONSTRAINT copy_once_per_hold UNIQUE (hold,target_copy) ); -CREATE TABLE action.hold_transit_copy ( +CREATE TABLE action.transit_copy ( id SERIAL PRIMARY KEY, - hold INT NOT NULL REFERENCES action.hold_request (id), source INT NOT NULL REFERENCES actor.org_unit (id), dest INT NOT NULL REFERENCES actor.org_unit (id), persistant_transfer BOOL NOT NULL DEFAULT FALSE, source_send_time TIMESTAMP WITH TIME ZONE, dest_recv_time TIMESTAMP WITH TIME ZONE, - prev_hop INT REFERENCES action.hold_transit_copy (id) + prev_hop INT REFERENCES action.transit_copy (id) ); +CREATE TABLE action.hold_transit_copy ( + hold INT NOT NULL REFERENCES action.hold_request (id) +) INHERITS (action.transit_copy); + COMMIT; -- 2.11.0