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 -r1.8 -r1.9
--- openacs-4/packages/assessment/sql/oracle/assessment-collected-data-create.sql	9 Sep 2008 17:28:21 -0000	1.8
+++ openacs-4/packages/assessment/sql/oracle/assessment-collected-data-create.sql	4 Feb 2009 18:47:49 -0000	1.9
@@ -128,6 +128,7 @@
 	text_answer	varchar(500),
 	timestamp_answer	date,
 	-- references cr_revisions
+
 	content_answer	integer
 		constraint as_item_data_content_fk
 		references cr_revisions
@@ -139,7 +140,7 @@
 		constraint as_item_data_file_id_fk
 		references cr_revisions(revision_id)
                 on delete cascade,
-        as_cr_item_id integer,
+        as_item_cr_item_id integer,
         choice_value varchar2(4000)
 	-- 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?
 );
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.15 -r1.16
--- openacs-4/packages/assessment/sql/postgresql/assessment-collected-data-create.sql	9 Sep 2008 17:28:22 -0000	1.15
+++ openacs-4/packages/assessment/sql/postgresql/assessment-collected-data-create.sql	4 Feb 2009 18:47:49 -0000	1.16
@@ -137,7 +137,7 @@
 		constraint as_item_data_file_id_fk
 		references cr_revisions(revision_id)
                 on delete cascade,
-        as_cr_item_id integer,
+        as_item_cr_item_id integer,
         choice_value text
 -- 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?
 );