Index: openacs-4/packages/acs-subsite/sql/oracle/site-node-selection.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/sql/oracle/site-node-selection.sql,v
diff -u -N -r1.3 -r1.3.2.1
--- openacs-4/packages/acs-subsite/sql/oracle/site-node-selection.sql	8 Feb 2005 17:24:24 -0000	1.3
+++ openacs-4/packages/acs-subsite/sql/oracle/site-node-selection.sql	29 Nov 2005 14:27:03 -0000	1.3.2.1
@@ -9,6 +9,7 @@
 create table site_nodes_selection (
         node_id         integer constraint site_nodes_sel_id_fk
                         references acs_objects (object_id)
+                        on delete cascade
                         constraint site_node_sel_id_pk
                         primary key,
 	view_p		char(1)
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;
Index: openacs-4/packages/acs-subsite/sql/postgresql/site-node-selection.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/sql/postgresql/site-node-selection.sql,v
diff -u -N -r1.2 -r1.2.2.1
--- openacs-4/packages/acs-subsite/sql/postgresql/site-node-selection.sql	13 Jan 2005 13:55:32 -0000	1.2
+++ openacs-4/packages/acs-subsite/sql/postgresql/site-node-selection.sql	29 Nov 2005 14:27:03 -0000	1.2.2.1
@@ -9,6 +9,7 @@
 create table site_nodes_selection (
         node_id         integer constraint site_nodes_sel_id_fk
                         references acs_objects (object_id)
+                        on delete cascade
                         constraint site_node_sel_id_pk
                         primary key,
 	view_p		boolean
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	29 Nov 2005 14:27:03 -0000	1.1.2.1
@@ -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.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;