Index: openacs-4/packages/ams/ams.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ams/ams.info,v
diff -u -r1.6 -r1.7
--- openacs-4/packages/ams/ams.info	7 Jun 2005 06:53:25 -0000	1.6
+++ openacs-4/packages/ams/ams.info	15 Aug 2005 09:14:08 -0000	1.7
@@ -8,14 +8,14 @@
     <singleton-p>t</singleton-p>
     <auto-mount>ams</auto-mount>
 
-    <version name="1.1d1" url="http://openacs.org/repository/download/apm/ams-1.1d1.apm">
+    <version name="1.1d2" url="http://openacs.org/repository/download/apm/ams-1.1d2.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>2005-05-21</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.1d1"/>
+        <provides url="ams" version="1.1d2"/>
         <requires url="postal-address" version="0.1d"/>
         <requires url="ref-countries" version="0.1d"/>
         <requires url="ref-us-states" version="0.1d"/>
Index: openacs-4/packages/ams/catalog/ams.de_DE.ISO-8859-1.xml
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ams/catalog/ams.de_DE.ISO-8859-1.xml,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/ams/catalog/ams.de_DE.ISO-8859-1.xml	10 Jun 2005 21:50:53 -0000	1.3
+++ openacs-4/packages/ams/catalog/ams.de_DE.ISO-8859-1.xml	15 Aug 2005 09:14:08 -0000	1.4
@@ -12,6 +12,7 @@
   <msg key="Attribute_Name">Name des Attributs</msg>
   <msg key="Checkbox">Checkbox - Mehrere Optionen erlaubt</msg>
   <msg key="country">Land</msg>
+  <msg key="country_DE">Deutschland</msg>
   <msg key="Date">Datum</msg>
   <msg key="Define_Widget">Widget definieren</msg>
   <msg key="delivery_address">Strasse</msg>
@@ -37,25 +38,21 @@
   <msg key="Ordering">Reihenfolge</msg>
   <msg key="Package_Key">Package Key</msg>
   <msg key="postal_code">Postleitzahl</msg>
-  <msg key="Pretty_Name">Sichtbarer Name: Name</msg>
   <msg key="Pretty_Name_1">Sichtbarer Name</msg>
-  <msg key="Pretty_Plural">Sichtbarer Name im Plural:</msg>
   <msg key="Pretty_Plural_1">Sichtbarer Name im Plural</msg>
   <msg key="Preview_Input_Form">Voransicht des Formblatts</msg>
   <msg key="Radio">Radio Buttons - Eine Option erlaubt</msg>
   <msg key="region">Bundesland</msg>
   <msg key="Required">Erforderlich</msg>
   <msg key="Richtext">Textbox (WYSYWIG-Editor)</msg>
   <msg key="Select">Drop Down List - Eine Option erlaubt</msg>
-  <msg key="Sort_Order">Sortierreihenfolge</msg>
+  <msg key="select_one">Eine Gruppe ausw�hlen</msg>
   <msg key="Telecom_Number">Telefonnummer</msg>
   <msg key="Textarea">Textbox (l�ngerer Text m�glich)</msg>
   <msg key="Textbox">Textzeile</msg>
   <msg key="Unmap">Attribut entfernen</msg>
   <msg key="Unmapped_Attributes">Nicht zugewiesene Attribute</msg>
-  <msg key="Update_Options">Aktualisieren der Optionen</msg>
   <msg key="Update_Ordering">Update Reihenfolge</msg>
   <msg key="Url">Website URL</msg>
-  <msg key="Widget">Widget</msg>
   <msg key="Widget_1">Widget</msg>
 </message_catalog>
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 -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
 --------------------------------------------------------------------
Index: openacs-4/packages/ams/sql/postgresql/ams-package-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ams/sql/postgresql/ams-package-create.sql,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/ams/sql/postgresql/ams-package-create.sql	18 May 2005 17:11:48 -0000	1.5
+++ openacs-4/packages/ams/sql/postgresql/ams-package-create.sql	15 Aug 2005 09:14:08 -0000	1.6
@@ -327,7 +327,7 @@
 returns integer as '
 declare
         p_ams_value__options    alias for $1;
-        v_value_id              integer
+        v_value_id              integer;
 begin
 
         v_value_id := value_id
Index: openacs-4/packages/ams/sql/postgresql/upgrade/upgrade-1.1d1-1.1d2.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ams/sql/postgresql/upgrade/upgrade-1.1d1-1.1d2.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/ams/sql/postgresql/upgrade/upgrade-1.1d1-1.1d2.sql	15 Aug 2005 09:14:08 -0000	1.1
@@ -0,0 +1,10 @@
+-- 
+-- packages/ams/sql/postgresql/upgrade/upgrade-1.1d1-1.1d2.sql
+-- 
+-- @author Malte Sussdorff (sussdorff@sussdorff.de)
+-- @creation-date 2005-08-15
+-- @arch-tag: 8da2f2cc-356f-400d-bbdd-9795acbf6190
+-- @cvs-id $Id: upgrade-1.1d1-1.1d2.sql,v 1.1 2005/08/15 09:14:08 maltes Exp $
+--
+
+create index ams_attribute_values_attribute_idx on ams_attribute_values(attribute_id);
\ No newline at end of file