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.3 -r1.4
--- openacs-4/packages/file-storage/sql/postgresql/file-storage-views-create.sql	18 Apr 2002 18:09:14 -0000	1.3
+++ openacs-4/packages/file-storage/sql/postgresql/file-storage-views-create.sql	21 May 2002 14:51:59 -0000	1.4
@@ -32,7 +32,8 @@
             (select count(*)
              from fs_simple_objects
              where fs_simple_objects.folder_id = cr_folders.folder_id)) as content_size,
-           cr_items.parent_id
+           cr_items.parent_id,
+           cr_items.name as key
     from cr_folders,
          cr_items,
          acs_objects
@@ -48,7 +49,8 @@
            cr_revisions.content_length as content_size,
            cr_items.name,
            acs_objects.last_modified,
-           cr_items.parent_id
+           cr_items.parent_id,
+           cr_items.name as key
     from cr_revisions,
          cr_items,
          acs_objects
@@ -67,6 +69,7 @@
            fs_folders.last_modified,
            '' as url,
            fs_folders.parent_id,
+           fs_folders.key,
            0 as sort_key
     from fs_folders
     union
@@ -78,6 +81,7 @@
            fs_files.last_modified,
            '' as url,
            fs_files.parent_id,
+           fs_files.key,
            1 as sort_key
     from fs_files
     union
@@ -89,5 +93,6 @@
            fs_urls_full.last_modified,
            fs_urls_full.url,
            fs_urls_full.folder_id as parent_id,
+           fs_urls_full.url as key,
            1 as sort_key
     from fs_urls_full;