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.13 -r1.13.2.1
--- 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	15 Jul 2004 01:08:14 -0000	1.13.2.1
@@ -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
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/notifications/sql/oracle/upgrade/upgrade-5.1.0d2-5.1.0d3.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.12 -r1.12.2.1
--- openacs-4/packages/notifications/sql/postgresql/notifications-core-create.sql	11 Dec 2003 21:40:09 -0000	1.12
+++ openacs-4/packages/notifications/sql/postgresql/notifications-core-create.sql	15 Jul 2004 01:09:56 -0000	1.12.2.1
@@ -100,6 +100,7 @@
     request_id                      integer
                                     constraint notif_request_id_fk
                                     references acs_objects (object_id)
+                                    on delete cascade
                                     constraint notif_request_id_pk
                                     primary key,
     type_id                         integer
@@ -150,6 +151,7 @@
     notification_id                 integer
                                     constraint notif_notif_id_fk
                                     references acs_objects (object_id)
+                                    on delete cascade
                                     constraint notif_notif_id_pk
                                     primary key,
     type_id                         integer