Index: openacs-4/packages/evaluation/sql/postgresql/evaluation-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/sql/postgresql/evaluation-create.sql,v diff -u -r1.24 -r1.25 --- openacs-4/packages/evaluation/sql/postgresql/evaluation-create.sql 7 Apr 2005 11:26:58 -0000 1.24 +++ openacs-4/packages/evaluation/sql/postgresql/evaluation-create.sql 8 Aug 2006 21:26:41 -0000 1.25 @@ -11,6 +11,7 @@ references cr_items(item_id), grade_name varchar(100), grade_plural_name varchar(100), + comments text, -- percentage of this grade type in the class weight numeric constraint evaluation_grades_w_ck @@ -55,7 +56,13 @@ constraint evaluations_tasks_rgp_ck check(late_submit_p in ('t','f')), -- estimated time to complete the assigment - estimated_time decimal + estimated_time decimal, + points numeric, + perfect_score numeric, + relative_weight numeric, + forums_related_p char(1) constraint evaluation_tasks_frp_ck + check(forums_related_p in ('t','f')) + ); create index evalutaion_tasks_gid_index on evaluation_tasks(grade_item_id); @@ -90,7 +97,8 @@ references parties(party_id), task_item_id integer constraint evaluation_sans_tid_fk - references cr_items(item_id) + references cr_items(item_id), + comment text ); create index evaluation_answers_tid_index on evaluation_answers(party_id,task_item_id);