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;
