Index: openacs-4/packages/acs-kernel/acs-kernel.info =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/acs-kernel.info,v diff -u -r1.105 -r1.106 --- openacs-4/packages/acs-kernel/acs-kernel.info 30 May 2009 20:42:12 -0000 1.105 +++ openacs-4/packages/acs-kernel/acs-kernel.info 31 May 2009 00:58:33 -0000 1.106 @@ -7,15 +7,15 @@ t t - + OpenACS Core Team Routines and data models providing the foundation for OpenACS-based Web services. 2008-05-31 OpenACS The OpenACS kernel contains the core datamodel create and drop scripts for such things as objects, groups, partiies and the supporting PL/SQL and PL/pgSQL procedures. 3 - + Index: openacs-4/packages/acs-kernel/catalog/acs-kernel.en_US.ISO-8859-1.xml =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/catalog/acs-kernel.en_US.ISO-8859-1.xml,v diff -u -r1.44 -r1.45 --- openacs-4/packages/acs-kernel/catalog/acs-kernel.en_US.ISO-8859-1.xml 22 Jul 2008 15:17:04 -0000 1.44 +++ openacs-4/packages/acs-kernel/catalog/acs-kernel.en_US.ISO-8859-1.xml 31 May 2009 00:58:33 -0000 1.45 @@ -7,6 +7,8 @@ The identifying label for an authentication server, such as an LDAP or RADIUS server. Actions + Biography + Biographies Header for a list of actions which may be taken on the displayed content actions @@ -134,11 +136,15 @@ Person Registered Users Registered Users + Screen Name + Screen Names The Public The Public Unregistered Unregistered Visitor URL User + Username + Username Visitor Index: openacs-4/packages/acs-kernel/sql/oracle/community-core-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/community-core-create.sql,v diff -u -r1.17 -r1.18 --- openacs-4/packages/acs-kernel/sql/oracle/community-core-create.sql 30 May 2009 21:57:44 -0000 1.17 +++ openacs-4/packages/acs-kernel/sql/oracle/community-core-create.sql 31 May 2009 00:58:33 -0000 1.18 @@ -198,6 +198,36 @@ package_name => 'acs_user' ); + attr_id := acs_attribute.create_attribute ( + object_type => 'user', + attribute_name => 'bio', + datatype => 'string', + pretty_name => '#acs-kernel.Bio#', + pretty_plural => '#acs-kernel.Bios#', + min_n_values => 0, + max_n_values => 1 + ); + + attr_id := acs_attribute.create_attribute ( + object_type => 'user', + attribute_name => 'username', + datatype => 'string', + pretty_name => '#acs-kernel.Username#', + pretty_plural => '#acs-kernel.Usernames#', + min_n_values => 0, + max_n_values => 1 + ); + + attr_id := acs_attribute.create_attribute ( + object_type => 'user', + attribute_name => 'screen_name', + datatype => 'string', + pretty_name => '#acs-kernel.Screen_Name#', + pretty_plural => '#acs-kernel.Screen_Names#', + min_n_values => 0, + max_n_values => 1 + ); + commit; end; / Index: openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.6.0d2-5.6.0d3.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.6.0d2-5.6.0d3.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.6.0d2-5.6.0d3.sql 31 May 2009 00:58:33 -0000 1.1 @@ -0,0 +1,38 @@ + +declare + attr_id integer; +begin + + attr_id := acs_attribute.create_attribute ( + object_type => 'user', + attribute_name => 'bio', + datatype => 'string', + pretty_name => '#acs-kernel.Bio#', + pretty_plural => '#acs-kernel.Bios#', + min_n_values => 0, + max_n_values => 1 + ); + + attr_id := acs_attribute.create_attribute ( + object_type => 'user', + attribute_name => 'username', + datatype => 'string', + pretty_name => '#acs-kernel.Username#', + pretty_plural => '#acs-kernel.Usernames#', + min_n_values => 0, + max_n_values => 1 + ); + + attr_id := acs_attribute.create_attribute ( + object_type => 'user', + attribute_name => 'screen_name', + datatype => 'string', + pretty_name => '#acs-kernel.Screen_Name#', + pretty_plural => '#acs-kernel.Screen_Names#', + min_n_values => 0, + max_n_values => 1 + ); + +end; +/ +show errors; Index: openacs-4/packages/acs-kernel/sql/postgresql/community-core-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/community-core-create.sql,v diff -u -r1.26 -r1.27 --- openacs-4/packages/acs-kernel/sql/postgresql/community-core-create.sql 30 May 2009 20:42:12 -0000 1.26 +++ openacs-4/packages/acs-kernel/sql/postgresql/community-core-create.sql 31 May 2009 00:58:33 -0000 1.27 @@ -230,7 +230,57 @@ null ); + attr_id := acs_attribute__create_attribute ( + ''user'', + ''username'', + ''string'', + ''#acs-kernel.Username#'', + ''#acs-kernel.Usernames#'', + null, + null, + null, + 0, + 1, + null, + ''type_specific'', + ''f'' + ); + attr_id := acs_attribute__create_attribute ( + ''user'', + ''screen_name'', + ''string'', + ''#acs-kernel.Screen_Name#'', + ''#acs-kernel.Screen_Names#'', + null, + null, + null, + 0, + 1, + null, + ''type_specific'', + ''f'' + ); + + attr_id := acs_attribute__create_attribute ( + ''user'', + ''bio'', + ''string'', + ''#acs-kernel.Bio#'', + ''#acs-kernel.Bios#'', + null, + null, + null, + 0, + 1, + null, + ''type_specific'', + ''f'' + ); + + + + return 0; end;' language 'plpgsql';