Index: openacs-4/packages/assessment/sql/postgresql/assessment-collected-data-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/postgresql/assessment-collected-data-create.sql,v
diff -u -r1.12 -r1.13
--- openacs-4/packages/assessment/sql/postgresql/assessment-collected-data-create.sql	15 May 2007 20:14:16 -0000	1.12
+++ openacs-4/packages/assessment/sql/postgresql/assessment-collected-data-create.sql	7 Oct 2007 22:36:53 -0000	1.13
@@ -199,13 +199,16 @@
 create table as_session_items (
 	session_id	integer
 			constraint as_session_items_session_fk
-			references as_sessions,
+			references as_sessions
+                        on delete cascade,
 	section_id	integer
 			constraint as_session_items_section_fk
-			references as_sections,
+			references as_sections
+                        on delete cascade,
 	as_item_id	integer
 			constraint as_session_items_item_fk
-			references as_items,
+			references as_items
+                        on delete cascade,
 	sort_order	integer,
 	constraint as_session_items_pk
 	primary key (session_id, section_id, as_item_id)