Index: openacs-4/packages/assessment/sql/oracle/assessment-collected-data-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/oracle/assessment-collected-data-create.sql,v
diff -u -N -r1.5.2.2 -r1.5.2.3
--- openacs-4/packages/assessment/sql/oracle/assessment-collected-data-create.sql	7 Apr 2007 23:27:14 -0000	1.5.2.2
+++ openacs-4/packages/assessment/sql/oracle/assessment-collected-data-create.sql	8 Apr 2007 17:16:03 -0000	1.5.2.3
@@ -135,6 +135,10 @@
 	-- This field stores the signed entered data
 	signed_data varchar(500),
 	points integer
+	file_id integer
+		constraint as_item_data_file_id_fk
+		references cr_revisions(revision_id)
+                on delete cascade,
 	-- to do: figure out how attachment answers should be supported; the Attachment package is still in need of considerable help. Can we rely on it here?
 );
 
