Index: openacs-4/packages/assessment/sql/oracle/assessment-item-type-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/oracle/assessment-item-type-create.sql,v
diff -u -N -r1.5 -r1.6
--- openacs-4/packages/assessment/sql/oracle/assessment-item-type-create.sql	12 Jun 2006 02:49:50 -0000	1.5
+++ openacs-4/packages/assessment/sql/oracle/assessment-item-type-create.sql	15 May 2007 20:14:16 -0000	1.6
@@ -11,7 +11,8 @@
 				constraint as_item_type_mc_type_id_pk
 				primary key
 				constraint as_item_type_mc_type_id_fk
-				references cr_revisions(revision_id),
+				references cr_revisions(revision_id)
+                                on delete cascade,
 	-- (number of correct matches / number of total matches) *100% points. All or nothing will either give 100%, if all correct answers are given, or 0% else.
 	increasing_p		char(1) default 'f'
 				constraint as_item_type_mc_incr_p_ck
@@ -32,7 +33,8 @@
 				constraint as_item_type_oq_type_id_pk
 				primary key
 				constraint as_item_type_oq_type_id_fk
-				references cr_revisions(revision_id),
+				references cr_revisions(revision_id)
+                                on delete cascade,
 	-- the content of this field will be prefilled in the response of the user taking the survey
 	default_value		varchar(500),
 	-- the person correcting the answers will see the contents of this box as correct answer for comparison with the user response
@@ -49,7 +51,8 @@
 				constraint as_item_display_rb_displ_id_pk
 				primary key
 				constraint as_item_display_rb_displ_id_fk
-				references cr_revisions(revision_id),
+				references cr_revisions(revision_id)
+                                on delete cascade,
 	-- field to specify other stuff like textarea dimensions 
 	html_display_options	varchar(50),
 	-- the pattern by which 2..n Item Choices are laid out when displayed (horizontal, vertical) 
@@ -68,7 +71,8 @@
 				constraint as_item_display_cb_displ_id_pk
 				primary key
 				constraint as_item_display_cb_displ_id_fk
-				references cr_revisions(revision_id),
+				references cr_revisions(revision_id)
+                                on delete cascade,
 	-- field to specify other stuff like textarea dimensions 
 	html_display_options	varchar(50),
 	-- the pattern by which 2..n Item Choices are laid out when displayed (horizontal, vertical) 
@@ -87,7 +91,8 @@
 				constraint as_item_display_sb_displ_id_pk
 				primary key
 				constraint as_item_display_sb_displ_id_fk
-				references cr_revisions(revision_id),
+				references cr_revisions(revision_id)
+                                on delete cascade,
 	-- field to specify other stuff like textarea dimensions 
 	html_display_options	varchar(50),
 	-- if multiple answers are allowed
@@ -110,7 +115,8 @@
 				constraint as_item_display_tb_displ_id_pk
 				primary key
 				constraint as_item_display_tb_displ_id_fk
-				references cr_revisions(revision_id),
+				references cr_revisions(revision_id)
+                                on delete cascade,
 	-- field to specify other stuff like textarea dimensions
 	html_display_options	varchar(50),
 	-- an abstraction of the real size value in "small","medium","large" 
@@ -125,7 +131,8 @@
 				constraint as_item_display_sa_displ_id_pk
 				primary key
 				constraint as_item_display_sa_displ_id_fk
-				references cr_revisions(revision_id),
+				references cr_revisions(revision_id)
+                                on delete cascade,
 	-- field to specify other stuff like textarea dimensions
 	html_display_options	varchar(50),
 	-- an abstraction of the real size value in "small","medium","large"
@@ -140,7 +147,8 @@
 				constraint as_item_type_sa_type_id_pk
 				primary key
 				constraint as_item_type_sa_type_id_fk
-				references cr_revisions(revision_id),
+				references cr_revisions(revision_id)
+                                on delete cascade,
 	-- (number of correct matches / number of total matches) *100% points. All or nothing will either give 100%, if all correct answers are given, or 0% else.
 	increasing_p		char(1) default 'f'
 				constraint as_item_type_sa_incr_p_ck
@@ -157,7 +165,8 @@
 				constraint as_item_display_ta_displ_id_pk
 				primary key
 				constraint as_item_display_ta_displ_id_fk
-				references cr_revisions(revision_id),
+				references cr_revisions(revision_id)
+                                on delete cascade,
 	-- field to specify other stuff like textarea dimensions
 	html_display_options	varchar(50),
 	-- an abstraction of the real size value in "small","medium","large"
@@ -167,3 +176,30 @@
 	-- the orientation between the "question part" of the Item (the title/subtext) and the "answer part" (beside-left, beside-right, bellow, above)
 	item_answer_alignment	varchar(20)
 );
+
+
+-- File Upload Item
+create table as_item_type_fu (
+	as_item_type_id		integer
+				constraint as_item_type_fu_type_id_pk
+				primary key
+				constraint as_item_type_fu_type_id_fk
+				references cr_revisions(revision_id)
+                on delete cascade
+);
+
+-- File Upload Display Type
+create table as_item_display_f (
+	as_item_display_id	integer
+				constraint as_item_display_f_displ_id_pk
+				primary key
+				constraint as_item_display_f_displ_id_fk
+				references cr_revisions(revision_id)
+                on delete cascade,
+	-- field to specify other stuff like textarea dimensions
+	html_display_options	varchar(50),
+	-- an abstraction of the real size value in "small","medium","large" 
+	abs_size		varchar(10),
+	-- the orientation between the "question part" of the Item (the title/subtext) and the "answer part" (beside-left, beside-right, bellow, above)
+	item_answer_alignment	varchar(20)
+);
