Index: openacs-4/packages/assessment/sql/postgresql/assessment-section-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/postgresql/assessment-section-create.sql,v
diff -u -r1.17 -r1.18
--- openacs-4/packages/assessment/sql/postgresql/assessment-section-create.sql	9 Apr 2005 22:39:27 -0000	1.17
+++ openacs-4/packages/assessment/sql/postgresql/assessment-section-create.sql	12 Jun 2006 02:49:50 -0000	1.18
@@ -91,12 +91,12 @@
 			constraint as_assessments_random_p_ck
 			check (random_p in ('t','f')),
 	-- the customizable entry page that will be displayed before the first response.
-	entry_page varchar(50),
+	entry_page varchar(200),
 	-- customizable exit / thank you page that will be displayed once the assessment has been responded.
-	exit_page varchar(50),
+	exit_page varchar(200),
 	consent_page text,
 	-- URL the respondee will be redirected to after finishing the assessment
-	return_url varchar(50),
+	return_url varchar(200),
 	-- at what time shall the assessment become available to the users 
 	start_time timestamptz,
 	-- at what time the assessment becomes unavailable
@@ -122,7 +122,8 @@
 	-- differenciate between an assessment and a survey
 	survey_p 	char(1) default 'f'
 			constraint as_assessments_survey_p_ck
-			check (survey_p in ('t', 'f'))
+			check (survey_p in ('t', 'f')),
+	type		integer
 );
 
 -- Style Options