Index: openacs-4/packages/cms/www/item/create-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/cms/www/item/create-oracle.xql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/cms/www/item/create-oracle.xql	25 May 2001 02:42:52 -0000	1.1
@@ -0,0 +1,27 @@
+<?xml version="1.0"?>
+
+<queryset>
+   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
+
+<fullquery name="new_content_item">      
+      <querytext>
+      begin 
+    :1 := content_item.new(:name, :context_id, :item_id, sysdate, NULL,
+                           '[ns_conn peeraddr]', 'content_item'); 
+  end;
+      </querytext>
+</fullquery>
+
+ 
+<fullquery name="new_revision">      
+      <querytext>
+      begin 
+    :1 := content_revision.new(:title, :description, $publish_date, 
+                               :mime_type, NULL, :text, 'content_revision', 
+                               :item_id, :revision_id);
+  end;
+      </querytext>
+</fullquery>
+
+ 
+</queryset>
Index: openacs-4/packages/cms/www/item/create-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/cms/www/item/create-postgresql.xql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/cms/www/item/create-postgresql.xql	25 May 2001 02:42:52 -0000	1.1
@@ -0,0 +1,51 @@
+<?xml version="1.0"?>
+
+<queryset>
+   <rdbms><type>postgresql</type><version>7.1</version></rdbms>
+
+<fullquery name="new_content_item">      
+      <querytext>
+     
+    select content_item__new(:name, 
+                             :context_id, 
+                             :item_id, 
+                             null,
+                             current_timestamp, 
+                             null,
+                             NULL,
+                             '[ns_conn peeraddr]', 
+                             'content_item',
+                             'content_revision',
+                             null,
+                             null,
+                             'text/plain',
+                             null,
+                             null,
+                             'text'); 
+
+      </querytext>
+</fullquery>
+
+ 
+<fullquery name="new_revision">      
+      <querytext>
+
+    select content_revision__new(:title, 
+                                 :description, 
+                                 $publish_date, 
+                                 :mime_type, 
+                                 NULL, 
+                                 :text, 
+--                                 'content_revision', 
+                                 :item_id, 
+                                 :revision_id,
+                                  now(),
+                                  null,
+                                  null,
+                                  null);
+
+      </querytext>
+</fullquery>
+
+ 
+</queryset>