Index: openacs-4/packages/assessment/sql/oracle/assessment-types-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/oracle/assessment-types-create.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/assessment/sql/oracle/assessment-types-create.sql	5 Dec 2004 17:08:57 -0000	1.1
+++ openacs-4/packages/assessment/sql/oracle/assessment-types-create.sql	8 Dec 2004 15:30:33 -0000	1.2
@@ -23,18 +23,33 @@
 insert into as_item_types_map (item_type, display_type)
 values ('mc', 'cb');
 insert into as_item_types_map (item_type, display_type)
-values ('mc', 'sa');
+values ('mc', 'sb');
 -- insert into as_item_types_map (item_type, display_type)
 -- values ('ca', 'tb');
 -- insert into as_item_types_map (item_type, display_type)
 -- values ('dq', 'rb');
 -- insert into as_item_types_map (item_type, display_type)
 -- values ('dq', 'cb');
 -- insert into as_item_types_map (item_type, display_type)
--- values ('dq', 'sa');
+-- values ('dq', 'sb');
 -- insert into as_item_types_map (item_type, display_type)
 -- values ('dq', 'tb');
 -- insert into as_item_types_map (item_type, display_type)
 -- values ('dq', 'ta');
 -- insert into as_item_types_map (item_type, display_type)
 -- values ('dq', 'file');
+
+
+-- this table maps items to item types and display types
+
+create table as_item_rels (
+	item_rev_id	integer
+			constraint as_item_rels_item_fk
+			references acs_objects,
+	target_rev_id	integer
+			constraint as_item_rels_target_fk
+			references acs_objects,
+	rel_type	varchar(20),
+	constraint as_item_rels_pk
+	primary key (item_rev_id, rel_type, target_rev_id)
+);