Index: openacs-4/contrib/packages/project-manager/www/one-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/one-postgresql.xql,v
diff -u -N -r1.7 -r1.8
--- openacs-4/contrib/packages/project-manager/www/one-postgresql.xql	21 Aug 2003 22:34:43 -0000	1.7
+++ openacs-4/contrib/packages/project-manager/www/one-postgresql.xql	22 Aug 2003 00:27:33 -0000	1.8
@@ -36,7 +36,11 @@
 	to_char(p.planned_start_date,'MM/DD/YYYY') as planned_start_date,
 	to_char(p.planned_end_date,'MM/DD/YYYY') as planned_end_date,
 	p.ongoing_p,
-        i.live_revision
+        i.live_revision,
+        p.estimated_completion_date,
+        p.earliest_completion_date,
+        p.latest_completion_date,
+        p.estimated_hours_total
 	FROM
 	pm_projectsx p, cr_items i
 	WHERE
@@ -59,7 +63,11 @@
 	to_char(p.planned_start_date,'MM/DD/YYYY') as planned_start_date,
 	to_char(p.planned_end_date,'MM/DD/YYYY') as planned_end_date,
 	p.ongoing_p,
-        i.live_revision
+        i.live_revision,
+        p.estimated_completion_date,
+        p.earliest_completion_date,
+        p.latest_completion_date,
+        p.estimated_hours_total
 	FROM
 	pm_projectsx p, cr_items i
 	WHERE
@@ -78,6 +86,10 @@
 	to_char(t.end_date,'MM/DD/YY') as end_date,
         t.percent_complete,
         c.parent_task_id,
+        c.const_type,
+        t.estimated_hours_work_min,
+        t.estimated_hours_work_max,
+        t.actual_hours_worked,
         c.const_type
 	FROM
 	pm_tasks_revisionsx t, cr_items i LEFT JOIN pm_task_constraints c ON i.item_id = c.task_id