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.18 -r1.19 --- openacs-4/packages/acs-kernel/sql/oracle/community-core-create.sql 31 May 2009 00:58:33 -0000 1.18 +++ openacs-4/packages/acs-kernel/sql/oracle/community-core-create.sql 2 Jun 2009 00:40:22 -0000 1.19 @@ -185,6 +185,16 @@ max_n_values => 1 ); + attr_id := acs_attribute.create_attribute ( + object_type => 'person', + attribute_name => 'bio', + datatype => 'string', + pretty_name => '#acs-kernel.Bio#', + pretty_plural => '#acs-kernel.Bios#', + min_n_values => 0, + max_n_values => 1 + ); + -- -- User: people who have registered in the system -- @@ -200,16 +210,6 @@ 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#', @@ -399,7 +399,8 @@ first_names varchar2(100) constraint persons_first_names_nn not null, last_name varchar2(100) - constraint persons_last_name_nn not null + constraint persons_last_name_nn not null, + bio varchar2(4000) ); comment on table persons is ' @@ -563,7 +564,6 @@ screen_name varchar2(100) constraint users_screen_name_un unique, - bio varchar2(4000), priv_name integer default 0 not null, priv_email integer default 5 not null, email_verified_p char(1) default 't'