Index: openacs-4/packages/acs-kernel/sql/postgresql/acs-relationships-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/acs-relationships-create.sql,v
diff -u -r1.17 -r1.18
--- openacs-4/packages/acs-kernel/sql/postgresql/acs-relationships-create.sql	18 Jun 2004 18:21:57 -0000	1.17
+++ openacs-4/packages/acs-kernel/sql/postgresql/acs-relationships-create.sql	27 Feb 2005 01:21:07 -0000	1.18
@@ -322,16 +322,19 @@
 	rel_id		integer not null
 			constraint acs_rels_rel_id_fk
 			references acs_objects (object_id)
+                        on delete cascade
 			constraint acs_rels_pk primary key,
 	rel_type	varchar(100) not null
 			constraint acs_rels_rel_type_fk
 			references acs_rel_types (rel_type),
 	object_id_one	integer not null
 			constraint acs_object_rels_one_fk
-			references acs_objects (object_id),
+			references acs_objects (object_id)
+                        on delete cascade,
 	object_id_two	integer not null
 			constraint acs_object_rels_two_fk
-			references acs_objects (object_id),
+			references acs_objects (object_id)
+                        on delete cascade,
 	constraint acs_object_rels_un unique
 	(rel_type, object_id_one, object_id_two)
 );
