Index: openacs-4/packages/project-manager/project-manager.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/project-manager/project-manager.info,v
diff -u -r1.16 -r1.17
--- openacs-4/packages/project-manager/project-manager.info	23 Aug 2005 16:39:20 -0000	1.16
+++ openacs-4/packages/project-manager/project-manager.info	26 Aug 2005 05:42:27 -0000	1.17
@@ -7,15 +7,15 @@
     <initial-install-p>f</initial-install-p>
     <singleton-p>f</singleton-p>
     
-    <version name="3.0d15" url="http://openacs.org/repository/download/apm/project-manager-3.0d15.apm">
+    <version name="3.1d1" url="http://openacs.org/repository/download/apm/project-manager-3.1d1.apm">
         <owner url="mailto:jade@rubick.com">Jade Rubick</owner>
         <summary>Project management tool for OpenACS</summary>
         <release-date>2005-08-12</release-date>
         <vendor url="mailto:jader@bread.com">Integrated Bakery Resources</vendor>
         <description format="text/plain">Track tasks, estimates and actual progress for a project.  See the &lt;a href=&quot;http://openacs.org/projects/dotwrk/project_management/&quot;&gt;project page&lt;/a&gt; for more information.</description>
         <maturity>0</maturity>
 
-        <provides url="project-manager" version="3.0d15"/>
+        <provides url="project-manager" version="3.1d1"/>
         <requires url="acs-datetime" version="4.0"/>
         <requires url="acs-subsite" version="5.1.3"/>
         <requires url="acs-templating" version="5.1.6d1"/>
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.5 -r1.6
--- openacs-4/packages/project-manager/sql/postgresql/project-manager-table-create.sql	8 Jun 2005 17:19:53 -0000	1.5
+++ openacs-4/packages/project-manager/sql/postgresql/project-manager-table-create.sql	26 Aug 2005 05:42:28 -0000	1.6
@@ -510,4 +510,37 @@
 comment on table pm_users_viewed is '
   Used to keep track of what users to see on the task calendar and other
   views.
