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 -r1.3 -r1.4
--- openacs-4/packages/assessment/sql/oracle/assessment-item-type-create.sql	8 Dec 2004 15:30:33 -0000	1.3
+++ openacs-4/packages/assessment/sql/oracle/assessment-item-type-create.sql	21 Feb 2005 14:32:55 -0000	1.4
@@ -36,7 +36,11 @@
 	-- 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
-	feedback_text    varchar(500)
+	feedback_text    	varchar(500),
+	-- reference text with the expected perfect answer
+	reference_answer	clob,
+	-- keyword list for automatic pre-grading
+	keywords		varchar(4000)
 );
 
 -- Radiobutton display type
@@ -110,7 +114,7 @@
 	-- 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(10)
+	item_answer_alignment	varchar(20)
 );
 
 -- ShortAnswer Display Type: multiple textboxes in one item.