Index: openacs-4/contrib/packages/survey/sql/oracle/survey-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/survey/sql/oracle/Attic/survey-create.sql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/contrib/packages/survey/sql/oracle/survey-create.sql	19 Sep 2003 16:48:03 -0000	1.1
+++ openacs-4/contrib/packages/survey/sql/oracle/survey-create.sql	26 Jan 2004 15:39:41 -0000	1.2
@@ -291,8 +291,16 @@
 				references survey_predefined_questions
 );
 
+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,
+	block_section_id 	references survey_block_sections,
 	section_id		integer 
 				constraint survey_b_q_section_id_fk
 		   		references survey_sections,
