Index: openacs-4/packages/dotlrn/sql/oracle/users-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/oracle/users-create.sql,v
diff -u -N -r1.3 -r1.4
--- openacs-4/packages/dotlrn/sql/oracle/users-create.sql	2 Jun 2002 00:05:56 -0000	1.3
+++ openacs-4/packages/dotlrn/sql/oracle/users-create.sql	26 Jul 2002 14:53:51 -0000	1.4
@@ -40,9 +40,17 @@
                                 constraint dotlrn_user_types_pk
                                 primary key,
     pretty_name                 varchar(200),
+    rel_type                    constraint dotlrn_user_types_rel_type_fk
+                                references acs_rel_types (rel_type)
+                                constraint dotlrn_user_types_rel_type_nn
+                                not null,
     group_id                    constraint dotlrn_user_types_group_id_fk
                                 references profiled_groups (group_id)
                                 constraint dotlrn_user_types_group_id_nn
+                                not null,
+    segment_id                  constraint dotlrn_user_types_segment_fk
+                                references rel_segments (segment_id)
+                                constraint dotlrn_user_types_segment_nn
                                 not null
 );
 
@@ -58,7 +66,9 @@
            parties.email,
            dotlrn_user_types.type,
            dotlrn_user_types.pretty_name as pretty_type,
-           dotlrn_user_types.group_id
+           dotlrn_user_types.rel_type,
+           dotlrn_user_types.group_id,
+           dotlrn_user_types.segment_id
     from dotlrn_user_profile_rels,
          dotlrn_user_types,
          acs_rels,