Index: openacs-4/packages/acs-content-repository/acs-content-repository.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/acs-content-repository.info,v
diff -u -r1.82 -r1.83
--- openacs-4/packages/acs-content-repository/acs-content-repository.info	23 Oct 2008 13:04:02 -0000	1.82
+++ openacs-4/packages/acs-content-repository/acs-content-repository.info	2 Apr 2009 22:31:13 -0000	1.83
@@ -7,7 +7,7 @@
     <initial-install-p>t</initial-install-p>
     <singleton-p>t</singleton-p>
 
-    <version name="5.5.0d3" url="http://openacs.org/repository/download/apm/acs-content-repository-5.5.0d3.apm">
+    <version name="5.5.0d4" url="http://openacs.org/repository/download/apm/acs-content-repository-5.5.0d4.apm">
         <owner url="http://openacs.org">OpenACS</owner>
         <summary>The canonical repository for OpenACS content.</summary>
         <release-date>2008-05-31</release-date>
@@ -20,7 +20,7 @@
         <license>GPL</license>
         <maturity>3</maturity>
 
-        <provides url="acs-content-repository" version="5.5.0d3"/>
+        <provides url="acs-content-repository" version="5.5.0d4"/>
         <requires url="acs-kernel" version="5.5.0d1"/>
         <requires url="acs-service-contract" version="5.5.0d1"/>
         <requires url="search" version="5.5.0d1"/>
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 -r1.55 -r1.56
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql	10 Feb 2009 18:31:54 -0000	1.55
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql	2 Apr 2009 22:31:13 -0000	1.56
@@ -470,7 +470,8 @@
   -- lob_id if storage_type = lob.
   lob             integer
                   constraint cr_revisions_lob_fk
-                  references lobs,
+                  references lobs
+                  on delete set null,
   -- content holds the file name if storage type = file
   -- otherwise it holds the text data if storage_type = text.
   content	  text,
Index: openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.5.0d3-5.5.0d4.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.5.0d3-5.5.0d4.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.5.0d3-5.5.0d4.sql	2 Apr 2009 22:31:13 -0000	1.1
@@ -0,0 +1,6 @@
+alter table cr_revisions
+drop constraint cr_revisions_lob_fk;
+
+alter table cr_revisions
+add constraint cr_revisions_lob_fk
+foreign key (lob) references lobs on delete set null;