Index: openacs-4/packages/dotlrn/sql/postgresql/externals-init.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/postgresql/externals-init.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/dotlrn/sql/postgresql/externals-init.sql	8 Jul 2002 21:04:16 -0000	1.1
+++ openacs-4/packages/dotlrn/sql/postgresql/externals-init.sql	26 Jul 2002 14:53:51 -0000	1.2
@@ -27,6 +27,7 @@
 declare
     foo                         integer;
     gid				integer;
+    sid				integer;
     dotlrn_users_group_id       integer;
 begin
 
@@ -58,18 +59,18 @@
         ''dotLRN Externals''
     );
 
-    insert
-    into dotlrn_user_types
-    (type, pretty_name, group_id)
-    values
-    (''external'', ''dotLRN Externals'', gid);
-
-    foo := rel_segment__new(
+    sid := rel_segment__new(
         ''dotLRN Externals'',
         gid,
         ''dotlrn_external_profile_rel''
     );
 
+    insert
+    into dotlrn_user_types
+    (type, pretty_name, rel_type, group_id, segment_id)
+    values
+    (''external'', ''Externals'', ''dotlrn_external_profile_rel'', gid, sid);
+
     select group_id
     into dotlrn_users_group_id
     from groups