Index: openacs-4/packages/acs-kernel/sql/oracle/rel-segments-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/rel-segments-create.sql,v
diff -u -r1.9 -r1.10
--- openacs-4/packages/acs-kernel/sql/oracle/rel-segments-create.sql	11 Aug 2006 21:58:04 -0000	1.9
+++ openacs-4/packages/acs-kernel/sql/oracle/rel-segments-create.sql	18 Aug 2006 18:17:49 -0000	1.10
@@ -44,20 +44,21 @@
 -- using rel_segment.delete before dropping a relationship type.
 
 create table rel_segments (
-        segment_id      not null
+        segment_id      constraint rel_segments_segment_id_nn not null
                         constraint rel_segments_segment_id_fk
                         references parties (party_id)
-                        constraint rel_segments_pk primary key,
-        segment_name    varchar2(230) not null,
-        group_id        not null
+                        constraint rel_segments_segment_id_pk primary key,
+        segment_name    varchar2(230) 
+			constraint rel_segments_segment_name_nn not null,
+        group_id        constraint rel_segments_group_id_nn not null
                         constraint rel_segments_group_id_fk
                         references groups (group_id)
                         on delete cascade,
-        rel_type        not null
+        rel_type        constraint rel_segments_rel_type_nn not null
                         constraint rel_segments_rel_type_fk
                         references acs_rel_types (rel_type)
                         on delete cascade,
-        constraint rel_segments_grp_rel_type_uq unique(group_id, rel_type)
+        constraint rel_segments_grp_rel_type_un unique(group_id, rel_type)
 );
 
 -- rel_type has a foreign key reference - create an index