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.1 -r1.2 --- openacs-4/packages/assessment/sql/postgresql/assessment-item-create.sql 20 Jul 2004 18:11:15 -0000 1.1 +++ openacs-4/packages/assessment/sql/postgresql/assessment-item-create.sql 21 Jul 2004 10:21:20 -0000 1.2 @@ -64,12 +64,17 @@ check (value <= 100) ); -create table as_item_choice_map ( +create table as_item_help_map ( as_item_id integer - constraint as_item_choice_map_item_id_fk + constraint as_item_help_map_as_item_id_fk references as_items (as_item_id), - choice_id integer - constraint as_item_choice_map_choice_id_fk - references as_item_choices (choice_id), + message_id integer + constraint as_item_help_map_message_id_fk + references as_messages (message_id), sort_order integer ); + +create table as_messages ( + message_id integer, + message varchar(500) +);