From f9ecd1cacd4ec55e6ee4ebf142b71f696ad7d113 Mon Sep 17 00:00:00 2001 From: miker Date: Wed, 30 Jul 2008 05:18:29 +0000 Subject: [PATCH] a couple useful indexes git-svn-id: svn://svn.open-ils.org/ILS/branches/acq-experiment@10184 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/200.schema.acq.sql | 2 ++ 1 file changed, 2 insertions(+) diff --git a/Open-ILS/src/sql/Pg/200.schema.acq.sql b/Open-ILS/src/sql/Pg/200.schema.acq.sql index 41f1864bfd..14d293c3a8 100644 --- a/Open-ILS/src/sql/Pg/200.schema.acq.sql +++ b/Open-ILS/src/sql/Pg/200.schema.acq.sql @@ -209,6 +209,8 @@ CREATE TABLE acq.lineitem_attr ( ); CREATE INDEX li_attr_li_idx ON acq.lineitem_attr (lineitem); +CREATE INDEX li_attr_value_idx ON acq.lineitem_attr (value); +CREATE INDEX li_attr_definition_idx ON acq.lineitem_attr (definition); -- Seed data -- 2.11.0