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.8 -r1.9
--- openacs-4/packages/assessment/sql/postgresql/assessment-section-create.sql	17 Nov 2004 17:16:07 -0000	1.8
+++ openacs-4/packages/assessment/sql/postgresql/assessment-section-create.sql	22 Nov 2004 11:40:37 -0000	1.9
@@ -126,7 +126,11 @@
 	-- how shall the navigation happen (default path, randomized, rule-based branching)
 	section_navigation varchar(50) default 'default path'
 			constraint as_assessments_section_navigation_ck
-			check (section_navigation in ('default path', 'randomized', 'rule-based branching'))
+			check (section_navigation in ('default path', 'randomized', 'rule-based branching')),
+	-- 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'))
 );
 
 -- Style Options