Index: openacs-4/packages/evaluation/sql/postgresql/evaluation-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/sql/postgresql/evaluation-create.sql,v
diff -u -r1.13 -r1.14
--- openacs-4/packages/evaluation/sql/postgresql/evaluation-create.sql	13 Aug 2004 17:09:54 -0000	1.13
+++ openacs-4/packages/evaluation/sql/postgresql/evaluation-create.sql	24 Aug 2004 22:40:30 -0000	1.14
@@ -18,6 +18,8 @@
 				check (weight between 0 and 100)
 );
 
+create index evalutaion_grades_giid_index on evaluation_grades(grade_item_id);
+
 select content_type__create_type (
 	'evaluation_grades',			-- content_type
 	'content_revision',			-- super_type
@@ -66,6 +68,7 @@
 );
 
 create index evalutaion_tasks_gid_index on evaluation_tasks(grade_item_id);
+create index evalutaion_tasks_tiid_index on evaluation_tasks(task_item_id);
 
 select content_type__create_type (
 	'evaluation_tasks',			-- content_type