Index: openacs-4/packages/acs-kernel/sql/postgresql/rel-segments-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/rel-segments-create.sql,v
diff -u -r1.9 -r1.10
--- openacs-4/packages/acs-kernel/sql/postgresql/rel-segments-create.sql	18 Jun 2004 18:21:57 -0000	1.9
+++ openacs-4/packages/acs-kernel/sql/postgresql/rel-segments-create.sql	27 Feb 2005 01:21:07 -0000	1.10
@@ -61,10 +61,12 @@
         segment_name    varchar(230) not null,
         group_id        integer not null
                         constraint rel_segments_group_id_fk
-                        references groups (group_id),
+                        references groups (group_id)
+                        on delete cascade,
         rel_type        varchar(100) not null
                         constraint rel_segments_rel_type_fk
-                        references acs_rel_types (rel_type),
+                        references acs_rel_types (rel_type)
+                        on delete cascade,
         constraint rel_segments_grp_rel_type_uq unique(group_id, rel_type)
 );
 
@@ -160,12 +162,14 @@
                     constraint party_member_party_nn
                     not null
                     constraint party_member_party_fk
-                    references parties,
+                    references parties
+                    on delete cascade,
     member_id       integer
                     constraint party_member_member_nn
                     not null
                     constraint party_member_member_fk
-                    references parties,
+                    references parties
+                    on delete cascade,
     tag             integer
                     constraint party_member_tag_nn
                     not null,