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')) ); + +