Index: openacs-4/packages/file-storage/sql/postgresql/upgrade/upgrade-5.1.0d3-5.1.0d4.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/sql/postgresql/upgrade/upgrade-5.1.0d3-5.1.0d4.sql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/file-storage/sql/postgresql/upgrade/upgrade-5.1.0d3-5.1.0d4.sql 17 May 2004 15:15:14 -0000 1.2 +++ openacs-4/packages/file-storage/sql/postgresql/upgrade/upgrade-5.1.0d3-5.1.0d4.sql 29 Jun 2004 10:18:24 -0000 1.3 @@ -26,7 +26,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 coalesce(cr_revisions.title,cr_items.name) + else cr_items.name end as name, cr_items.name as file_upload_name, cr_revisions.mime_type, @@ -38,7 +38,7 @@ when cr_items.content_type = 'content_folder' then 0 else 1 end as sort_key, - cr_mime_types.label as pretty_type + cr_mime_types.label as pretty_type from cr_items left join cr_extlinks on (cr_items.item_id = cr_extlinks.extlink_id)