Index: openacs-4/packages/notifications/sql/postgresql/upgrade/upgrade-5.0.0a5-5.0.0a6.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/sql/postgresql/upgrade/upgrade-5.0.0a5-5.0.0a6.sql,v
diff -u -r1.1.2.1 -r1.1.2.2
--- openacs-4/packages/notifications/sql/postgresql/upgrade/upgrade-5.0.0a5-5.0.0a6.sql	24 Nov 2003 18:51:08 -0000	1.1.2.1
+++ openacs-4/packages/notifications/sql/postgresql/upgrade/upgrade-5.0.0a5-5.0.0a6.sql	28 Nov 2003 14:52:46 -0000	1.1.2.2
@@ -6,6 +6,7 @@
 
 -- Before we create the new table we need to drop constraints
 -- to avoid naming conflicts
+alter table notification_user_map drop constraint notif_user_map_notif_id_fk;
 alter table notifications_bak drop constraint notif_notif_id_pk;
 
 create table notifications (
@@ -40,3 +41,6 @@
 );
 
 insert into notifications select * from notifications_bak;
+
+alter table notification_user_map add constraint notif_user_map_notif_id_fk FOREIGN KEY (notification_id) REFERENCES notifications(notification_id) ON delete cascade;
+
