Index: openacs-4/packages/acs-kernel/sql/oracle/groups-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/groups-create.sql,v
diff -u -r1.8 -r1.9
--- openacs-4/packages/acs-kernel/sql/oracle/groups-create.sql	11 Dec 2003 21:39:51 -0000	1.8
+++ openacs-4/packages/acs-kernel/sql/oracle/groups-create.sql	27 Feb 2005 01:21:07 -0000	1.9
@@ -234,13 +234,15 @@
 create table group_element_index (
 	group_id	not null
 			constraint group_element_index_grp_id_fk
-			references groups (group_id),
+			references groups (group_id)
+                        on delete cascade,
 	element_id	not null
 			constraint group_element_index_elem_id_fk
 			references parties (party_id),
 	rel_id		not null
 			constraint group_element_index_rel_id_fk
-			references acs_rels (rel_id),
+			references acs_rels (rel_id)
+                        on delete cascade,
 	container_id	not null
 			constraint group_element_index_cont_id_fk
 			references groups (group_id),