Index: openacs-4/packages/dotlrn/sql/postgresql/dotlrn-students-init.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/postgresql/Attic/dotlrn-students-init.sql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/dotlrn/sql/postgresql/dotlrn-students-init.sql 29 Mar 2002 19:14:44 -0000 1.2 +++ openacs-4/packages/dotlrn/sql/postgresql/dotlrn-students-init.sql 2 Jul 2002 18:40:08 -0000 1.3 @@ -32,12 +32,12 @@ PERFORM acs_rel_type__create_type( ''dotlrn_student_profile_rel'', - ''dotLRN Student Profile Membership'', - ''dotLRN Student Profile Memberships'', - ''dotlrn_user_profile_rel'', + ''dotlrn_user_profile_rel'', + ''dotLRN Profile Student'', + ''dotLRN Profile Students'', + ''dotlrn_student_profile_rel'', ''dotlrn_student_profile_rels'', ''rel_id'', - ''dotlrn_student_profile_rel'', ''profiled_group'', null, 0, @@ -65,7 +65,7 @@ (''student'', ''Student'', group_id); foo := rel_segment__new( - ''dotLRN Profiled Students'', + ''dotLRN Students'', group_id, ''dotlrn_student_profile_rel'' ); @@ -86,45 +86,3 @@ select inline_1(); drop function inline_1(); - -create function inline_2() -returns integer as ' -declare - foo integer; -begin - PERFORM acs_rel_type--create_type( - ''dotlrn_full_student_profile_rel'', - ''dotLRN Full Student Profile Membership'', - ''dotLRN Full Student Profile Memberships'', - ''dotlrn_full_user_profile_rel'', - ''dotlrn_full_student_profile_rels'', - ''rel_id'', - ''dotlrn_full_student_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_student_profile_provider''); - - foo := rel_segment__new( - ''dotLRN Full Profiled Students'', - foo, - ''dotlrn_full_student_profile_rel'' - ); - -end; -' language 'plpgsql'; - -select inline_2(); -drop function inline_2();