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 -r1.11 -r1.12
--- openacs-4/contrib/packages/project-manager/www/add-edit-postgresql.xql	26 Feb 2004 15:15:41 -0000	1.11
+++ openacs-4/contrib/packages/project-manager/www/add-edit-postgresql.xql	12 Mar 2004 13:44:44 -0000	1.12
@@ -2,92 +2,35 @@
 <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
+        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.customer_id,
+        p.status_id,
+        p.logger_project,
+ 	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 (
-		:project_name,
-		:project_code,
-                :parent_id,
-		:goal,
-		:description,
-		to_timestamp(:planned_start_date,'YYYY MM DD HH24 MI SS'),
-		to_timestamp(:planned_end_date,'YYYY MM DD HH24 MI SS'),
-		null,
-		null,
-		:ongoing_p,
-                :status_id,
-		now(),
-		:user_id,
-		:peeraddr,
-		:package_id
-	);
-    </querytext>
-  </fullquery>
-
-  <fullquery name="new_project_revision">
-    <querytext>
-	select pm_project__new_project_revision (
-		:project_item_id,
-		:project_name,
-		:project_code,
-                :parent_id,
-		:goal,
-		:description,
-		to_timestamp(:planned_start_date,'YYYY MM DD HH24 MI SS'),
-		to_timestamp(:planned_end_date,'YYYY MM DD HH24 MI SS'),
-		null,
-		null,
-		:ongoing_p,
-                :status_id,
-                :customer_id,
-		now(),
-		:user_id,
-		:peeraddr,
-		:package_id
-	);
-    </querytext>
-  </fullquery>
-
-  <fullquery name="get_item_id">
-    <querytext>
-	SELECT
-        p.item_id as project_item_id
-	FROM
-	pm_projectsx p
-	WHERE
-	p.project_id = :project_id
-    </querytext>
-  </fullquery>
-
   <fullquery name="get_status_codes">
     <querytext>
 	SELECT