Index: openacs-4/packages/notifications/sql/oracle/upgrade/upgrade-5.0.0a5-5.0.0a6.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/sql/oracle/upgrade/upgrade-5.0.0a5-5.0.0a6.sql,v diff -u -N --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/notifications/sql/oracle/upgrade/upgrade-5.0.0a5-5.0.0a6.sql 11 Dec 2003 21:40:08 -0000 1.2 @@ -0,0 +1,8 @@ +-- Add the on delete cascade to response_id column, +-- see Bug http://openacs.org/bugtracker/openacs/bug?filter%2estatus=resolved&filter%2eactionby=6815&bug%5fnumber=260 +-- @author Peter Marklund +alter table notifications drop constraint notif_reponse_id_fk; +alter table notifications add constraint notif_reponse_id_fk + foreign key (response_id) + references acs_objects (object_id) + on delete cascade;