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 -r1.3.2.1 -r1.3.2.2 --- openacs-4/contrib/packages/survey/sql/postgresql/survey-create.sql 2 Sep 2004 15:17:47 -0000 1.3.2.1 +++ openacs-4/contrib/packages/survey/sql/postgresql/survey-create.sql 23 Dec 2004 08:36:28 -0000 1.3.2.2 @@ -164,8 +164,7 @@ constraint survey_sections_desc_nn not null, description_html_p boolean, - pretty_id varchar(100) constraint survey_sections_pretty_id_un - unique (pretty_id, section_id) + pretty_id varchar(100), sort_key integer default 0 not null, branch_p boolean default FALSE, -- are there any branches dependant from this section? @@ -278,8 +277,7 @@ (summary_type in ('sum','avg','concat')), -- describing the options of radio button set answer_description varchar(100), - pretty_id varchar(100) constraint survey_q_pretty_id_un - unique (pretty_id, section_id), + pretty_id varchar(100), predefined_question_id integer constraint survey_q_pred_q_id_fk references survey_predefined_questions