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.2 -r1.3
--- openacs-4/contrib/packages/survey/sql/postgresql/survey-create.sql	26 Jan 2004 15:39:41 -0000	1.2
+++ openacs-4/contrib/packages/survey/sql/postgresql/survey-create.sql	7 Feb 2004 11:25:51 -0000	1.3
@@ -312,22 +312,24 @@
 create index survey_q_active_p on survey_questions(active_p);
 
 create table survey_block_sections (
-	block_section_id        integer primary key
+	block_section_id        integer primary key,
 	section_id              integer
                                 constraint survey_b_q_section_id_fk
                                 references survey_sections,
-	answer_description	varchar(400)
+	answer_description      text
 );
 
 create table survey_block_questions (
-	block_section_id 	references survey_block_sections,
+	block_section_id 	integer 
+                                constraint survey_b_q_section_id_fk
+                                references survey_block_sections,
 	choice_id 		integer
 				constraint survey_b_q_choice_id_nn
 				not null,
-	label 			varchar(200),
-	sort_order		integer
-				constraint survey_b_q_sort_order_nn
-				not null
+	label 			text,
+        sort_order              integer
+                                constraint survey_b_q_sort_order_nn
+                                not null
 );
 
 create sequence survey_block_section_id_seq;
@@ -353,7 +355,7 @@
                         references survey_questions
                         on delete cascade,
         -- human readable 
-        label           varchar(500)
+        label           text
 			constraint survey_qc_label_nn
                         not null,
         -- might be useful for averaging or whatever, generally null
Index: openacs-4/contrib/packages/survey/sql/postgresql/survey-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/survey/sql/postgresql/Attic/survey-drop.sql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/contrib/packages/survey/sql/postgresql/survey-drop.sql	19 Sep 2003 16:48:03 -0000	1.1
+++ openacs-4/contrib/packages/survey/sql/postgresql/survey-drop.sql	7 Feb 2004 11:25:51 -0000	1.2
@@ -12,12 +12,14 @@
 drop view survey_responses_latest;
 drop table survey_question_responses;
 drop table survey_responses;
+drop table survey_conditions;
 drop table survey_question_choices;
 drop sequence survey_choice_id_sequence;
 drop table survey_questions;
 drop table survey_predef_question_choices;
 drop table survey_predefined_questions;
 drop table survey_block_questions;
+drop table survey_block_sections;
 drop sequence survey_block_section_id_seq;
 drop sequence survey_block_choice_id_seq;
 drop table survey_branches;