Index: openacs-4/contrib/packages/project-manager/www/add-edit-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/add-edit-postgresql.xql,v
diff -u -N -r1.9 -r1.9.2.1
--- openacs-4/contrib/packages/project-manager/www/add-edit-postgresql.xql	18 Sep 2003 23:33:54 -0000	1.9
+++ openacs-4/contrib/packages/project-manager/www/add-edit-postgresql.xql	4 Dec 2003 21:00:13 -0000	1.9.2.1
@@ -1,5 +1,36 @@
 <?xml version="1.0"?>
 <queryset>
+  <fullquery name="project_query">
+    <querytext>
+        SELECT
+        p.item_id as project_item_id,
+        p.parent_id,
+	p.project_id,
+        p.title as project_name,
+        p.project_code,
+	p.goal,
+	p.description,
+        p.status_id,
+	to_char(p.planned_start_date,'YYYY MM DD') as planned_start_date,
+	to_char(p.planned_end_date,'YYYY MM DD') as planned_end_date,
+	p.ongoing_p
+        FROM
+	pm_projectsx p
+        WHERE 
+        p.item_id    = :project_item_id and
+        p.project_id = :project_id 
+    </querytext>
+  </fullquery>
+
+  <fullquery name="do_nothing">
+    <querytext>
+        SELECT
+        current_timestamp
+        FROM
+	pm_projects
+    </querytext>
+  </fullquery>
+
   <fullquery name="new_project_item">
     <querytext>
 	select pm_project__new_project_item (
@@ -14,6 +45,7 @@
 		null,
 		null,
 		:ongoing_p,
+                :status_id,
 		now(),
 		:user_id,
 		:peeraddr,
@@ -36,6 +68,7 @@
 		null,
 		null,
 		:ongoing_p,
+                :status_id,
 		now(),
 		:user_id,
 		:peeraddr,
@@ -44,27 +77,6 @@
     </querytext>
   </fullquery>
 
-  <fullquery name="project_query">
-    <querytext>
-        SELECT
-        p.item_id as project_item_id,
-        p.parent_id,
-	p.project_id,
-        p.title as project_name,
-        p.project_code,
-	p.goal,
-	p.description,
-	to_char(p.planned_start_date,'YYYY MM DD') as planned_start_date,
-	to_char(p.planned_end_date,'YYYY MM DD') as planned_end_date,
-	p.ongoing_p
-        FROM
-	pm_projectsx p
-        WHERE 
-        p.item_id    = :project_item_id and
-        p.project_id = :project_id 
-    </querytext>
-  </fullquery>
-
   <fullquery name="get_item_id">
     <querytext>
 	SELECT
@@ -76,4 +88,15 @@
     </querytext>
   </fullquery>
 
+  <fullquery name="get_status_codes">
+    <querytext>
+	SELECT
+        description, status_id
+	FROM
+	pm_project_status
+        ORDER BY
+        status_type desc, description asc
+    </querytext>
+  </fullquery>
+
 </queryset>