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.1 -r1.2
--- openacs-4/contrib/packages/survey/sql/postgresql/survey-create.sql	19 Sep 2003 16:48:03 -0000	1.1
+++ openacs-4/contrib/packages/survey/sql/postgresql/survey-create.sql	26 Jan 2004 15:39:41 -0000	1.2
@@ -311,11 +311,16 @@
 create index survey_q_sort_order on survey_questions(sort_order);
 create index survey_q_active_p on survey_questions(active_p);
 
+create table survey_block_sections (
+	block_section_id        integer primary key
+	section_id              integer
+                                constraint survey_b_q_section_id_fk
+                                references survey_sections,
+	answer_description	varchar(400)
+);
+
 create table survey_block_questions (
-	block_section_id 	integer,
-	section_id 		integer
-				constraint survey_b_q_section_id_fk
-				references survey_sections,
+	block_section_id 	references survey_block_sections,
 	choice_id 		integer
 				constraint survey_b_q_choice_id_nn
 				not null,
