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.2 -r1.3 --- openacs-4/packages/project-manager/sql/postgresql/project-manager-table-create.sql 26 May 2005 09:34:28 -0000 1.2 +++ openacs-4/packages/project-manager/sql/postgresql/project-manager-table-create.sql 3 Jun 2005 22:13:44 -0000 1.3 @@ -56,13 +56,7 @@ latest_finish_date timestamptz, -- denormalized, taken from logger actual_hours_completed numeric, - estimated_hours_total numeric, - -- The logger package keeps its own projects table - logger_project integer - constraint pm_projects_logger_pj_nn - not null - constraint pm_projects_logger_pj_fk - references logger_projects + estimated_hours_total numeric ); @@ -393,26 +387,8 @@ priority integer default 0 ); -create table pm_task_logger_proj_map ( - task_item_id integer - constraint pm_task_log_proj_map_t_nn - not null - constraint pm_task_log_proj_map_t_fk - references pm_tasks - on delete cascade, - logger_entry integer - constraint pm_task_log_proj_map_l_nn - not null - constraint pm_task_log_proj_map_l_fk - references logger_entries - on delete cascade, - constraint pm_task_logger_proj_map_uq - unique (task_item_id, logger_entry) -); - - create sequence pm_task_dependency_seq; create table pm_task_dependency (