Index: openacs-4/packages/file-storage/sql/oracle/upgrade/upgrade-5.1.0d3-5.1.0d4.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/sql/oracle/upgrade/upgrade-5.1.0d3-5.1.0d4.sql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/file-storage/sql/oracle/upgrade/upgrade-5.1.0d3-5.1.0d4.sql	17 May 2004 15:15:13 -0000	1.2
+++ openacs-4/packages/file-storage/sql/oracle/upgrade/upgrade-5.1.0d3-5.1.0d4.sql	15 Jun 2004 18:41:55 -0000	1.3
@@ -35,12 +35,12 @@
       cr_extlinks.url,
       cr_items.parent_id,
       cr_items.name as key,
-      cr_mime_types.label as pretty_type
+      cr_mime_types.label as pretty_type,
       case
         when cr_items.content_type = 'content_folder' then 0
         else 1
       end as sort_key
-    from cr_items, cr_extlinks, cr_folders, cr_revisions, acs_objects
+    from cr_items, cr_extlinks, cr_folders, cr_revisions, acs_objects, cr_mime_types
     where cr_items.item_id = cr_extlinks.extlink_id(+)
       and cr_items.item_id = cr_folders.folder_id(+)
       and cr_items.item_id = acs_objects.object_id