From 3927ea4c0ab5666711b2907f8eed415946adf169 Mon Sep 17 00:00:00 2001 From: miker Date: Fri, 17 Feb 2006 04:04:42 +0000 Subject: [PATCH] adding useful indexes git-svn-id: svn://svn.open-ils.org/ILS/trunk@3100 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/090.schema.action.sql | 3 +++ 1 file changed, 3 insertions(+) diff --git a/Open-ILS/src/sql/Pg/090.schema.action.sql b/Open-ILS/src/sql/Pg/090.schema.action.sql index 26fe0d4396..b37dc80ede 100644 --- a/Open-ILS/src/sql/Pg/090.schema.action.sql +++ b/Open-ILS/src/sql/Pg/090.schema.action.sql @@ -94,6 +94,9 @@ CREATE TABLE action.circulation ( stop_fines TEXT CHECK (stop_fines IN ('CHECKIN','CLAIMSRETURNED','LOST','MAXFINES','RENEW','LONGOVERDUE')) ) INHERITS (money.billable_xact); CREATE INDEX circ_open_xacts_idx ON action.circulation (usr) WHERE xact_finish IS NULL; +CREATE INDEX circ_outstanding_idx ON action.circulation (usr) WHERE checkin_time IS NULL; +CREATE INDEX circ_checkin_time ON "action".circulation (checkin_time) WHERE checkin_time IS NOT NULL; + CREATE OR REPLACE VIEW action.open_circulation AS SELECT * -- 2.43.2