Index: openacs-4/packages/dotlrn/sql/oracle/dotlrn-init.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/oracle/dotlrn-init.sql,v
diff -u -r1.21 -r1.22
--- openacs-4/packages/dotlrn/sql/oracle/dotlrn-init.sql	20 May 2002 21:39:37 -0000	1.21
+++ openacs-4/packages/dotlrn/sql/oracle/dotlrn-init.sql	20 May 2002 21:55:09 -0000	1.22
@@ -135,15 +135,26 @@
 
     bar := acs_attribute.create_attribute(
         object_type => 'dotlrn_community',
-        attribute_name => 'student_role_pretty_name',
+        attribute_name => 'student_pretty_name',
         datatype => 'string',
-        pretty_name => 'Student Role Pretty Name',
-        pretty_plural => 'Student Role Pretty Names',
+        pretty_name => 'Student Pretty Name',
+        pretty_plural => 'Student Pretty Name',
         min_n_values => 0,
         max_n_values => 1,
         storage => 'generic'
     );
 
+    bar := acs_attribute.create_attribute(
+        object_type => 'dotlrn_community',
+        attribute_name => 'student_pretty_plural',
+        datatype => 'string',
+        pretty_name => 'Student Pretty Plural',
+        pretty_plural => 'Student Pretty Plural',
+        min_n_values => 0,
+        max_n_values => 1,
+        storage => 'generic'
+    );
+
     acs_rel_type.create_role(
         role => 'course_assistant',
         pretty_name => 'Course Assistant',
@@ -152,15 +163,26 @@
 
     bar := acs_attribute.create_attribute(
         object_type => 'dotlrn_community',
-        attribute_name => 'coure_assistant_role_pretty_name',
+        attribute_name => 'coure_assistant_pretty_name',
         datatype => 'string',
-        pretty_name => 'Course Assistant Role Pretty Name',
-        pretty_plural => 'Course Assistant Role Pretty Names',
+        pretty_name => 'Course Assistant Pretty Name',
+        pretty_plural => 'Course Assistant Pretty Name',
         min_n_values => 0,
         max_n_values => 1,
         storage => 'generic'
     );
 
+    bar := acs_attribute.create_attribute(
+        object_type => 'dotlrn_community',
+        attribute_name => 'coure_assistant_pretty_plural',
+        datatype => 'string',
+        pretty_name => 'Course Assistant Pretty Plural',
+        pretty_plural => 'Course Assistant Pretty Plural',
+        min_n_values => 0,
+        max_n_values => 1,
+        storage => 'generic'
+    );
+
     acs_rel_type.create_role(
         role => 'teaching_assistant',
         pretty_name => 'Teaching Assistant',
@@ -169,15 +191,26 @@
 
     bar := acs_attribute.create_attribute(
         object_type => 'dotlrn_community',
-        attribute_name => 'teaching_assistant_role_pretty_name',
+        attribute_name => 'teaching_assistant_pretty_name',
         datatype => 'string',
-        pretty_name => 'Teaching Assistant Role Pretty Name',
-        pretty_plural => 'Teaching Assistant Role Pretty Names',
+        pretty_name => 'Teaching Assistant Pretty Name',
+        pretty_plural => 'Teaching Assistant Pretty Name',
         min_n_values => 0,
         max_n_values => 1,
         storage => 'generic'
     );
 
+    bar := acs_attribute.create_attribute(
+        object_type => 'dotlrn_community',
+        attribute_name => 'teaching_assistant_pretty_plural',
+        datatype => 'string',
+        pretty_name => 'Teaching Assistant Pretty Plural',
+        pretty_plural => 'Teaching Assistant Pretty Plural',
+        min_n_values => 0,
+        max_n_values => 1,
+        storage => 'generic'
+    );
+
     acs_rel_type.create_role(
         role => 'instructor',
         pretty_name => 'Professor',
@@ -186,15 +219,26 @@
 
     bar := acs_attribute.create_attribute(
         object_type => 'dotlrn_community',
-        attribute_name => 'instructor_role_pretty_name',
+        attribute_name => 'instructor_pretty_name',
         datatype => 'string',
-        pretty_name => 'Professor Role Pretty Name',
-        pretty_plural => 'Professor Role Pretty Names',
+        pretty_name => 'Professor Pretty Name',
+        pretty_plural => 'Professor Pretty Name',
         min_n_values => 0,
         max_n_values => 1,
         storage => 'generic'
     );
 
+    bar := acs_attribute.create_attribute(
+        object_type => 'dotlrn_community',
+        attribute_name => 'instructor_pretty_plural',
+        datatype => 'string',
+        pretty_name => 'Professor Pretty Plural',
+        pretty_plural => 'Professor Pretty Plural',
+        min_n_values => 0,
+        max_n_values => 1,
+        storage => 'generic'
+    );
+
     acs_rel_type.create_role(
         role => 'course_admin',
         pretty_name => 'Course Administrator',
@@ -203,15 +247,26 @@
 
     bar := acs_attribute.create_attribute(
         object_type => 'dotlrn_community',
-        attribute_name => 'course_admin_role_pretty_name',
+        attribute_name => 'course_admin_pretty_name',
         datatype => 'string',
-        pretty_name => 'Course Adminsitrator Role Pretty Name',
-        pretty_plural => 'Course Adminsitrator Role Pretty Names',
+        pretty_name => 'Course Adminsitrator Pretty Name',
+        pretty_plural => 'Course Adminsitrator Pretty Name',
         min_n_values => 0,
         max_n_values => 1,
         storage => 'generic'
     );
 
+    bar := acs_attribute.create_attribute(
+        object_type => 'dotlrn_community',
+        attribute_name => 'course_admin_pretty_plural',
+        datatype => 'string',
+        pretty_name => 'Course Adminsitrator Pretty Plural',
+        pretty_plural => 'Course Adminsitrator Pretty Plural',
+        min_n_values => 0,
+        max_n_values => 1,
+        storage => 'generic'
+    );
+
     acs_rel_type.create_role(
         role => 'admin',
         pretty_name => 'Administrator',
@@ -220,15 +275,26 @@
 
     bar := acs_attribute.create_attribute(
         object_type => 'dotlrn_community',
-        attribute_name => 'admin_role_pretty_name',
+        attribute_name => 'admin_pretty_name',
         datatype => 'string',
-        pretty_name => 'Administrator Role Pretty Name',
-        pretty_plural => 'RAdministrator ole Pretty Names',
+        pretty_name => 'Administrator Pretty Name',
+        pretty_plural => 'RAdministrator Pretty Name',
         min_n_values => 0,
         max_n_values => 1,
         storage => 'generic'
     );
 
+    bar := acs_attribute.create_attribute(
+        object_type => 'dotlrn_community',
+        attribute_name => 'admin_pretty_plural',
+        datatype => 'string',
+        pretty_name => 'Administrator Pretty Plural',
+        pretty_plural => 'RAdministrator Pretty Plural',
+        min_n_values => 0,
+        max_n_values => 1,
+        storage => 'generic'
+    );
+
     -- create basic rel_types
     acs_rel_type.create_type(
         rel_type => 'dotlrn_member_rel',