From fb3a1c237f083383c7e83f5b48763013f8f5b2c5 Mon Sep 17 00:00:00 2001 From: scottmk Date: Thu, 11 Jun 2009 20:43:07 +0000 Subject: [PATCH] Add index so that we can readily find all the items in a given copy_bucket. git-svn-id: svn://svn.open-ils.org/ILS/trunk@13373 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/070.schema.container.sql | 1 + 1 file changed, 1 insertion(+) diff --git a/Open-ILS/src/sql/Pg/070.schema.container.sql b/Open-ILS/src/sql/Pg/070.schema.container.sql index f10545df8..16e8fbd9c 100644 --- a/Open-ILS/src/sql/Pg/070.schema.container.sql +++ b/Open-ILS/src/sql/Pg/070.schema.container.sql @@ -63,6 +63,7 @@ CREATE TABLE container.copy_bucket_item ( pos INT, create_time TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW() ); +CREATE INDEX copy_bucket_item_bucket_idx ON container.copy_bucket_item (bucket); CREATE TABLE container.copy_bucket_item_note ( id SERIAL PRIMARY KEY, -- 2.11.0