Index: openacs-4/packages/acs-subsite/sql/oracle/upgrade/upgrade-5.2.0b5-5.2.0b6.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/sql/oracle/upgrade/upgrade-5.2.0b5-5.2.0b6.sql,v diff -u -N --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/acs-subsite/sql/oracle/upgrade/upgrade-5.2.0b5-5.2.0b6.sql 29 Nov 2005 14:27:03 -0000 1.1.2.1 @@ -0,0 +1,12 @@ +-- +-- +-- +-- @author Dave Bauer (dave@thedesignexperience.org) +-- @creation-date 2005-11-29 +-- @arch-tag: 6595c279-ae92-4dd8-955f-1184e1fccbd7 +-- @cvs-id $Id: upgrade-5.2.0b5-5.2.0b6.sql,v 1.1.2.1 2005/11/29 14:27:03 daveb Exp $ +-- + + +alter table site_nodes_selection drop constraint site_nodes_sel_id_fk; +alter table site_nodes_selection add constraint site_nodes_sel_id_fk foreign key (node_id) references acs_objects(object_id) on delete cascade;