Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql,v
diff -u -N -r1.45 -r1.46
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql	17 May 2004 15:14:44 -0000	1.45
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql	1 Jul 2004 11:02:02 -0000	1.46
@@ -475,7 +475,9 @@
 		  references cr_mime_types,
   nls_language    varchar(50),
   -- lob_id if storage_type = lob.
-  lob             integer references lobs,
+  lob             integer
+                  constraint cr_revisions_lob_fk
+                  references lobs,
   -- content holds the file name if storage type = file
   -- otherwise it holds the text data if storage_type = text.
   content	  text,