Index: openacs-4/packages/dotlrn-catalog/www/doc/ch01s03.html =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-catalog/www/doc/ch01s03.html,v diff -u -r1.1 -r1.2 --- openacs-4/packages/dotlrn-catalog/www/doc/ch01s03.html 5 Mar 2005 23:02:43 -0000 1.1 +++ openacs-4/packages/dotlrn-catalog/www/doc/ch01s03.html 11 Jul 2006 09:03:14 -0000 1.2 @@ -1,3 +1,33 @@ -
- -Three new roles were created to use them when createing the relations. The first one is for the dotlrn-catalog course and it's called d_catalog_role, the second one is for the dotlrn class and it's called dotlrn-class_role and the last one is for the dotlrn communities and it's called dotlrn_com_role. This roles are the first thing that the package create on installation and their creation code is:
Oracle:
begin acs_rel_type.create_role('d_catalog_role', 'DotLRN Course Catalog Role', 'DotLRN Course Catalog Role'); acs_rel_type.create_role('dotlrn_class_role', 'dotLRN Class Role', 'dotLRN Class Role'); acs_rel_type.create_role('dotlrn_com_role', 'dotLRN Community Role', 'dotLRN Community Role'); commit; end; / show errors
Postgres:
create function inline_0 ( ) returns integer as ' begin PERFORM acs_rel_type__create_role(''d_catalog_role'', ''DotLRN Catalog Role'', ''DotLRN Catalog Role''); PERFORM acs_rel_type__create_role(''dotlrn_class_role'', ''dotLRN Class Role'', ''dotLRN Class Role''); PERFORM acs_rel_type__create_role(''dotlrn_com_role'', ''dotLRN Community Role'', ''dotLRN Community Role''); return 0; end;' language 'plpgsql'; select inline_0 ( ); drop function inline_0 ( );
Three new roles were created to use them when creating the + relations. The first one is for the dotlrn-catalog course and it's + called d_catalog_role, the second one is for the dotlrn class and it's + called dotlrn-class_role and the last one is for the dotlrn communities + and it's called dotlrn_com_role. This roles are the first thing that the + package create on installation and their creation code is:
Oracle:
+ begin
+ acs_rel_type.create_role('d_catalog_role',
+ 'DotLRN Course Catalog Role',
+ 'DotLRN Course Catalog Role');
+ acs_rel_type.create_role('dotlrn_class_role',
+ 'dotLRN Class Role',
+ 'dotLRN Class Role');
+ acs_rel_type.create_role('dotlrn_com_role',
+ 'dotLRN Community Role',
+ 'dotLRN Community Role');
+ commit; end; /
+ show errors
+ Postgres:
+ create function inline_0 ( ) returns integer as '
+ begin
+ PERFORM acs_rel_type__create_role(''d_catalog_role'',
+ ''DotLRN Catalog Role'',
+ ''DotLRN Catalog Role'');
+ PERFORM acs_rel_type__create_role(''dotlrn_class_role'',
+ ''dotLRN Class Role'',
+ ''dotLRN Class Role'');
+ PERFORM acs_rel_type__create_role(''dotlrn_com_role'',
+ ''dotLRN Community Role'',
+ ''dotLRN Community Role'');
+ return 0; end;' language 'plpgsql';
+ select inline_0 ( ); drop function inline_0 ( );
+