Index: openacs-4/packages/file-storage/www/file-add-2-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/www/Attic/file-add-2-postgresql.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/file-storage/www/file-add-2-postgresql.xql	16 Aug 2001 20:27:17 -0000	1.1
@@ -0,0 +1,72 @@
+<?xml version="1.0"?>
+
+<queryset>
+   <rdbms><type>postgresql</type><version>7.1</version></rdbms>
+
+<fullquery name="item_add">      
+      <querytext>
+
+    	select content_item__new (
+        	:filename,          -- name
+        	:folder_id,         -- parent_id
+		null,	            -- item_id (default)
+		null,	            -- locale (default)
+	        now(),	            -- creation_date (default)
+        	:user_id,           -- creation_user
+        	:folder_id,         -- context_id
+        	:creation_ip,       -- creation_ip
+		'content_item',     -- item_subtype (default)
+		'content_revision', -- content_type (default)
+		null,		    -- title (default)
+		null,		    -- description
+		'text/plain',	    -- mime_type (default)
+		null,	            -- nls_language (default)
+		null		    -- data (default)
+   		);
+
+      </querytext>
+</fullquery>
+
+ 
+<fullquery name="revision_add">      
+      <querytext>
+
+    	select content_revision__new (
+        		:title,		-- title
+        		:description, 	-- description
+			now(),		-- publish_date
+        		:mime_type,	-- mime_type
+			null,		-- nls_language
+			null,		-- data (default)
+        		:item_id,	-- item_id
+			null,		-- revision_id
+			now(),		-- creation_date
+        		:user_id,	-- creation_user
+        		:creation_ip	-- creation_ip
+    			);
+
+      </querytext>
+</fullquery>
+
+ 
+<fullquery name="content_add">      
+      <querytext>
+
+	update cr_revisions
+ 	set lob = [set __lob_id [db_string get_lob_id "select empty_lob()"]]
+	where revision_id = :revision_id
+
+     </querytext>
+</fullquery>
+
+ 
+<fullquery name="make_live">      
+      <querytext>
+
+    	select content_item__set_live_revision(:revision_id);
+
+      </querytext>
+</fullquery>
+
+ 
+</queryset>
Index: openacs-4/packages/file-storage/www/file-edit-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/www/file-edit-oracle.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/file-storage/www/file-edit-oracle.xql	16 Aug 2001 20:31:01 -0000	1.1
@@ -0,0 +1,17 @@
+<?xml version="1.0"?>
+
+<queryset>
+   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
+
+<fullquery name="file_info">      
+      <querytext>
+      
+	select content_item.get_title(:file_id) as title,name
+	from   cr_items
+	where  item_id = :file_id
+
+      </querytext>
+</fullquery>
+
+ 
+</queryset>