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.1 -r1.7.4.2 --- openacs-4/packages/file-storage/sql/oracle/file-storage-views-create.sql 16 May 2004 16:53:06 -0000 1.7.4.1 +++ openacs-4/packages/file-storage/sql/oracle/file-storage-views-create.sql 25 May 2004 17:39:56 -0000 1.7.4.2 @@ -85,7 +85,7 @@ cr_extlinks.url, cr_items.parent_id, cr_items.name as key, - cr_mime_types.label as pretty_type + cr_mime_types.label as pretty_type, case when cr_items.content_type = 'content_folder' then 0 else 1 Index: openacs-4/packages/file-storage/sql/oracle/upgrade/upgrade-5.1.0d3-5.1.0d4.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/sql/oracle/upgrade/upgrade-5.1.0d3-5.1.0d4.sql,v diff -u -r1.1.2.1 -r1.1.2.2 --- openacs-4/packages/file-storage/sql/oracle/upgrade/upgrade-5.1.0d3-5.1.0d4.sql 16 May 2004 16:53:07 -0000 1.1.2.1 +++ openacs-4/packages/file-storage/sql/oracle/upgrade/upgrade-5.1.0d3-5.1.0d4.sql 25 May 2004 17:39:56 -0000 1.1.2.2 @@ -35,7 +35,7 @@ cr_extlinks.url, cr_items.parent_id, cr_items.name as key, - cr_mime_types.label as pretty_type + cr_mime_types.label as pretty_type, case when cr_items.content_type = 'content_folder' then 0 else 1 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.8.4.1 -r1.8.4.2 --- openacs-4/packages/file-storage/sql/postgresql/file-storage-views-create.sql 16 May 2004 16:53:08 -0000 1.8.4.1 +++ openacs-4/packages/file-storage/sql/postgresql/file-storage-views-create.sql 25 May 2004 17:39:56 -0000 1.8.4.2 @@ -88,7 +88,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) 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.1.2.2 -r1.1.2.3 --- openacs-4/packages/file-storage/sql/postgresql/upgrade/upgrade-5.1.0d3-5.1.0d4.sql 16 May 2004 17:08:40 -0000 1.1.2.2 +++ openacs-4/packages/file-storage/sql/postgresql/upgrade/upgrade-5.1.0d3-5.1.0d4.sql 25 May 2004 17:39:56 -0000 1.1.2.3 @@ -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)