Index: openacs-4/packages/assessment/assessment.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/assessment.info,v
diff -u -r1.40 -r1.41
--- openacs-4/packages/assessment/assessment.info	4 Aug 2006 19:06:02 -0000	1.40
+++ openacs-4/packages/assessment/assessment.info	16 Oct 2006 13:17:04 -0000	1.41
@@ -7,7 +7,7 @@
     <initial-install-p>f</initial-install-p>
     <singleton-p>f</singleton-p>
     
-    <version name="0.21" url="http://openacs.org/repository/download/apm/assessment-0.21.apm">
+    <version name="0.22d2" url="http://openacs.org/repository/download/apm/assessment-0.22d2.apm">
         <owner url="mailto:eperez@it.uc3m.es">Eduardo Perez Ureta</owner>
         <summary>Assessment package that will replace the survey,
     quizz, complex survey, poll and other data collection packages
@@ -17,10 +17,10 @@
         <description format="text/plain">Create assessments and evaluate.</description>
         <maturity>0</maturity>
 
-        <provides url="assessment" version="0.20"/>
-        <requires url="acs-content-repository" version="5.1.4d3"/>
-        <requires url="acs-kernel" version="5.0d13"/>
-        <requires url="acs-templating" version="5.1.5d1"/>
+        <provides url="assessment" version="0.22d2"/>
+        <requires url="acs-content-repository" version="5.3.0d1"/>
+        <requires url="acs-kernel" version="5.3.0d1"/>
+        <requires url="acs-templating" version="5.3.0d11"/>
         <requires url="categories" version="1.0d5"/>
         <requires url="notifications" version="0.1"/>
         <callbacks>
Index: openacs-4/packages/assessment/sql/oracle/assessment-collected-data-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/oracle/assessment-collected-data-create.sql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/assessment/sql/oracle/assessment-collected-data-create.sql	21 Feb 2005 14:32:55 -0000	1.4
+++ openacs-4/packages/assessment/sql/oracle/assessment-collected-data-create.sql	16 Oct 2006 13:17:04 -0000	1.5
@@ -125,7 +125,7 @@
 create index as_item_data_pk2 on as_item_data (session_id, section_id, as_item_id);
 create index as_item_data_pk3 on as_item_data (as_item_id, section_id, session_id);
 create index as_item_data_subj_idx on as_item_data (subject_id);
-
+create index as_item_data_as_item_id_idx on as_item_data (as_item_id);
 create table as_session_results (
        result_id   integer
                    constraint as_sess_res_res_id_pk
Index: openacs-4/packages/assessment/sql/postgresql/assessment-collected-data-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/postgresql/assessment-collected-data-create.sql,v
diff -u -r1.10 -r1.11
--- openacs-4/packages/assessment/sql/postgresql/assessment-collected-data-create.sql	12 Jun 2006 02:49:50 -0000	1.10
+++ openacs-4/packages/assessment/sql/postgresql/assessment-collected-data-create.sql	16 Oct 2006 13:17:04 -0000	1.11
@@ -126,6 +126,7 @@
 create index as_item_data_pk2 on as_item_data (session_id, section_id, as_item_id);
 create index as_item_data_pk3 on as_item_data (as_item_id, section_id, session_id);
 create index as_item_data_subject_id_idx on as_item_data (subject_id);
+create index as_item_data_as_item_id_idx on as_item_data (as_item_id);
 
 create table as_session_results (
        result_id   integer