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.12.2.1
--- 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	24 Nov 2003 18:51:07 -0000	1.12.2.1
@@ -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),
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/notifications/sql/oracle/upgrade/upgrade-5.0.0a5-5.0.0a6.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: openacs-4/packages/notifications/sql/postgresql/notifications-core-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/sql/postgresql/notifications-core-create.sql,v
diff -u -r1.11 -r1.11.2.1
--- openacs-4/packages/notifications/sql/postgresql/notifications-core-create.sql	28 Aug 2003 09:41:58 -0000	1.11
+++ openacs-4/packages/notifications/sql/postgresql/notifications-core-create.sql	24 Nov 2003 18:51:07 -0000	1.11.2.1
@@ -166,7 +166,8 @@
     -- this is to allow responses to notifications
     response_id                     integer
                                     constraint notif_reponse_id_fk
-                                    references acs_objects (object_id),
+                                    references acs_objects (object_id)
+                                    on delete cascade,
     -- this is the user that caused the notification to go out
     notif_user                      integer
                                     constraint notif_user_id_fk
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/notifications/sql/postgresql/upgrade/upgrade-5.0.0a5-5.0.0a6.sql'.
Fisheye: No comparison available.  Pass `N' to diff?