Index: openacs-4/packages/file-storage/www/file-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/www/file-oracle.xql,v
diff -u -N -r1.14 -r1.15
--- openacs-4/packages/file-storage/www/file-oracle.xql	29 Jun 2004 10:18:25 -0000	1.14
+++ openacs-4/packages/file-storage/www/file-oracle.xql	23 Nov 2017 10:06:32 -0000	1.15
@@ -3,13 +3,6 @@
 <queryset>
    <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
 
-<fullquery name="get_folder">      
-      <querytext>
-	select content_item.get_parent_folder(:file_id)
-	from dual
-      </querytext>
-</fullquery>
-
 <fullquery name="file_info">      
       <querytext>
       
@@ -53,24 +46,9 @@
                       where m.object_id = r.revision_id
                         and m.party_id = :user_id
                         and m.privilege = 'read')
-	$show_versions order by last_modified desc
+	and $show_versions order by last_modified desc
 
       </querytext>
 </fullquery> 
 
-<partialquery name="show_all_versions">      
-      <querytext>
-
-      </querytext>
-</partialquery> 	
-
-<partialquery name="show_live_version">      
-      <querytext>
-
-	and r.revision_id = i.live_revision
-
-      </querytext>
-</partialquery> 	
-
- 
 </queryset>