Index: openacs-4/packages/dotlrn/sql/postgresql/users-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/postgresql/users-create.sql,v
diff -u -N -r1.2 -r1.3
--- openacs-4/packages/dotlrn/sql/postgresql/users-create.sql	12 Jul 2002 21:26:48 -0000	1.2
+++ openacs-4/packages/dotlrn/sql/postgresql/users-create.sql	26 Jul 2002 14:53:51 -0000	1.3
@@ -43,10 +43,20 @@
                                 constraint dotlrn_user_types_pk
                                 primary key,
     pretty_name                 varchar(200),
+    rel_type                    varchar(100)
+                                constraint dotlrn_user_types_rel_type_fk
+                                references acs_rel_types (rel_type)
+                                constraint dotlrn_user_types_rel_type_nn
+                                not null,
     group_id                    integer
                                 constraint dotlrn_user_types_group_id_fk
                                 references profiled_groups (group_id)
                                 constraint dotlrn_user_types_group_id_nn
+                                not null,
+    segment_id                  integer
+                                constraint dotlrn_user_types_segment_fk
+                                references rel_segments (segment_id)
+                                constraint dotlrn_user_types_segment_nn
                                 not null
 );
 
@@ -62,7 +72,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,