Index: openacs-4/packages/ams/ams.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ams/ams.info,v
diff -u -N -r1.22 -r1.23
--- openacs-4/packages/ams/ams.info	26 Apr 2006 06:24:54 -0000	1.22
+++ openacs-4/packages/ams/ams.info	16 May 2006 06:21:16 -0000	1.23
@@ -8,14 +8,14 @@
     <singleton-p>t</singleton-p>
     <auto-mount>ams</auto-mount>
 
-    <version name="1.1d15" url="http://openacs.org/repository/download/apm/ams-1.1d15.apm">
+    <version name="1.1d16" url="http://openacs.org/repository/download/apm/ams-1.1d16.apm">
         <owner url="mailto:openacs@geddert.com">Matthew Geddert</owner>
         <summary>Store attributes via the Content Repository, and auto generate input forms</summary>
         <release-date>2006-02-17</release-date>
         <description format="text/html">AMS (Attribute Management System) helps in customizing your website. It lets you adjust what information is collected and displayed for any package that is integrated with it. AMS allows you to easily and dynamically add attributes to forms and display pages, using a Tcl API or an admin interface. AMS uses the content repository to store attribute history for any object on the system.</description>
         <maturity>0</maturity>
 
-        <provides url="ams" version="1.1d15"/>
+        <provides url="ams" version="1.1d16"/>
         <requires url="acs-lang" version="5.1.5d1"/>
         <requires url="postal-address" version="0.1d"/>
         <requires url="ref-countries" version="0.1d"/>
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.9 -r1.10
--- openacs-4/packages/ams/sql/postgresql/ams-create.sql	9 Feb 2006 20:46:42 -0000	1.9
+++ openacs-4/packages/ams/sql/postgresql/ams-create.sql	16 May 2006 06:21:16 -0000	1.10
@@ -155,6 +155,7 @@
 );
 
 create index ams_attribute_values_attribute_idx on ams_attribute_values(attribute_id);
+create index ams_attribute_values_attribute_object_idx on ams_attribute_values(object_id,attribute_id);
 
 ------ Options
 --------------------------------------------------------------------
Index: openacs-4/packages/ams/sql/postgresql/upgrade/upgrade-1.1d15-1.1d16.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ams/sql/postgresql/upgrade/upgrade-1.1d15-1.1d16.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/ams/sql/postgresql/upgrade/upgrade-1.1d15-1.1d16.sql	16 May 2006 06:21:16 -0000	1.1
@@ -0,0 +1,2 @@
+-- This one is LONG overdue
+create index ams_attribute_values_attribute_object_idx on ams_attribute_values(object_id,attribute_id);
\ No newline at end of file