Index: openacs-4/packages/file-storage/www/view/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/www/view/index-postgresql.xql,v
diff -u -N -r1.1 -r1.1.4.1
--- openacs-4/packages/file-storage/www/view/index-postgresql.xql	7 Jul 2003 12:37:39 -0000	1.1
+++ openacs-4/packages/file-storage/www/view/index-postgresql.xql	6 Mar 2005 10:03:16 -0000	1.1.4.1
@@ -11,5 +11,21 @@
       </querytext>
 </fullquery>
 
+<fullquery name="upgraded_item_id">      
+      <querytext>
+
+select i.item_id
+	    from cr_revisions r, cr_items i 
+	    where r.item_id = i.item_id 
+	    and r.title = :item_url_title 
+	    and i.parent_id = (select item_id 
+			       from cr_items 
+			       where name = :item_url_folder) 
+	    order by revision_id desc
+	    limit 1
+
+      </querytext>
+</fullquery>
+
  
 </queryset>