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 Index: openacs-4/packages/file-storage/sql/postgresql/file-storage-views-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/sql/postgresql/file-storage-views-create.sql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/file-storage/sql/postgresql/file-storage-views-create.sql 12 Apr 2002 18:15:26 -0000 1.2 +++ openacs-4/packages/file-storage/sql/postgresql/file-storage-views-create.sql 18 Apr 2002 18:09:14 -0000 1.3 @@ -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, @@ -51,9 +48,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, @@ -71,7 +65,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 @@ -82,7 +76,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