Index: openacs-4/packages/file-storage/sql/oracle/file-storage-views-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/sql/oracle/file-storage-views-create.sql,v
diff -u -r1.11 -r1.12
--- openacs-4/packages/file-storage/sql/oracle/file-storage-views-create.sql	26 May 2005 08:28:44 -0000	1.11
+++ openacs-4/packages/file-storage/sql/oracle/file-storage-views-create.sql	8 Aug 2006 21:26:48 -0000	1.12
@@ -64,6 +64,7 @@
       case
         when cr_items.content_type = 'content_folder' then 'folder'
         when cr_items.content_type = 'content_extlink' then 'url'
+	when cr_items.content_type = 'content_symlink' then 'symlink'
         else cr_revisions.mime_type
       end as type,
       case
@@ -78,7 +79,7 @@
       case
         when cr_items.content_type = 'content_folder' then cr_folders.label
         when cr_items.content_type = 'content_extlink' then cr_extlinks.label
-        else nvl(cr_revisions.filename,cr_items.name)
+        else cr_items.name
       end as name,
       cr_items.name as file_upload_name,
       cr_revisions.title,
