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.8 -r1.9
--- openacs-4/packages/assessment/sql/postgresql/assessment-collected-data-create.sql	23 Jan 2005 18:10:48 -0000	1.8
+++ openacs-4/packages/assessment/sql/postgresql/assessment-collected-data-create.sql	21 Feb 2005 14:32:55 -0000	1.9
@@ -124,6 +124,20 @@
 create index as_item_data_pk3 on as_item_data (as_item_id, section_id, session_id);
 create index as_item_data_subject_id_idx on as_item_data (subject_id);
 
+create table as_session_results (
+       result_id   integer
+                   constraint as_session_results_result_id_pk
+                   primary key
+                   constraint as_session_results_result_id_fk
+                   references cr_revisions(revision_id),
+       target_id   integer
+                   constraint as_session_results_target_id_fk
+                   references cr_revisions(revision_id),
+       points      integer
+);
+
+create index as_session_results_target_idx on as_session_results (target_id);
+
 -- here the selected choices are stored
 create table as_item_data_choices (
 	item_data_id	integer