Index: openacs-4/contrib/packages/project-manager/www/task-add-edit-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/task-add-edit-postgresql.xql,v diff -u -r1.5 -r1.6 --- openacs-4/contrib/packages/project-manager/www/task-add-edit-postgresql.xql 4 Aug 2003 22:40:21 -0000 1.5 +++ openacs-4/contrib/packages/project-manager/www/task-add-edit-postgresql.xql 21 Aug 2003 22:34:43 -0000 1.6 @@ -8,8 +8,9 @@ '$task_title($i)', '$description($i)', to_timestamp(now(),'YYYY MM DD HH24 MI SS'), - to_timestamp(now(),'YYYY MM DD HH24 MI SS'), '0', + '$estimated_hours_work_min($i)', + '$estimated_hours_work_max($i)', now(), :user_id, :peeraddr, @@ -18,24 +19,6 @@ - - - select pm_task__new_task_revision ( - :task_id, - :project_item_id, - :task_title, - :description, - to_timestamp(:start_date,'YYYY MM DD HH24 MI SS'), - to_timestamp(:end_date,'YYYY MM DD HH24 MI SS'), - :percent_complete, - now(), - :user_id, - :peeraddr, - :package_id - ); - - - select @@ -45,9 +28,10 @@ t.description, t.name, t.parent_id, - to_char(t.start_date,'YYYY MM DD') as start_date, to_char(t.end_date,'YYYY MM DD') as end_date, - t.percent_complete + t.percent_complete, + t.estimated_hours_work_min, + t.estimated_hours_work_max FROM pm_tasks_revisionsx t, cr_items i WHERE