From 79218f82ea13c43faec2772b9c99e5f76a3c7cb2 Mon Sep 17 00:00:00 2001 From: miker Date: Tue, 26 Jul 2005 17:34:38 +0000 Subject: [PATCH] schema tweaks git-svn-id: svn://svn.open-ils.org/ILS/trunk@1496 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/030.schema.metabib.sql | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/Open-ILS/src/sql/Pg/030.schema.metabib.sql b/Open-ILS/src/sql/Pg/030.schema.metabib.sql index d9436cc347..d167964470 100644 --- a/Open-ILS/src/sql/Pg/030.schema.metabib.sql +++ b/Open-ILS/src/sql/Pg/030.schema.metabib.sql @@ -23,7 +23,7 @@ CREATE TRIGGER metabib_title_field_entry_fti_trigger BEFORE UPDATE OR INSERT ON metabib.title_field_entry FOR EACH ROW EXECUTE PROCEDURE tsearch2(index_vector, value); -CREATE INDEX metabib_title_field_entry_index_vector_idx ON (metabib.title_field_entry) USING GIST (index_vector); +CREATE INDEX metabib_title_field_entry_index_vector_idx ON metabib.title_field_entry USING GIST (index_vector); CREATE TABLE metabib.author_field_entry ( @@ -37,7 +37,7 @@ CREATE TRIGGER metabib_author_field_entry_fti_trigger BEFORE UPDATE OR INSERT ON metabib.author_field_entry FOR EACH ROW EXECUTE PROCEDURE tsearch2(index_vector, value); -CREATE INDEX metabib_author_field_entry_index_vector_idx ON (metabib.author_field_entry) USING GIST (index_vector); +CREATE INDEX metabib_author_field_entry_index_vector_idx ON metabib.author_field_entry USING GIST (index_vector); CREATE TABLE metabib.subject_field_entry ( @@ -51,7 +51,7 @@ CREATE TRIGGER metabib_subject_field_entry_fti_trigger BEFORE UPDATE OR INSERT ON metabib.subject_field_entry FOR EACH ROW EXECUTE PROCEDURE tsearch2(index_vector, value); -CREATE INDEX metabib_subject_field_entry_index_vector_idx ON (metabib.subject_field_entry) USING GIST (index_vector); +CREATE INDEX metabib_subject_field_entry_index_vector_idx ON metabib.subject_field_entry USING GIST (index_vector); CREATE TABLE metabib.keyword_field_entry ( @@ -65,7 +65,7 @@ CREATE TRIGGER metabib_keyword_field_entry_fti_trigger BEFORE UPDATE OR INSERT ON metabib.keyword_field_entry FOR EACH ROW EXECUTE PROCEDURE tsearch2(index_vector, value); -CREATE INDEX metabib_keyword_field_entry_index_vector_idx ON (metabib.keyword_field_entry) USING GIST (index_vector); +CREATE INDEX metabib_keyword_field_entry_index_vector_idx ON metabib.keyword_field_entry USING GIST (index_vector); CREATE TABLE metabib.series_field_entry ( @@ -79,7 +79,7 @@ CREATE TRIGGER metabib_series_field_entry_fti_trigger BEFORE UPDATE OR INSERT ON metabib.series_field_entry FOR EACH ROW EXECUTE PROCEDURE tsearch2(index_vector, value); -CREATE INDEX metabib_series_field_entry_index_vector_idx ON (metabib.series_field_entry) USING GIST (index_vector); +CREATE INDEX metabib_series_field_entry_index_vector_idx ON metabib.series_field_entry USING GIST (index_vector); CREATE TABLE metabib.rec_descriptor ( @@ -128,7 +128,7 @@ CREATE TRIGGER metabib_full_rec_fti_trigger BEFORE UPDATE OR INSERT ON metabib.full_rec FOR EACH ROW EXECUTE PROCEDURE tsearch2(index_vector, value); -CREATE INDEX metabib_full_rec_index_vector_idx ON (metabib.full_rec) USING GIST (index_vector); +CREATE INDEX metabib_full_rec_index_vector_idx ON metabib.full_rec USING GIST (index_vector); CREATE TABLE metabib.metarecord_source_map ( -- 2.43.2