Index: openacs-4/packages/notifications/sql/oracle/upgrade/upgrade-5.1.0d2-5.1.0d3.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/sql/oracle/upgrade/upgrade-5.1.0d2-5.1.0d3.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/notifications/sql/oracle/upgrade/upgrade-5.1.0d2-5.1.0d3.sql	24 Jul 2004 08:34:43 -0000	1.2
@@ -0,0 +1,25 @@
+-- 
+-- packages/notifications/sql/oracle/upgrade/upgrade-5.1.0d2-5.1.0d3.sql
+-- 
+-- @author Stan Kaufman (skaufman@epimetrics.com)
+-- @creation-date 2004-07-14
+-- @cvs-id $Id: upgrade-5.1.0d2-5.1.0d3.sql,v 1.2 2004/07/24 08:34:43 jeffd Exp $
+--
+-- see bug http://openacs.org/bugtracker/openacs/bug?bug_number=1973
+-- Add the on delete cascade to 
+--   request_id column of notification_requests
+--   notifcation_id column of notifications
+-- based on Peter's upgrade script
+-- @author Peter Marklund
+
+alter table notification_requests drop constraint notif_request_id_fk;
+alter table notification_requests add constraint notif_request_id_fk
+                              foreign key (object_id)
+                              references acs_objects (object_id)
+                              on delete cascade;
+
+alter table notifications drop constraint notif_notif_id_fk;
+alter table notifications add constraint notif_notif_id_fk
+                              foreign key (object_id)
+                              references acs_objects (object_id)
+                              on delete cascade;