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.6 -r1.7
--- openacs-4/packages/project-manager/sql/postgresql/project-manager-table-create.sql	26 Aug 2005 05:42:28 -0000	1.6
+++ openacs-4/packages/project-manager/sql/postgresql/project-manager-table-create.sql	26 Aug 2005 05:46:32 -0000	1.7
@@ -514,33 +514,33 @@
 
 
 #### 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);
+CREATE INDEX pm_workgroup_parties_party_id_inx ON pm_workgroup_parties(party_id);
+CREATE INDEX pm_workgroup_parties_role_id_inx ON pm_workgroup_parties(role_id);
+CREATE INDEX pm_users_viewed_viewed_user_inx ON pm_users_viewed(viewed_user);
+CREATE INDEX pm_users_viewed_viewing_user_inx ON pm_users_viewed(viewing_user);
+CREATE INDEX pm_tasks_process_instance_inx ON pm_tasks(process_instance);
+CREATE INDEX pm_tasks_status_inx ON pm_tasks(status);
+CREATE INDEX pm_task_xref_task_id_2_inx ON pm_task_xref(task_id_2);
+CREATE INDEX pm_task_xref_task_id_1_inx ON pm_task_xref(task_id_1);
+CREATE INDEX pm_task_logger_proj_map_logger_entry_inx ON pm_task_logger_proj_map(logger_entry);
+CREATE INDEX pm_task_dependency_dependency_type_inx ON pm_task_dependency(dependency_type);
+CREATE INDEX pm_task_dependency_parent_task_id_inx ON pm_task_dependency(parent_task_id);
+CREATE INDEX pm_task_assignment_party_id_inx ON pm_task_assignment(party_id);
+CREATE INDEX pm_task_assignment_role_id_inx ON pm_task_assignment(role_id);
+CREATE INDEX pm_projects_logger_project_inx ON pm_projects(logger_project);
+CREATE INDEX pm_projects_status_id_inx ON pm_projects(status_id);
+CREATE INDEX pm_project_assignment_party_id_inx ON pm_project_assignment(party_id);
+CREATE INDEX pm_project_assignment_role_id_inx ON pm_project_assignment(role_id);
+CREATE INDEX pm_process_task_dependency_dependency_type_inx ON pm_process_task_dependency(dependency_type);
+CREATE INDEX pm_process_task_dependency_parent_task_id_inx ON pm_process_task_dependency(parent_task_id);
+CREATE INDEX pm_process_task_assignment_party_id_inx ON pm_process_task_assignment(party_id);
+CREATE INDEX pm_process_task_assignment_role_id_inx ON pm_process_task_assignment(role_id);
+CREATE INDEX pm_process_task_mime_type_inx ON pm_process_task(mime_type);
+CREATE INDEX pm_process_task_process_id_inx ON pm_process_task(process_id);
+CREATE INDEX pm_process_instance_project_item_id_inx ON pm_process_instance(project_item_id);
+CREATE INDEX pm_process_instance_process_id_inx ON pm_process_instance(process_id);
+CREATE INDEX pm_process_party_id_inx ON pm_process(party_id);
+CREATE INDEX pm_default_roles_party_id_inx ON pm_default_roles(party_id);
+CREATE INDEX pm_project_assignment_project_id ON pm_project_assignment(project_id);
+CREATE INDEX pm_task_dependency_task_id ON pm_task_dependency(task_id);
+CREATE 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 -r1.1 -r1.2
--- openacs-4/packages/project-manager/sql/postgresql/upgrade/upgrade-3.0d15-3.1d1.sql	26 Aug 2005 05:43:13 -0000	1.1
+++ openacs-4/packages/project-manager/sql/postgresql/upgrade/upgrade-3.0d15-3.1d1.sql	26 Aug 2005 05:46:32 -0000	1.2
@@ -7,33 +7,33 @@
 -- @cvs-id $Id$
 --
 
-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);
+CREATE  INDEX pm_workgroup_parties_party_id_inx ON pm_workgroup_parties(party_id);
+CREATE  INDEX pm_workgroup_parties_role_id_inx ON pm_workgroup_parties(role_id);
+CREATE  INDEX pm_users_viewed_viewed_user_inx ON pm_users_viewed(viewed_user);
+CREATE  INDEX pm_users_viewed_viewing_user_inx ON pm_users_viewed(viewing_user);
+CREATE  INDEX pm_tasks_process_instance_inx ON pm_tasks(process_instance);
+CREATE  INDEX pm_tasks_status_inx ON pm_tasks(status);
+CREATE  INDEX pm_task_xref_task_id_2_inx ON pm_task_xref(task_id_2);
+CREATE  INDEX pm_task_xref_task_id_1_inx ON pm_task_xref(task_id_1);
+CREATE  INDEX pm_task_logger_proj_map_logger_entry_inx ON pm_task_logger_proj_map(logger_entry);
+CREATE  INDEX pm_task_dependency_dependency_type_inx ON pm_task_dependency(dependency_type);
+CREATE  INDEX pm_task_dependency_parent_task_id_inx ON pm_task_dependency(parent_task_id);
+CREATE  INDEX pm_task_assignment_party_id_inx ON pm_task_assignment(party_id);
+CREATE  INDEX pm_task_assignment_role_id_inx ON pm_task_assignment(role_id);
+CREATE  INDEX pm_projects_logger_project_inx ON pm_projects(logger_project);
+CREATE  INDEX pm_projects_status_id_inx ON pm_projects(status_id);
+CREATE  INDEX pm_project_assignment_party_id_inx ON pm_project_assignment(party_id);
+CREATE  INDEX pm_project_assignment_role_id_inx ON pm_project_assignment(role_id);
+CREATE  INDEX pm_process_task_dependency_dependency_type_inx ON pm_process_task_dependency(dependency_type);
+CREATE  INDEX pm_process_task_dependency_parent_task_id_inx ON pm_process_task_dependency(parent_task_id);
+CREATE  INDEX pm_process_task_assignment_party_id_inx ON pm_process_task_assignment(party_id);
+CREATE  INDEX pm_process_task_assignment_role_id_inx ON pm_process_task_assignment(role_id);
+CREATE  INDEX pm_process_task_mime_type_inx ON pm_process_task(mime_type);
+CREATE  INDEX pm_process_task_process_id_inx ON pm_process_task(process_id);
+CREATE  INDEX pm_process_instance_project_item_id_inx ON pm_process_instance(project_item_id);
+CREATE  INDEX pm_process_instance_process_id_inx ON pm_process_instance(process_id);
+CREATE  INDEX pm_process_party_id_inx ON pm_process(party_id);
+CREATE  INDEX pm_default_roles_party_id_inx ON pm_default_roles(party_id);
+CREATE  INDEX pm_project_assignment_project_id ON pm_project_assignment(project_id);
+CREATE  INDEX pm_task_dependency_task_id ON pm_task_dependency(task_id);
+CREATE  INDEX pm_project_status_status_type_inx ON pm_project_status(status_type);