Index: openacs-4/contrib/packages/survey/sql/postgresql/survey-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/survey/sql/postgresql/Attic/survey-create.sql,v
diff -u -N -r1.4 -r1.5
--- openacs-4/contrib/packages/survey/sql/postgresql/survey-create.sql	13 Jan 2005 13:54:39 -0000	1.4
+++ openacs-4/contrib/packages/survey/sql/postgresql/survey-create.sql	2 Nov 2005 02:58:49 -0000	1.5
@@ -121,7 +121,9 @@
         name                    varchar(4000)
                                 constraint surveys_name_nn
                                 not null,
-        description             text,
+        description             text
+                                constraint surveys_desc_nn
+                                not null,
         description_html_p      boolean not null,
         enabled_p               boolean not null,
         -- limit to one response per user
@@ -160,7 +162,9 @@
 				not null,
 	description		text,
         description_html_p      boolean,
-        pretty_id               varchar(100),
+        pretty_id               varchar(100)
+                                constraint survey_sections_pretty_id_un
+			        unique (pretty_id, section_id),
 	sort_key		integer default 0 not null,
 	branch_p		boolean default FALSE,
 	-- are there any branches dependant from this section?
@@ -273,7 +277,9 @@
 				(summary_type in ('sum','avg','concat')),
 	-- describing the options of radio button set
 	answer_description	varchar(100),
-        pretty_id               varchar(100),
+        pretty_id               varchar(100)
+                                constraint survey_q_pretty_id_un        
+			        unique (pretty_id, section_id),
 	predefined_question_id	integer
 				constraint survey_q_pred_q_id_fk
 				references survey_predefined_questions
@@ -300,7 +306,8 @@
 	label 			text,
         sort_order              integer
                                 constraint survey_b_q_sort_order_nn
-                                not null
+                                not null,
+	numeric_value           numeric
 );
 
 create sequence survey_block_section_id_seq;