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 -r1.12 -r1.13
--- openacs-4/packages/notifications/sql/oracle/notifications-core-create.sql	28 Aug 2003 09:41:58 -0000	1.12
+++ openacs-4/packages/notifications/sql/oracle/notifications-core-create.sql	11 Dec 2003 21:40:08 -0000	1.13
@@ -154,7 +154,8 @@
                                     not null,
     -- this is to allow responses to notifications
     response_id                     constraint notif_reponse_id_fk
-                                    references acs_objects (object_id),
+                                    references acs_objects (object_id)
+                                    on delete cascade,
     notif_user                      integer
                                     constraint notif_user_id_fk
                                     references users(user_id),
