Index: openacs-4/packages/ams/sql/postgresql/ams-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ams/sql/postgresql/ams-create.sql,v
diff -u -N -r1.6 -r1.7
--- openacs-4/packages/ams/sql/postgresql/ams-create.sql	28 May 2005 15:37:27 -0000	1.6
+++ openacs-4/packages/ams/sql/postgresql/ams-create.sql	15 Aug 2005 09:14:08 -0000	1.7
@@ -142,8 +142,6 @@
 ------ Attribute Values
 --------------------------------------------------------------------
 
-
-
 create table ams_attribute_values (
         object_id               integer
                                 constraint ams_attribute_values_object_id_fk references acs_objects(object_id)
@@ -155,6 +153,7 @@
                                 constraint ams_attribute_values_nn not null
 );
 
+create index ams_attribute_values_attribute_idx on ams_attribute_values(attribute_id);
 
 ------ Options
 --------------------------------------------------------------------
