Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.6.0d1-5.6.0d2.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.6.0d1-5.6.0d2.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.6.0d1-5.6.0d2.sql	30 May 2009 20:48:57 -0000	1.1
+++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.6.0d1-5.6.0d2.sql	2 Jun 2009 00:40:22 -0000	1.2
@@ -1,10 +1,11 @@
-alter table users add bio text;
+alter table persons add bio text;
 
 create function inline_0 ()
 returns integer as '
 declare
   one_user_id integer;
   bio_id integer;
+  attr_id integer;
 begin
 
   bio_id := attribute_id
@@ -17,12 +18,12 @@
               from acs_attribute_values
               where object_id = one_user_id
               and attribute_id = bio_id) then
-      update users
+      update persons
       set bio = (select attr_value
                  from acs_attribute_values
                  where object_id = one_user_id
                  and attribute_id = bio_id)
-      where user_id = one_user_id;
+      where person_id = one_user_id;
     end if;
   end loop;
 
@@ -32,6 +33,22 @@
   perform acs_attribute__drop_attribute (''person'',''bio'');
   perform acs_attribute__drop_attribute (''person'',''bio_mime_type'');
 
+  attr_id := acs_attribute__create_attribute (
+        ''person'',
+        ''bio'',
+        ''string'',
+        ''#acs-kernel.Bio#'',
+        ''#acs-kernel.Bios#'',
+        null,
+        null,
+        null,
+	0,
+	1,
+        null,
+        ''type_specific'',
+        ''f''
+      );
+
   return 0;
 
 end;' language 'plpgsql';