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.63.2.2 -r1.63.2.3
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql	10 Feb 2016 09:14:19 -0000	1.63.2.2
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql	11 Feb 2016 08:07:03 -0000	1.63.2.3
@@ -390,10 +390,14 @@
                      references acs_objects,
   parent_id          integer
                      constraint cr_child_rels_parent_id_nn
-                     not null,
+                     not null
+		     CONSTRAINT cr_child_rels_parent_id_fk
+                     FOREIGN KEY (parent_id) REFERENCES acs_objects(object_id) ON DELETE CASCADE,
   child_id           integer
                      constraint cr_child_rels_child_id_nn
-                     not null,
+                     not null
+		     CONSTRAINT cr_child_rels_child_id_fk
+		     FOREIGN KEY (child_id) REFERENCES cr_items(item_id) ON DELETE CASCADE,
   relation_tag       varchar(100),
   order_n            integer
 );
@@ -417,7 +421,8 @@
                      references acs_objects,
   item_id            integer
                      constraint cr_item_rels_item_id_fk
-                     references cr_items,
+		     CONSTRAINT cr_item_rels_item_id_fk
+		     FOREIGN KEY (item_id) REFERENCES cr_items(item_id) ON DELETE CASCADE,
   related_object_id  integer
                      constraint cr_item_rels_rel_obj_fk
                      references acs_objects,
@@ -950,8 +955,8 @@
 		  constraint cr_symlinks_symlink_id_pk 
                   primary key,
   target_id       integer
-                  constraint cr_symlinks_target_id_fk
-		  references cr_items
+  		  CONSTRAINT cr_symlinks_target_id_fk
+		  FOREIGN KEY (target_id) REFERENCES cr_items(item_id) ON DELETE CASCADE
 		  constraint cr_symlinks_target_id_nn
 		  not null,
   label		  varchar(1000)