Index: openacs-4/packages/dotlrn/sql/postgresql/dotlrn-professors-init.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/postgresql/Attic/dotlrn-professors-init.sql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/dotlrn/sql/postgresql/dotlrn-professors-init.sql 29 Mar 2002 19:14:44 -0000 1.2 +++ openacs-4/packages/dotlrn/sql/postgresql/dotlrn-professors-init.sql 2 Jul 2002 18:40:08 -0000 1.3 @@ -32,12 +32,12 @@ PERFORM acs_rel_type__create_type( ''dotlrn_professor_profile_rel'', - ''dotLRN Professor Profile Membership'', - ''dotLRN Professor Profile Memberships'', - ''dotlrn_user_profile_rel'', + ''dotlrn_user_profile_rel'', + ''dotLRN Professor Profile Professor'', + ''dotLRN Professor Profile Professors'', + ''dotlrn_professor_profile_rel'', ''dotlrn_professor_profile_rels'', ''rel_id'', - ''dotlrn_professor_profile_rel'', ''profiled_group'', null, 0, @@ -65,7 +65,7 @@ (''professor'', ''Professor'', group_id); foo := rel_segment__new( - ''dotLRN Profiled Professors'', + ''dotLRN Professors'', group_id, ''dotlrn_professor_profile_rel'' ); @@ -95,36 +95,3 @@ PERFORM acs_rel_type--create_type( ''dotlrn_full_professor_profile_rel'', ''dotLRN Full Professor Profile Membership'', - ''dotLRN Full Professor Profile Memberships'', - ''dotlrn_full_user_profile_rel'', - ''dotlrn_full_professor_profile_rels'', - ''rel_id'', - ''dotlrn_full_professor_profile_rel'', - ''profiled_group'', - null, - 0, - null, - ''user'', - null, - 0, - 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( - ''dotLRN Full Profiled Professors'', - foo, - ''dotlrn_full_professor_profile_rel'' - ); - -end; -' language 'plpgsql'; - -select inline_2(); -drop function inline_2();