Index: openacs-4/packages/assessment/assessment.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/assessment.info,v
diff -u -r1.51.2.9 -r1.51.2.10
--- openacs-4/packages/assessment/assessment.info	24 Oct 2014 13:16:10 -0000	1.51.2.9
+++ openacs-4/packages/assessment/assessment.info	22 Feb 2015 21:59:44 -0000	1.51.2.10
@@ -7,7 +7,7 @@
     <initial-install-p>f</initial-install-p>
     <singleton-p>f</singleton-p>
     
-    <version name="2.8.1" url="http://openacs.org/repository/download/apm/assessment-2.8.1.apm">
+    <version name="2.8.2d1" url="http://openacs.org/repository/download/apm/assessment-2.8.2d1.apm">
         <owner url="mailto:eperez@it.uc3m.es">Eduardo Perez Ureta</owner>
         <summary>Assessment package that will replace the surveys
     quizz, complex survey, poll and other data collection packages
@@ -18,7 +18,7 @@
         <maturity>2</maturity>
         <package_instance_name>#assessment.Assessment#</package_instance_name>
 
-        <provides url="assessment" version="2.8.1"/>
+        <provides url="assessment" version="2.8.2d1"/>
         <requires url="acs-content-repository" version="5.8.1"/>
         <requires url="acs-kernel" version="5.8.1"/>
         <requires url="acs-templating" version="5.8.1"/>
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.12 -r1.12.2.1
--- openacs-4/packages/assessment/sql/oracle/assessment-collected-data-create.sql	10 Oct 2009 22:38:09 -0000	1.12
+++ openacs-4/packages/assessment/sql/oracle/assessment-collected-data-create.sql	22 Feb 2015 21:59:44 -0000	1.12.2.1
@@ -148,7 +148,13 @@
 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 index as_item_data_content_answer_idx on as_item_data(content_answer);
+create index as_item_data_file_id_idx on as_item_data(file_id);
+create index as_item_data_section_id_idx on as_item_data(section_id);
+create index as_item_data_staff_id_idx on as_item_data(staff_id);
 
+
+
 create or replace trigger as_item_data_ins_trg
 before insert on as_item_data
 for each row
Index: openacs-4/packages/assessment/sql/oracle/assessment-item-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/oracle/assessment-item-create.sql,v
diff -u -r1.6 -r1.6.4.1
--- openacs-4/packages/assessment/sql/oracle/assessment-item-create.sql	9 Sep 2008 17:28:22 -0000	1.6
+++ openacs-4/packages/assessment/sql/oracle/assessment-item-create.sql	22 Feb 2015 21:59:44 -0000	1.6.4.1
@@ -81,6 +81,8 @@
 );
 
 create index as_i_choices_order_idx on as_item_choices (mc_id, sort_order);
+create index as_i_choices_cv_idx on as_item_choices(content_value);
+create index as_i_choices_mc_id_idx on as_item_choices(mc_id);
 
 -- Short Answer Answers
 create table as_item_sa_answers (
Index: openacs-4/packages/assessment/sql/oracle/assessment-types-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/oracle/assessment-types-create.sql,v
diff -u -r1.4 -r1.4.6.1
--- openacs-4/packages/assessment/sql/oracle/assessment-types-create.sql	15 May 2007 20:14:16 -0000	1.4
+++ openacs-4/packages/assessment/sql/oracle/assessment-types-create.sql	22 Feb 2015 21:59:44 -0000	1.4.6.1
@@ -58,3 +58,7 @@
 	constraint as_item_rels_pk
 	primary key (item_rev_id, rel_type, target_rev_id)
 );
+
+create index as_item_rels_item_rev_id_idx on as_item_rels(item_rev_id);
+create index as_item_rels_target_rev_id_idx on as_item_rels(target_rev_id);
+
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-2.8.1-2.8.2d1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
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.19.2.1 -r1.19.2.2
--- openacs-4/packages/assessment/sql/postgresql/assessment-collected-data-create.sql	18 Aug 2014 20:37:48 -0000	1.19.2.1
+++ openacs-4/packages/assessment/sql/postgresql/assessment-collected-data-create.sql	22 Feb 2015 21:59:45 -0000	1.19.2.2
@@ -146,6 +146,10 @@
 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 index as_item_data_content_answer_idx on as_item_data(content_answer);
+create index as_item_data_file_id_idx on as_item_data(file_id);
+create index as_item_data_section_id_idx on as_item_data(section_id);
+create index as_item_data_staff_id_idx on as_item_data(staff_id);
 
 
 
Index: openacs-4/packages/assessment/sql/postgresql/assessment-item-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/postgresql/assessment-item-create.sql,v
diff -u -r1.19 -r1.19.4.1
--- openacs-4/packages/assessment/sql/postgresql/assessment-item-create.sql	9 Sep 2008 17:28:22 -0000	1.19
+++ openacs-4/packages/assessment/sql/postgresql/assessment-item-create.sql	22 Feb 2015 21:59:45 -0000	1.19.4.1
@@ -81,6 +81,8 @@
 );
 
 create index as_item_choices_sort_order_idx on as_item_choices (mc_id, sort_order);
+create index as_item_choices_content_value_idx on as_item_choices(content_value);
+create index as_item_choices_mc_id_idx on as_item_choices(mc_id);
 
 -- Short Answer Answers
 create table as_item_sa_answers (
Index: openacs-4/packages/assessment/sql/postgresql/assessment-types-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/postgresql/assessment-types-create.sql,v
diff -u -r1.5 -r1.5.6.1
--- openacs-4/packages/assessment/sql/postgresql/assessment-types-create.sql	15 May 2007 20:14:16 -0000	1.5
+++ openacs-4/packages/assessment/sql/postgresql/assessment-types-create.sql	22 Feb 2015 21:59:45 -0000	1.5.6.1
@@ -58,3 +58,7 @@
 	constraint as_item_rels_pk
 	primary key (item_rev_id, rel_type, target_rev_id)
 );
+
+create index as_item_rels_item_rev_id_idx on as_item_rels(item_rev_id);
+create index as_item_rels_target_rev_id_idx on as_item_rels(target_rev_id);
+
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-2.8.1-2.8.2d1.sql'.
Fisheye: No comparison available.  Pass `N' to diff?