Index: openacs-4/packages/file-storage/sql/oracle/upgrade/upgrade-5.2.0d8-5.2.2.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/sql/oracle/upgrade/upgrade-5.2.0d8-5.2.2.sql,v
diff -u -r1.1.2.1 -r1.1.2.2
--- openacs-4/packages/file-storage/sql/oracle/upgrade/upgrade-5.2.0d8-5.2.2.sql	29 Mar 2006 01:26:45 -0000	1.1.2.1
+++ openacs-4/packages/file-storage/sql/oracle/upgrade/upgrade-5.2.0d8-5.2.2.sql	31 Mar 2006 12:55:14 -0000	1.1.2.2
@@ -624,3 +624,19 @@
 end file_storage;
 /
 show errors;
+
+
+create or replace view fs_urls_full
+as
+    select cr_extlinks.extlink_id as url_id,
+           cr_extlinks.url,
+           cr_items.parent_id as folder_id,
+           cr_extlinks.label as name,
+           cr_extlinks.description,
+           acs_objects.*
+    from cr_extlinks,
+         cr_items,
+         acs_objects
+    where cr_extlinks.extlink_id = cr_items.item_id
+    and cr_items.item_id = acs_objects.object_id;
+