Index: openacs-4/contrib/packages/project-manager/project-manager.info =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/Attic/project-manager.info,v diff -u -r1.16.2.40 -r1.16.2.41 --- openacs-4/contrib/packages/project-manager/project-manager.info 14 Jun 2005 15:33:27 -0000 1.16.2.40 +++ openacs-4/contrib/packages/project-manager/project-manager.info 27 Jun 2005 22:24:36 -0000 1.16.2.41 @@ -7,14 +7,14 @@ f f - + Jade Rubick Project management tool for OpenACS - 2005-01-13 + 2005-06-26 Integrated Bakery Resources Track tasks, estimates and actual progress for a project. See the <a href="http://openacs.org/projects/dotwrk/project_management/">project page</a> for more information. - + Index: openacs-4/contrib/packages/project-manager/sql/postgresql/project-manager-table-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/sql/postgresql/Attic/project-manager-table-create.sql,v diff -u -r1.19.2.8 -r1.19.2.9 --- openacs-4/contrib/packages/project-manager/sql/postgresql/project-manager-table-create.sql 5 Jan 2005 16:08:14 -0000 1.19.2.8 +++ openacs-4/contrib/packages/project-manager/sql/postgresql/project-manager-table-create.sql 27 Jun 2005 22:24:36 -0000 1.19.2.9 @@ -670,4 +670,47 @@ views. '; +-- Create Indexes + +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_key_account_rep_inx ON pm_projects(key_account_rep); +CREATE INDEX pm_projects_pan_id_inx ON pm_projects(pan_id); +CREATE INDEX pm_projects_distributor_id_inx ON pm_projects(distributor_id); +CREATE INDEX pm_projects_product_type_inx ON pm_projects(product_type); +CREATE INDEX pm_projects_brand_id_inx ON pm_projects(brand_id); +CREATE INDEX pm_projects_packaging_id_inx ON pm_projects(packaging_id); +CREATE INDEX pm_projects_bakery_id_inx ON pm_projects(bakery_id); +CREATE INDEX pm_projects_customer_id_inx ON pm_projects(customer_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); + + \i project-manager-custom-create.sql + Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/contrib/packages/project-manager/sql/postgresql/upgrade/upgrade-2.80d2-3.0b1.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: openacs-4/contrib/packages/project-manager/www/log-bulk.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/log-bulk.tcl,v diff -u -r1.2.2.6 -r1.2.2.7 --- openacs-4/contrib/packages/project-manager/www/log-bulk.tcl 2 May 2005 18:30:11 -0000 1.2.2.6 +++ openacs-4/contrib/packages/project-manager/www/log-bulk.tcl 27 Jun 2005 22:24:37 -0000 1.2.2.7 @@ -11,7 +11,7 @@ @param item_id A multiple containing the task item_ids } { - task_item_id:multiple + task_id:multiple {return_url ""} } -properties { } -validate {