From cb260f1386a141d6becd64f421052c418d3d9152 Mon Sep 17 00:00:00 2001 From: miker Date: Fri, 1 Sep 2006 06:07:25 +0000 Subject: [PATCH] adding some indexes for transits git-svn-id: svn://svn.open-ils.org/ILS/trunk@5828 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/090.schema.action.sql | 9 +++++++++ 1 file changed, 9 insertions(+) diff --git a/Open-ILS/src/sql/Pg/090.schema.action.sql b/Open-ILS/src/sql/Pg/090.schema.action.sql index 7e6c61f547..c3fc5ca1d3 100644 --- a/Open-ILS/src/sql/Pg/090.schema.action.sql +++ b/Open-ILS/src/sql/Pg/090.schema.action.sql @@ -216,11 +216,20 @@ CREATE TABLE action.transit_copy ( copy_status INT NOT NULL REFERENCES config.copy_status (id), persistant_transfer BOOL NOT NULL DEFAULT FALSE ); +CREATE INDEX active_transit_dest_idx ON "action".transit_copy (dest); +CREATE INDEX active_transit_source_idx ON "action".transit_copy (source); +CREATE INDEX active_transit_cp_idx ON "action".transit_copy (target_copy); + CREATE TABLE action.hold_transit_copy ( hold INT REFERENCES action.hold_request (id) ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED ) INHERITS (action.transit_copy); ALTER TABLE action.hold_transit_copy ADD PRIMARY KEY (id); +ALTER TABLE action.hold_transit_copy ADD CONSTRAINT ahtc_tc_fkey FOREIGN KEY (target_copy) REFERENCES asset.copy (id) ON DELETE CASCADE; +CREATE INDEX active_hold_transit_dest_idx ON "action".hold_transit_copy (dest); +CREATE INDEX active_hold_transit_source_idx ON "action".hold_transit_copy (source); +CREATE INDEX active_hold_transit_cp_idx ON "action".hold_transit_copy (target_copy); + CREATE TABLE action.unfulfilled_hold_list ( id BIGSERIAL PRIMARY KEY, -- 2.43.2