Index: openacs-4/packages/file-storage/sql/oracle/upgrade/upgrade-5.1.0a13-5.1.0a14.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/sql/oracle/upgrade/upgrade-5.1.0a13-5.1.0a14.sql,v diff -u -r1.1.2.1 -r1.1.2.2 --- openacs-4/packages/file-storage/sql/oracle/upgrade/upgrade-5.1.0a13-5.1.0a14.sql 5 Jan 2005 17:37:21 -0000 1.1.2.1 +++ openacs-4/packages/file-storage/sql/oracle/upgrade/upgrade-5.1.0a13-5.1.0a14.sql 8 Feb 2005 15:14:19 -0000 1.1.2.2 @@ -9,4 +9,4 @@ -- Add root folders into dav_site_node_folder_map -insert into dav_site_node_folder_map (select sn.node_id, fs.folder_id, 'f' from fs_root_folders fs, site_nodes sn where sn.object_id=fs.package_id where fs.folder_id not in (select folder_id from dav_site_node_folder_map)); \ No newline at end of file +insert into dav_site_node_folder_map (select sn.node_id, fs.folder_id, 'f' from fs_root_folders fs, site_nodes sn where sn.object_id=fs.package_id and fs.folder_id not in (select folder_id from dav_site_node_folder_map)); \ No newline at end of file