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 -N -r1.6 -r1.6.22.1
--- openacs-4/packages/search/sql/postgresql/search-tables-create.sql	17 May 2003 11:27:28 -0000	1.6
+++ openacs-4/packages/search/sql/postgresql/search-tables-create.sql	24 Feb 2015 08:12:40 -0000	1.6.22.1
@@ -1,7 +1,10 @@
 create table search_observer_queue (
-    object_id		   integer,
+    object_id		   integer not null
+                           references acs_objects(object_id) on delete cascade,
     event_date		   timestamptz default current_timestamp,
     event		   varchar(6)
 			   constraint search_observer_queue_event_ck
 			   check (event in ('INSERT','DELETE','UPDATE'))  
 );
+
+
