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