Index: openacs-4/packages/search/sql/postgresql/search-tables-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/search/sql/postgresql/search-tables-create.sql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/search/sql/postgresql/search-tables-create.sql	13 Sep 2001 04:59:26 -0000	1.3
+++ openacs-4/packages/search/sql/postgresql/search-tables-create.sql	15 Sep 2001 21:31:50 -0000	1.4
@@ -1,11 +1,7 @@
 create table search_observer_queue (
-    object_id		   integer
-			   constraint search_observer_queue_object_id_fk 
-			   references acs_objects(object_id) on delete cascade,
+    object_id		   integer,
     date		   timestamp default now(),
     event		   varchar(6)
 			   constraint search_observer_queue_event_ck
-			   check (event in ('INSERT','DELETE','UPDATE'))
-    
-    --                       constraint search_observer_queue_oid_date_un unique(object_id,date)
+			   check (event in ('INSERT','DELETE','UPDATE'))  
 );