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.37 -r1.38
--- openacs-4/packages/acs-content-repository/acs-content-repository.info	25 Apr 2004 15:09:43 -0000	1.37
+++ openacs-4/packages/acs-content-repository/acs-content-repository.info	29 Apr 2004 15:41:17 -0000	1.38
@@ -7,7 +7,7 @@
     <initial-install-p>t</initial-install-p>
     <singleton-p>t</singleton-p>
 
-    <version name="5.2.0d2" url="http://openacs.org/repository/download/apm/acs-content-repository-5.2.0d2.apm">
+    <version name="5.2.0d3" url="http://openacs.org/repository/download/apm/acs-content-repository-5.2.0d3.apm">
         <owner url="http://openacs.org">OpenACS</owner>
         <summary>The canonical repository for OpenACS content.</summary>
         <release-date>2004-04-18</release-date>
@@ -19,7 +19,7 @@
          other CMS backing functionality.  Utilized by Bug Tracker, File Storage, and other packages.
         </description>
 
-        <provides url="acs-content-repository" version="5.2.0d2"/>
+        <provides url="acs-content-repository" version="5.2.0d3"/>
         <requires url="acs-kernel" version="5.2.0d2"/>
         <requires url="acs-service-contract" version="5.1.0d1"/>
         <requires url="search" version="5.1.0d1"/>
Index: openacs-4/packages/acs-content-repository/sql/oracle/upgrade/upgrade-5.2.0d2-5.2.0d3.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/oracle/upgrade/upgrade-5.2.0d2-5.2.0d3.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-content-repository/sql/oracle/upgrade/upgrade-5.2.0d2-5.2.0d3.sql	29 Apr 2004 15:41:17 -0000	1.1
@@ -0,0 +1,11 @@
+-- @cvs-id $Id: upgrade-5.2.0d2-5.2.0d3.sql,v 1.1 2004/04/29 15:41:17 jeffd Exp $
+-- @author davis@xarg.net
+-- cascade on delete of folder and of content_type
+alter table cr_folder_type_map drop constraint cr_folder_type_map_fldr_fk;
+alter table cr_folder_type_map add constraint cr_folder_type_map_fldr_fk
+        foreign key (folder_id) references cr_folders on delete cascade;
+
+
+alter table cr_folder_type_map drop constraint cr_folder_type_map_typ_fk;
+alter table cr_folder_type_map add constraint cr_folder_type_map_typ_fk
+        foreign key (content_type) references acs_object_types on delete cascade;
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.43 -r1.44
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql	18 Feb 2004 17:02:58 -0000	1.43
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql	29 Apr 2004 15:41:17 -0000	1.44
@@ -833,10 +833,10 @@
 create table cr_folder_type_map (
   folder_id	integer
 		constraint cr_folder_type_map_fldr_fk
-		references cr_folders,
+		references cr_folders on delete cascade,
   content_type  varchar(100)
 		constraint cr_folder_type_map_typ_fk
-		references acs_object_types,
+		references acs_object_types on delete cascade,
   constraint cr_folder_type_map_pk
   primary key (folder_id, content_type)
 );
Index: openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.2.0d2-5.2.0d3.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.2.0d2-5.2.0d3.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.2.0d2-5.2.0d3.sql	29 Apr 2004 15:37:11 -0000	1.1
+++ openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.2.0d2-5.2.0d3.sql	29 Apr 2004 15:41:17 -0000	1.2
@@ -1,3 +1,6 @@
+-- @cvs-id $Id$
+-- @author davis@xarg.net
+-- cascade on delete of folder and of content_type
 alter table cr_folder_type_map drop constraint cr_folder_type_map_fldr_fk;
 alter table cr_folder_type_map add constraint cr_folder_type_map_fldr_fk
         foreign key (folder_id) references cr_folders on delete cascade;