-';
\ No newline at end of file
+';
+
+
+#### Create missing indexes
+CREATE OR REPLACE INDEX pm_workgroup_parties_party_id_inx ON pm_workgroup_parties(party_id);
+CREATE OR REPLACE INDEX pm_workgroup_parties_role_id_inx ON pm_workgroup_parties(role_id);
+CREATE OR REPLACE INDEX pm_users_viewed_viewed_user_inx ON pm_users_viewed(viewed_user);
+CREATE OR REPLACE INDEX pm_users_viewed_viewing_user_inx ON pm_users_viewed(viewing_user);
+CREATE OR REPLACE INDEX pm_tasks_process_instance_inx ON pm_tasks(process_instance);
+CREATE OR REPLACE INDEX pm_tasks_status_inx ON pm_tasks(status);
+CREATE OR REPLACE INDEX pm_task_xref_task_id_2_inx ON pm_task_xref(task_id_2);
+CREATE OR REPLACE INDEX pm_task_xref_task_id_1_inx ON pm_task_xref(task_id_1);
+CREATE OR REPLACE INDEX pm_task_logger_proj_map_logger_entry_inx ON pm_task_logger_proj_map(logger_entry);
+CREATE OR REPLACE INDEX pm_task_dependency_dependency_type_inx ON pm_task_dependency(dependency_type);
+CREATE OR REPLACE INDEX pm_task_dependency_parent_task_id_inx ON pm_task_dependency(parent_task_id);
+CREATE OR REPLACE INDEX pm_task_assignment_party_id_inx ON pm_task_assignment(party_id);
+CREATE OR REPLACE INDEX pm_task_assignment_role_id_inx ON pm_task_assignment(role_id);
+CREATE OR REPLACE INDEX pm_projects_logger_project_inx ON pm_projects(logger_project);
+CREATE OR REPLACE INDEX pm_projects_status_id_inx ON pm_projects(status_id);
+CREATE OR REPLACE INDEX pm_project_assignment_party_id_inx ON pm_project_assignment(party_id);
+CREATE OR REPLACE INDEX pm_project_assignment_role_id_inx ON pm_project_assignment(role_id);
+CREATE OR REPLACE INDEX pm_process_task_dependency_dependency_type_inx ON pm_process_task_dependency(dependency_type);
+CREATE OR REPLACE INDEX pm_process_task_dependency_parent_task_id_inx ON pm_process_task_dependency(parent_task_id);
+CREATE OR REPLACE INDEX pm_process_task_assignment_party_id_inx ON pm_process_task_assignment(party_id);
+CREATE OR REPLACE INDEX pm_process_task_assignment_role_id_inx ON pm_process_task_assignment(role_id);
+CREATE OR REPLACE INDEX pm_process_task_mime_type_inx ON pm_process_task(mime_type);
+CREATE OR REPLACE INDEX pm_process_task_process_id_inx ON pm_process_task(process_id);
+CREATE OR REPLACE INDEX pm_process_instance_project_item_id_inx ON pm_process_instance(project_item_id);
+CREATE OR REPLACE INDEX pm_process_instance_process_id_inx ON pm_process_instance(process_id);
+CREATE OR REPLACE INDEX pm_process_party_id_inx ON pm_process(party_id);
+CREATE OR REPLACE INDEX pm_default_roles_party_id_inx ON pm_default_roles(party_id);
+CREATE OR REPLACE INDEX pm_project_assignment_project_id ON pm_project_assignment(project_id);
+CREATE OR REPLACE INDEX pm_task_dependency_task_id ON pm_task_dependency(task_id);
+CREATE OR REPLACE INDEX pm_project_status_status_type_inx ON pm_project_status(status_type);
Index: openacs-4/packages/project-manager/sql/postgresql/upgrade/upgrade-3.0d15-3.1d1.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/project-manager/sql/postgresql/upgrade/Attic/upgrade-3.0d15-3.1d1.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/project-manager/sql/postgresql/upgrade/upgrade-3.0d15-3.1d1.sql	26 Aug 2005 05:43:13 -0000	1.1
@@ -0,0 +1,39 @@
+-- 
+-- Create Indexes to speed up project manager
+-- 
+-- @author Alex Kroman <alexk@bread.com>
+-- @creation-date 2005-06-24
+-- @arch-tag: 02283125-116e-44d1-b006-7810050e8a9c
+-- @cvs-id $Id: upgrade-3.0d15-3.1d1.sql,v 1.1 2005/08/26 05:43:13 maltes Exp $
+--
+
+CREATE OR REPLACE INDEX pm_workgroup_parties_party_id_inx ON pm_workgroup_parties(party_id);
+CREATE OR REPLACE INDEX pm_workgroup_parties_role_id_inx ON pm_workgroup_parties(role_id);
+CREATE OR REPLACE INDEX pm_users_viewed_viewed_user_inx ON pm_users_viewed(viewed_user);
+CREATE OR REPLACE INDEX pm_users_viewed_viewing_user_inx ON pm_users_viewed(viewing_user);
+CREATE OR REPLACE INDEX pm_tasks_process_instance_inx ON pm_tasks(process_instance);
+CREATE OR REPLACE INDEX pm_tasks_status_inx ON pm_tasks(status);
+CREATE OR REPLACE INDEX pm_task_xref_task_id_2_inx ON pm_task_xref(task_id_2);
+CREATE OR REPLACE INDEX pm_task_xref_task_id_1_inx ON pm_task_xref(task_id_1);
+CREATE OR REPLACE INDEX pm_task_logger_proj_map_logger_entry_inx ON pm_task_logger_proj_map(logger_entry);
+CREATE OR REPLACE INDEX pm_task_dependency_dependency_type_inx ON pm_task_dependency(dependency_type);
+CREATE OR REPLACE INDEX pm_task_dependency_parent_task_id_inx ON pm_task_dependency(parent_task_id);
+CREATE OR REPLACE INDEX pm_task_assignment_party_id_inx ON pm_task_assignment(party_id);
+CREATE OR REPLACE INDEX pm_task_assignment_role_id_inx ON pm_task_assignment(role_id);
+CREATE OR REPLACE INDEX pm_projects_logger_project_inx ON pm_projects(logger_project);
+CREATE OR REPLACE INDEX pm_projects_status_id_inx ON pm_projects(status_id);
+CREATE OR REPLACE INDEX pm_project_assignment_party_id_inx ON pm_project_assignment(party_id);
+CREATE OR REPLACE INDEX pm_project_assignment_role_id_inx ON pm_project_assignment(role_id);
+CREATE OR REPLACE INDEX pm_process_task_dependency_dependency_type_inx ON pm_process_task_dependency(dependency_type);
+CREATE OR REPLACE INDEX pm_process_task_dependency_parent_task_id_inx ON pm_process_task_dependency(parent_task_id);
+CREATE OR REPLACE INDEX pm_process_task_assignment_party_id_inx ON pm_process_task_assignment(party_id);
+CREATE OR REPLACE INDEX pm_process_task_assignment_role_id_inx ON pm_process_task_assignment(role_id);
+CREATE OR REPLACE INDEX pm_process_task_mime_type_inx ON pm_process_task(mime_type);
+CREATE OR REPLACE INDEX pm_process_task_process_id_inx ON pm_process_task(process_id);
+CREATE OR REPLACE INDEX pm_process_instance_project_item_id_inx ON pm_process_instance(project_item_id);
+CREATE OR REPLACE INDEX pm_process_instance_process_id_inx ON pm_process_instance(process_id);
+CREATE OR REPLACE INDEX pm_process_party_id_inx ON pm_process(party_id);
+CREATE OR REPLACE INDEX pm_default_roles_party_id_inx ON pm_default_roles(party_id);
+CREATE OR REPLACE INDEX pm_project_assignment_project_id ON pm_project_assignment(project_id);
+CREATE OR REPLACE INDEX pm_task_dependency_task_id ON pm_task_dependency(task_id);
+CREATE OR REPLACE INDEX pm_project_status_status_type_inx ON pm_project_status(status_type);