Index: openacs-4/packages/dotlrn/sql/oracle/dotlrn-externals-init.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/oracle/Attic/dotlrn-externals-init.sql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/dotlrn/sql/oracle/dotlrn-externals-init.sql 29 Mar 2002 19:14:44 -0000 1.2 +++ openacs-4/packages/dotlrn/sql/oracle/dotlrn-externals-init.sql 28 Apr 2002 04:08:41 -0000 1.3 @@ -30,8 +30,8 @@ acs_rel_type.create_type( rel_type => 'dotlrn_external_profile_rel', supertype => 'dotlrn_user_profile_rel', - pretty_name => 'dotLRN External Profile Membership', - pretty_plural => 'dotLRN External Profile Memberships', + pretty_name => 'dotLRN Profile External', + pretty_plural => 'dotLRN Profile Externals', package_name => 'dotlrn_external_profile_rel', table_name => 'dotlrn_external_profile_rels', id_column => 'rel_id', @@ -62,7 +62,7 @@ ('external', 'External', group_id); foo := rel_segment.new( - segment_name => 'dotLRN Profiled Externals', + segment_name => 'dotLRN Externals', group_id => group_id, rel_type => 'dotlrn_external_profile_rel' ); @@ -80,42 +80,3 @@ end; / show errors - -declare - foo integer; -begin - - acs_rel_type.create_type( - rel_type => 'dotlrn_full_external_profile_rel', - supertype => 'dotlrn_full_user_profile_rel', - pretty_name => 'dotLRN Full External Profile Membership', - pretty_plural => 'dotLRN Full External Profile Memberships', - package_name => 'dotlrn_full_ext_profile_rel', - table_name => 'dotlrn_full_ext_profile_rels', - id_column => 'rel_id', - object_type_one => 'profiled_group', - role_one => null, - min_n_rels_one => 0, - max_n_rels_one => null, - object_type_two => 'user', - role_two => null, - min_n_rels_two => 0, - max_n_rels_two => 1 - ); - - select min(group_id) - into foo - from profiled_groups - where profile_provider = (select min(impl_id) - from acs_sc_impls - where impl_name = 'dotlrn_external_profile_provider'); - - foo := rel_segment.new( - segment_name => 'dotLRN Full Profiled Externals', - group_id => foo, - rel_type => 'dotlrn_full_external_profile_rel' - ); - -end; -/ -show errors