Index: openacs-4/packages/file-storage/www/download/index-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/www/download/Attic/index-oracle.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/file-storage/www/download/index-oracle.xql	30 Aug 2001 14:21:22 -0000	1.2
+++ openacs-4/packages/file-storage/www/download/index-oracle.xql	22 Sep 2001 05:40:48 -0000	1.3
@@ -16,7 +16,7 @@
       </querytext>
 </fullquery>
 
-<fullquery name="version_write">      
+<fullquery name="version_write_blob">      
       <querytext>
 
 	select content
@@ -26,4 +26,27 @@
       </querytext>
 </fullquery>
 
+<fullquery name="version_write_file">      
+      <querytext>
+
+	    select '[cr_fs_path]' || filename as content
+            from cr_revisions
+            where revision_id = $version_id
+
+      </querytext>
+</fullquery>
+
+<fullquery name="file_type">      
+      <querytext>
+
+	select mime_type,(case when filename is null 
+                               then 1
+		               else 0
+		          end) as indb_p 
+	from   cr_revisions r
+	where  revision_id = :version_id
+
+      </querytext>
+</fullquery>
+
 </queryset>