Index: openacs-4/packages/notifications/sql/oracle/upgrade/upgrade-5.1.0d2-5.1.0d3.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/sql/oracle/upgrade/upgrade-5.1.0d2-5.1.0d3.sql,v diff -u -r1.1.2.1 -r1.1.2.2 --- openacs-4/packages/notifications/sql/oracle/upgrade/upgrade-5.1.0d2-5.1.0d3.sql 15 Jul 2004 01:04:19 -0000 1.1.2.1 +++ openacs-4/packages/notifications/sql/oracle/upgrade/upgrade-5.1.0d2-5.1.0d3.sql 9 Sep 2004 23:22:11 -0000 1.1.2.2 @@ -14,12 +14,12 @@ alter table notification_requests drop constraint notif_request_id_fk; alter table notification_requests add constraint notif_request_id_fk - foreign key (object_id) + foreign key (request_id) references acs_objects (object_id) on delete cascade; alter table notifications drop constraint notif_notif_id_fk; alter table notifications add constraint notif_notif_id_fk - foreign key (object_id) + foreign key (notification_id) references acs_objects (object_id) on delete cascade;