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.11.2.1 -r1.11.2.2
--- openacs-4/contrib/packages/project-manager/www/task-add-edit-postgresql.xql 4 Dec 2003 21:00:13 -0000 1.11.2.1
+++ openacs-4/contrib/packages/project-manager/www/task-add-edit-postgresql.xql 10 Jan 2004 01:04:02 -0000 1.11.2.2
@@ -105,4 +105,52 @@
+
+
+ select
+ short_name,
+ description
+ FROM
+ pm_task_dependency_types
+ ORDER BY
+ short_name
+
+
+
+
+
+ select
+ r.item_id,
+ r.title as task_title
+ FROM
+ pm_tasks_revisionsx r,
+ cr_items i
+ WHERE
+ r.parent_id = :project_item_id and
+ r.revision_id = i.live_revision
+ ORDER BY
+ upper(r.title)
+
+
+
+
+
+ INSERT INTO pm_task_dependency
+ (dependency_id, task_id, parent_task_id, dependency_type)
+ VALUES
+ (:dependency_id, :this_task_id, :parent_task_id, :p_dep_type)
+
+
+
+
+
+ select
+ item_id
+ FROM
+ pm_tasks_revisionsx
+ WHERE
+ revision_id = :this_revision_id
+
+
+