Index: openacs-4/packages/project-manager/sql/postgresql/project-manager-table-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/project-manager/sql/postgresql/project-manager-table-create.sql,v
diff -u -r1.9 -r1.10
--- openacs-4/packages/project-manager/sql/postgresql/project-manager-table-create.sql	4 Sep 2005 10:03:59 -0000	1.9
+++ openacs-4/packages/project-manager/sql/postgresql/project-manager-table-create.sql	15 Sep 2005 07:42:06 -0000	1.10
@@ -135,6 +135,9 @@
         unique (project_id, role_id, party_id)
 );
 
+create index pm_project_assignment_role_id_idx on pm_project_assignment(role_id);
+create index pm_project_assignment_project_id_idx on pm_project_assignment(project_id);
+create index pm_project_assignment_party_id_idx on pm_project_assignment(party_id);
 
 comment on table pm_project_assignment is '
   Maps who is a part of what project, and in what capacity