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.1 -r1.2 --- openacs-4/packages/file-storage/sql/postgresql/file-storage-views-create.sql 4 Apr 2002 03:01:06 -0000 1.1 +++ openacs-4/packages/file-storage/sql/postgresql/file-storage-views-create.sql 12 Apr 2002 18:15:26 -0000 1.2 @@ -42,6 +42,7 @@ where cr_folders.folder_id = cr_items.item_id and cr_folders.folder_id = acs_objects.object_id; + create view fs_files as select cr_revisions.item_id as file_id, @@ -62,7 +63,7 @@ and cr_items.content_type = 'file_storage_object' and cr_revisions.revision_id = acs_objects.object_id; -create or replace view fs_objects +create view fs_objects as select fs_folders.folder_id as object_id, 0 as live_revision,