Index: openacs-4/packages/notifications/sql/oracle/notifications-core-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/sql/oracle/notifications-core-create.sql,v
diff -u -N -r1.13 -r1.14
--- openacs-4/packages/notifications/sql/oracle/notifications-core-create.sql	11 Dec 2003 21:40:08 -0000	1.13
+++ openacs-4/packages/notifications/sql/oracle/notifications-core-create.sql	24 Jul 2004 08:34:43 -0000	1.14
@@ -92,6 +92,7 @@
 create table notification_requests (
     request_id                      constraint notif_request_id_fk
                                     references acs_objects (object_id)
+                                    on delete cascade
                                     constraint notif_request_id_pk
                                     primary key,
     type_id                         constraint notif_request_type_id_fk
@@ -141,6 +142,7 @@
 create table notifications (
     notification_id                 constraint notif_notif_id_fk
                                     references acs_objects (object_id)
+                                    on delete cascade
                                     constraint notif_notif_id_pk
                                     primary key,
     type_id                         constraint notif_type_id_fk