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.13
--- 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	24 Jul 2004 08:34:44 -0000	1.13
@@ -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
