Index: openacs-4/packages/assessment/sql/postgresql/assessment-types-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/postgresql/assessment-types-create.sql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/assessment/sql/postgresql/assessment-types-create.sql	12 Jun 2006 02:49:50 -0000	1.4
+++ openacs-4/packages/assessment/sql/postgresql/assessment-types-create.sql	15 May 2007 20:14:16 -0000	1.5
@@ -48,10 +48,12 @@
 create table as_item_rels (
 	item_rev_id	integer
 			constraint as_item_rels_item_fk
-			references acs_objects,
+			references acs_objects
+            on delete cascade,
 	target_rev_id	integer
 			constraint as_item_rels_target_fk
-			references acs_objects,
+			references acs_objects
+            on delete cascade,
 	rel_type	varchar(20),
 	constraint as_item_rels_pk
 	primary key (item_rev_id, rel_type, target_rev_id)