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.2 -r1.3 --- openacs-4/packages/notifications/sql/oracle/upgrade/upgrade-5.1.0d2-5.1.0d3.sql 24 Jul 2004 08:34:43 -0000 1.2 +++ openacs-4/packages/notifications/sql/oracle/upgrade/upgrade-5.1.0d2-5.1.0d3.sql 13 Jan 2005 13:58:32 -0000 1.3 @@ -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;