Index: openacs-4/packages/assessment/sql/oracle/assessment-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/oracle/assessment-drop.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/assessment/sql/oracle/assessment-drop.sql	26 Nov 2004 20:44:54 -0000	1.1
+++ openacs-4/packages/assessment/sql/oracle/assessment-drop.sql	5 Dec 2004 17:08:57 -0000	1.2
@@ -1,3 +1,5 @@
+drop table as_item_types_map;
+
 drop table as_item_choices;
 drop table as_item_attributes;
 drop table as_item_localized;
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
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/assessment/sql/oracle/assessment-types-create.sql	5 Dec 2004 17:08:57 -0000	1.1
@@ -0,0 +1,40 @@
+--
+-- Assessment Package
+--
+-- @author timo@timohentschel.de
+-- @creation-date 2004-11-05
+--
+
+-- this table maps which display types are valid for which item types
+
+create table as_item_types_map (
+	item_type		varchar(50),
+	display_type		varchar(50)
+);
+
+insert into as_item_types_map (item_type, display_type)
+values ('oq', 'tb');
+insert into as_item_types_map (item_type, display_type)
+values ('oq', 'ta');
+insert into as_item_types_map (item_type, display_type)
+values ('sa', 'tb');
+insert into as_item_types_map (item_type, display_type)
+values ('mc', 'rb');
+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');
+-- 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');
+-- 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');
Index: openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.01d-0.02d.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.01d-0.02d.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.01d-0.02d.sql	5 Dec 2004 17:08:58 -0000	1.1
@@ -0,0 +1,40 @@
+--
+-- Assessment Package
+--
+-- @author timo@timohentschel.de
+-- @creation-date 2004-11-05
+--
+
+-- this table maps which display types are valid for which item types
+
+create table as_item_types_map (
+	item_type		varchar(50),
+	display_type		varchar(50)
+);
+
+insert into as_item_types_map (item_type, display_type)
+values ('oq', 'tb');
+insert into as_item_types_map (item_type, display_type)
+values ('oq', 'ta');
+insert into as_item_types_map (item_type, display_type)
+values ('sa', 'tb');
+insert into as_item_types_map (item_type, display_type)
+values ('mc', 'rb');
+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');
+-- 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');
+-- 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');
Index: openacs-4/packages/assessment/sql/postgresql/assessment-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/postgresql/assessment-drop.sql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/assessment/sql/postgresql/assessment-drop.sql	21 Jul 2004 10:21:20 -0000	1.3
+++ openacs-4/packages/assessment/sql/postgresql/assessment-drop.sql	5 Dec 2004 17:08:57 -0000	1.4
@@ -1,3 +1,5 @@
+drop table as_item_types_map;
+
 drop table as_item_choices;
 drop table as_item_attributes;
 drop table as_item_localized;
Index: openacs-4/packages/assessment/sql/postgresql/assessment-types-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/postgresql/assessment-types-create.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/assessment/sql/postgresql/assessment-types-create.sql	5 Dec 2004 17:08:57 -0000	1.1
@@ -0,0 +1,40 @@
+--
+-- Assessment Package
+--
+-- @author timo@timohentschel.de
+-- @creation-date 2004-11-05
+--
+
+-- this table maps which display types are valid for which item types
+
+create table as_item_types_map (
+	item_type		varchar(50),
+	display_type		varchar(50)
+);
+
+insert into as_item_types_map (item_type, display_type)
+values ('oq', 'tb');
+insert into as_item_types_map (item_type, display_type)
+values ('oq', 'ta');
+insert into as_item_types_map (item_type, display_type)
+values ('sa', 'tb');
+insert into as_item_types_map (item_type, display_type)
+values ('mc', 'rb');
+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');
+-- 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');
+-- 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');
Index: openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-0.01d-0.02d.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-0.01d-0.02d.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-0.01d-0.02d.sql	5 Dec 2004 17:08:57 -0000	1.1
@@ -0,0 +1,40 @@
+--
+-- Assessment Package
+--
+-- @author timo@timohentschel.de
+-- @creation-date 2004-11-05
+--
+
+-- this table maps which display types are valid for which item types
+
+create table as_item_types_map (
+	item_type		varchar(50),
+	display_type		varchar(50)
+);
+
+insert into as_item_types_map (item_type, display_type)
+values ('oq', 'tb');
+insert into as_item_types_map (item_type, display_type)
+values ('oq', 'ta');
+insert into as_item_types_map (item_type, display_type)
+values ('sa', 'tb');
+insert into as_item_types_map (item_type, display_type)
+values ('mc', 'rb');
+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');
+-- 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');
+-- 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');