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.1 -r1.2
--- openacs-4/packages/file-storage/sql/oracle/file-storage-views-create.sql	4 Apr 2002 03:01:06 -0000	1.1
+++ openacs-4/packages/file-storage/sql/oracle/file-storage-views-create.sql	18 Apr 2002 18:09:14 -0000	1.2
@@ -32,9 +32,6 @@
             (select count(*)
              from fs_simple_objects
              where fs_simple_objects.folder_id = cr_folders.folder_id)) as content_size,
-           (select site_node.url(site_nodes.node_id)
-            from site_nodes
-            where site_nodes.object_id = file_storage.get_package_id(cr_items.item_id)) as url,
            cr_items.parent_id
     from cr_folders,
          cr_items,
@@ -50,9 +47,6 @@
            cr_revisions.content_length as content_size,
            cr_items.name,
            acs_objects.last_modified,
-           (select site_node.url(site_nodes.node_id)
-            from site_nodes
-            where site_nodes.object_id = file_storage.get_package_id(cr_items.item_id)) as url,
            cr_items.parent_id
     from cr_revisions,
          cr_items,
@@ -70,7 +64,7 @@
            fs_folders.content_size,
            fs_folders.name,
            fs_folders.last_modified,
-           fs_folders.url,
+           '' as url,
            fs_folders.parent_id,
            0 as sort_key
     from fs_folders
@@ -81,7 +75,7 @@
            fs_files.content_size,
            fs_files.name,
            fs_files.last_modified,
-           fs_files.url,
+           '' as url,
            fs_files.parent_id,
            1 as sort_key
     from fs_files
