Index: openacs-4/packages/assessment/sql/postgresql/assessment-item-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/postgresql/assessment-item-create.sql,v diff -u -r1.16 -r1.16.2.1 --- openacs-4/packages/assessment/sql/postgresql/assessment-item-create.sql 15 Apr 2005 17:26:45 -0000 1.16 +++ openacs-4/packages/assessment/sql/postgresql/assessment-item-create.sql 4 Jul 2005 15:02:23 -0000 1.16.2.1 @@ -124,3 +124,18 @@ -- order in which the messages appear sort_order integer ); + +-- File Upload Answers +create table as_item_fu_answers ( + choice_id integer + constraint as_item_fu_answers_id_pk + primary key + constraint as_item_fu_answers_id_fk + references cr_revisions(revision_id), + answer_id integer + constraint as_item_fu_answers_parent_id_fk + references as_item_type_fu(as_item_type_id), + file_id integer + constraint as_item_fu_file_id_fk + references cr_revisions(revision_id) +);