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);