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.3 -r1.4
--- openacs-4/packages/assessment/sql/oracle/assessment-collected-data-create.sql	30 Jan 2005 14:16:14 -0000	1.3
+++ openacs-4/packages/assessment/sql/oracle/assessment-collected-data-create.sql	21 Feb 2005 14:32:55 -0000	1.4
@@ -126,6 +126,20 @@
 create index as_item_data_pk3 on as_item_data (as_item_id, section_id, session_id);
 create index as_item_data_subj_idx on as_item_data (subject_id);
 
+create table as_session_results (
+       result_id   integer
+                   constraint as_sess_res_res_id_pk
+                   primary key
+                   constraint as_sess_res_res_id_fk
+                   references cr_revisions(revision_id),
+       target_id   integer
+                   constraint as_sess_res_tgt_id_fk
+                   references cr_revisions(revision_id),
+       points      integer
+);
+
+create index as_sess_res_tgt_idx on as_session_results (target_id);
+
 -- here the selected choices are stored
 create table as_item_data_choices (
 	item_data_id	integer
