From 6bfbe649b1216d036f6c05a705e2543b9ba2f272 Mon Sep 17 00:00:00 2001
From: dbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Date: Wed, 24 Nov 2010 20:11:05 +0000
Subject: [PATCH] Add the asset.copy(create_date) index to the 1.6.1-2.0 update
 script

git-svn-id: svn://svn.open-ils.org/ILS/trunk@18847 dcc99617-32d9-48b4-a31d-7c20da2025e4
---
 Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql | 2 ++
 1 file changed, 2 insertions(+)

diff --git a/Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql b/Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql
index 7d3f43c5bd..5dae9d7ef1 100644
--- a/Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql
+++ b/Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql
@@ -19152,6 +19152,8 @@ INSERT INTO action_trigger.event_definition (
     )
 ;
 
+-- Speed up item-age browse axis (new books feed)
+CREATE INDEX cp_create_date  ON asset.copy (create_date);
 
 \qecho Upgrade script completed.
 \qecho But wait, there's more: please run reingest-1.6-2.0.pl
-- 
2.11.0