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 -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)
