Index: openacs-4/packages/dotlrn/sql/oracle/dotlrn-professors-init.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/oracle/Attic/dotlrn-professors-init.sql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/dotlrn/sql/oracle/dotlrn-professors-init.sql	29 Mar 2002 19:14:44 -0000	1.2
+++ openacs-4/packages/dotlrn/sql/oracle/dotlrn-professors-init.sql	28 Apr 2002 04:08:41 -0000	1.3
@@ -30,8 +30,8 @@
     acs_rel_type.create_type(
         rel_type => 'dotlrn_professor_profile_rel',
         supertype => 'dotlrn_user_profile_rel',
-        pretty_name => 'dotLRN Professor Profile Membership',
-        pretty_plural => 'dotLRN Professor Profile Memberships',
+        pretty_name => 'dotLRN Profile Professor',
+        pretty_plural => 'dotLRN Profile Professors',
         package_name => 'dotlrn_professor_profile_rel',
         table_name => 'dotlrn_professor_profile_rels',
         id_column => 'rel_id',
@@ -62,7 +62,7 @@
     ('professor', 'Professor', group_id);
 
     foo := rel_segment.new(
-        segment_name => 'dotLRN Profiled Professors',
+        segment_name => 'dotLRN Professors',
         group_id => group_id,
         rel_type => 'dotlrn_professor_profile_rel'
     );
@@ -80,42 +80,3 @@
 end;
 /
 show errors
-
-declare
-    foo                         integer;
-begin
-
-    acs_rel_type.create_type(
-        rel_type => 'dotlrn_full_professor_profile_rel',
-        supertype => 'dotlrn_full_user_profile_rel',
-        pretty_name => 'dotLRN Full Professor Profile Membership',
-        pretty_plural => 'dotLRN Full Professor Profile Memberships',
-        package_name => 'dotlrn_full_prof_profile_rel',
-        table_name => 'dotlrn_full_prof_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_professor_profile_provider');
-
-    foo := rel_segment.new(
-        segment_name => 'dotLRN Full Profiled Professors',
-        group_id => foo,
-        rel_type => 'dotlrn_full_professor_profile_rel'
-    );
-
-end;
-/
-show errors