Index: openacs-4/packages/acs-subsite/sql/postgresql/upgrade/upgrade-5.2.0b5-5.2.0b6.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/sql/postgresql/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/postgresql/upgrade/upgrade-5.2.0b5-5.2.0b6.sql 4 Jun 2006 00:45:42 -0000 1.2 @@ -0,0 +1,11 @@ +-- +-- +-- +-- @author Dave Bauer (dave@thedesignexperience.org) +-- @creation-date 2005-11-29 +-- @arch-tag: 2e1f8368-2c55-49fb-9b34-9cd6564288e1 +-- @cvs-id $Id: upgrade-5.2.0b5-5.2.0b6.sql,v 1.2 2006/06/04 00:45:42 donb 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;