From 8729c4b115faa38b8172818f392d825deb29e95c Mon Sep 17 00:00:00 2001 From: miker Date: Fri, 12 Jan 2007 05:58:16 +0000 Subject: [PATCH] indexes supporting collections queries git-svn-id: svn://svn.open-ils.org/ILS/trunk@6759 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/080.schema.money.sql | 2 ++ Open-ILS/src/sql/Pg/090.schema.action.sql | 2 ++ 2 files changed, 4 insertions(+) diff --git a/Open-ILS/src/sql/Pg/080.schema.money.sql b/Open-ILS/src/sql/Pg/080.schema.money.sql index 9a070d0e8a..448fae2486 100644 --- a/Open-ILS/src/sql/Pg/080.schema.money.sql +++ b/Open-ILS/src/sql/Pg/080.schema.money.sql @@ -26,6 +26,8 @@ CREATE TABLE money.grocery ( -- Catchall table for local billing note TEXT ) INHERITS (money.billable_xact); ALTER TABLE money.grocery ADD PRIMARY KEY (id); +CREATE INDEX circ_open_date_idx ON "money".grocery (xact_start) WHERE xact_finish IS NULL; +CREATE INDEX m_g_usr_idx ON "money".grocery (usr); CREATE TABLE money.billing ( id BIGSERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/090.schema.action.sql b/Open-ILS/src/sql/Pg/090.schema.action.sql index c3fc5ca1d3..866f8f749f 100644 --- a/Open-ILS/src/sql/Pg/090.schema.action.sql +++ b/Open-ILS/src/sql/Pg/090.schema.action.sql @@ -105,6 +105,8 @@ ALTER TABLE action.circulation ADD PRIMARY KEY (id); 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 INDEX circ_circ_lib_idx ON "action".circulation (circ_lib); +CREATE INDEX circ_open_date_idx ON "action".circulation (xact_start) WHERE xact_finish IS NULL; CREATE OR REPLACE VIEW action.open_circulation AS -- 2.11.0