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.7.4.4 -r1.7.4.5 --- openacs-4/packages/file-storage/sql/oracle/file-storage-views-create.sql 23 Jun 2004 00:56:25 -0000 1.7.4.4 +++ openacs-4/packages/file-storage/sql/oracle/file-storage-views-create.sql 23 Aug 2004 17:30:06 -0000 1.7.4.5 @@ -46,7 +46,7 @@ cr_revisions.title as file_upload_name, cr_revisions.content_length as content_size, cr_items.name, - acs_objects.last_modified, + cr_revisions.publish_date as last_modified, cr_items.parent_id, cr_items.name as key from cr_revisions, @@ -82,7 +82,7 @@ end as name, cr_items.name as file_upload_name, cr_revisions.title, - acs_objects.last_modified, + cr_revisions.publish_date as last_modified, cr_extlinks.url, cr_items.parent_id, cr_items.name as key, @@ -97,3 +97,5 @@ and cr_items.item_id = acs_objects.object_id and cr_items.live_revision = cr_revisions.revision_id(+) and cr_revisions.mime_type = cr_mime_types.mime_type(+); + +