Index: openacs-4/packages/notifications/sql/oracle/upgrade/upgrade-5.0.0a5-5.0.0a6.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/sql/oracle/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/oracle/upgrade/upgrade-5.0.0a5-5.0.0a6.sql 24 Nov 2003 18:51:07 -0000 1.1.2.1 +++ openacs-4/packages/notifications/sql/oracle/upgrade/upgrade-5.0.0a5-5.0.0a6.sql 2 Dec 2003 10:45:27 -0000 1.1.2.2 @@ -1,6 +1,8 @@ -- Add the on delete cascade to response_id column, -- see Bug http://openacs.org/bugtracker/openacs/bug?filter%2estatus=resolved&filter%2eactionby=6815&bug%5fnumber=260 -- @author Peter Marklund - alter table notifications drop constraint notif_reponse_id_fk; -alter table notifications add constraint response_id references references acs_objects (object_id) on delete cascade; +alter table notifications add constraint notif_reponse_id_fk + foreign key (response_id) + references acs_objects (object_id) + on delete cascade;