Index: openacs-4/packages/file-storage/sql/postgresql/file-storage-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/sql/postgresql/file-storage-drop.sql,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/file-storage/sql/postgresql/file-storage-drop.sql	4 Sep 2001 01:25:54 -0000	1.5
+++ openacs-4/packages/file-storage/sql/postgresql/file-storage-drop.sql	18 Dec 2001 21:05:44 -0000	1.6
@@ -8,6 +8,9 @@
 -- drop script for file-storage
 --
 
+-- Site-wide search interface
+\i file-storage-sc-drop.sql
+
 --
 -- content repository is set up to cascade, so we should just have to 
 -- delete the root folders
@@ -43,7 +46,12 @@
 drop table fs_root_folders;
 select drop_package('file_storage');
 
-select acs_object_type__drop_type ( 
-  'file_storage_item','f');
+-- Remove subtype of content_revision so that site-wide-search
+-- can distinguish file-storage items in the search results
+select content_type__drop_type (
+       'file_storage_object',	 -- content_type
+       'f',			 -- drop_children_p
+       'f'			 -- drop_table_p
+       );