From aa5a7fa5c539aea837e483874887e4cec3797ec4 Mon Sep 17 00:00:00 2001 From: miker Date: Tue, 29 Aug 2006 06:36:18 +0000 Subject: [PATCH] adding some useful indexes git-svn-id: svn://svn.open-ils.org/ILS/trunk@5755 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/090.schema.action.sql | 6 ++++++ 1 file changed, 6 insertions(+) diff --git a/Open-ILS/src/sql/Pg/090.schema.action.sql b/Open-ILS/src/sql/Pg/090.schema.action.sql index 84eccec872..7e6c61f547 100644 --- a/Open-ILS/src/sql/Pg/090.schema.action.sql +++ b/Open-ILS/src/sql/Pg/090.schema.action.sql @@ -179,6 +179,12 @@ CREATE TABLE action.hold_request ( email_notify BOOL NOT NULL DEFAULT TRUE ); +CREATE INDEX hold_request_target_idx ON action.hold_request (target); +CREATE INDEX hold_request_usr_idx ON action.hold_request (usr); +CREATE INDEX hold_request_pickup_lib_idx ON action.hold_request (pickup_lib); +CREATE INDEX hold_request_current_copy_idx ON action.hold_request (current_copy); +CREATE INDEX hold_request_prev_check_time_idx ON action.hold_request (prev_check_time); + CREATE TABLE action.hold_notification ( id SERIAL PRIMARY KEY, -- 2.11.0