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.12 -r1.13
--- openacs-4/contrib/packages/project-manager/www/task-add-edit-postgresql.xql	11 Dec 2003 21:39:44 -0000	1.12
+++ openacs-4/contrib/packages/project-manager/www/task-add-edit-postgresql.xql	26 Jan 2004 15:39:40 -0000	1.13
@@ -105,4 +105,52 @@
     </querytext>
   </fullquery>
 
+  <fullquery name="get_dependency_types">
+    <querytext>
+      select
+        short_name,
+        description
+	FROM
+	pm_task_dependency_types
+        ORDER BY
+        short_name
+    </querytext>
+  </fullquery>
+
+  <fullquery name="get_dependency_tasks">
+    <querytext>
+      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)
+    </querytext>
+  </fullquery>
+
+  <fullquery name="new_dependency">
+    <querytext>
+        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)
+    </querytext>
+  </fullquery>
+
+  <fullquery name="get_task_item_id">
+    <querytext>
+      select
+        item_id
+	FROM
+	pm_tasks_revisionsx
+        WHERE
+        revision_id = :this_revision_id
+    </querytext>
+  </fullquery>
+
 </queryset>