Index: openacs-4/packages/survey/sql/postgresql/survey-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/survey/sql/postgresql/survey-create.sql,v diff -u -r1.2.2.1 -r1.2.2.2 --- openacs-4/packages/survey/sql/postgresql/survey-create.sql 23 Oct 2002 03:07:59 -0000 1.2.2.1 +++ openacs-4/packages/survey/sql/postgresql/survey-create.sql 23 Oct 2002 16:16:35 -0000 1.2.2.2 @@ -286,7 +286,7 @@ date_answer timestamp, attachment_answer integer constraint survey_q_response_item_id_fk - references cr_items(item_id) + references cr_revisions(revision_id) on delete cascade );