Index: openacs-4/packages/assessment/sql/postgresql/assessment-section-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/postgresql/assessment-section-create.sql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/assessment/sql/postgresql/assessment-section-create.sql	10 Aug 2004 08:20:37 -0000	1.4
+++ openacs-4/packages/assessment/sql/postgresql/assessment-section-create.sql	11 Aug 2004 11:50:26 -0000	1.5
@@ -65,7 +65,9 @@
 	-- A revision_id inherited from cr_revisions
 	assessment_id	integer
 			constraint as_assessments_assessment_id_pk
-			primary key,
+			primary key
+			constraint as_assessments_assessment_id_fk
+			references cr_revisions(revision_id),
 	creator_id integer,
 	instructions	text,
 	-- whether this is a standalone assessment (like current surveys), or if it provides an "assessment service" to another OpenACS app, or a "web service" via SOAP etc