From 52753684600da50b12a56ce2210990b92b5fc204 Mon Sep 17 00:00:00 2001 From: miker Date: Fri, 20 Jun 2008 19:31:12 +0000 Subject: [PATCH] adding tag,subfield index by default git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_1_2_2@9900 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/030.schema.metabib.sql | 1 + 1 file changed, 1 insertion(+) diff --git a/Open-ILS/src/sql/Pg/030.schema.metabib.sql b/Open-ILS/src/sql/Pg/030.schema.metabib.sql index 27f2586618..42d0632491 100644 --- a/Open-ILS/src/sql/Pg/030.schema.metabib.sql +++ b/Open-ILS/src/sql/Pg/030.schema.metabib.sql @@ -145,6 +145,7 @@ CREATE TABLE metabib.full_rec ( value TEXT NOT NULL, index_vector tsvector NOT NULL ); +CREATE INDEX metabib_full_rec_tag_subfield_idx ON metabib.full_rec (tag,subfield); CREATE INDEX metabib_full_rec_record_idx ON metabib.full_rec (record); CREATE TRIGGER metabib_full_rec_fti_trigger BEFORE UPDATE OR INSERT ON metabib.full_rec -- 2.11.0