Index: openacs-4/contrib/packages/project-manager/sql/postgresql/project-manager-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/sql/postgresql/Attic/project-manager-drop.sql,v diff -u -r1.10.2.5 -r1.10.2.6 --- openacs-4/contrib/packages/project-manager/sql/postgresql/project-manager-drop.sql 4 Feb 2004 20:17:19 -0000 1.10.2.5 +++ openacs-4/contrib/packages/project-manager/sql/postgresql/project-manager-drop.sql 5 Feb 2004 23:57:49 -0000 1.10.2.6 @@ -19,6 +19,17 @@ drop sequence pm_task_dependency_seq; drop sequence pm_tasks_number_seq; +select content_type__drop_attribute ('pm_task', 'end_date', 't'); +select content_type__drop_attribute ('pm_task', 'percent_complete', 't'); +select content_type__drop_attribute ('pm_task', 'estimated_hours_work', 't'); +select content_type__drop_attribute ('pm_task', 'estimated_hours_work_min', 't'); +select content_type__drop_attribute ('pm_task', 'estimated_hours_work_max', 't'); +select content_type__drop_attribute ('pm_task', 'actual_hours_worked', 't'); +select content_type__drop_attribute ('pm_task', 'earliest_start', 't'); +select content_type__drop_attribute ('pm_task', 'earliest_finish', 't'); +select content_type__drop_attribute ('pm_task', 'latest_start', 't'); +select content_type__drop_attribute ('pm_task', 'latest_finish', 't'); + ------------- -- WORKGROUPS ------------- @@ -190,11 +201,13 @@ drop function inline_0(); -select content_type__drop_type('pm_task', 't', 'f'); +drop sequence pm_task_status_seq; +drop table pm_task_status; drop table pm_tasks cascade; drop table pm_tasks_revisions cascade; +select content_type__drop_type('pm_task', 't', 'f'); select content_type__drop_type('pm_project', 't', 'f');