Index: openacs-4/packages/dotlrn/sql/oracle/dotlrn-users-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/oracle/Attic/dotlrn-users-create.sql,v diff -u -r1.10 -r1.11 --- openacs-4/packages/dotlrn/sql/oracle/dotlrn-users-create.sql 13 Mar 2002 18:00:38 -0000 1.10 +++ openacs-4/packages/dotlrn/sql/oracle/dotlrn-users-create.sql 22 Mar 2002 22:23:54 -0000 1.11 @@ -45,7 +45,9 @@ registered_users.first_names, registered_users.last_name, registered_users.email, - dotlrn_user_types.type + dotlrn_user_types.type, + dotlrn_user_types.pretty_name as pretty_type, + dotlrn_user_types.group_id from dotlrn_user_profile_rels, acs_rels, registered_users,