Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/t.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/Attic/t.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/t.sql	31 May 2009 01:00:02 -0000	1.1
@@ -0,0 +1,43 @@
+alter table users drop bio;
+alter table users add bio text;
+
+create function inline_0 ()
+returns integer as '
+declare
+  one_user_id integer;
+  bio_id integer;
+begin
+
+  bio_id := attribute_id
+            from acs_attributes
+            where object_type = ''person''
+            and attribute_name = ''bio'';
+
+  for one_user_id in select user_id from users loop
+    if exists(select attr_value
+              from acs_attribute_values
+              where object_id = one_user_id
+              and attribute_id = bio_id) then
+      update users
+      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;
+    end if;
+  end loop;
+
+  delete from acs_attribute_values
+  where attribute_id = bio_id;
+
+  perform acs_attribute__drop_attribute (''person'',''bio'');
+  perform acs_attribute__drop_attribute (''person'',''bio_mime_type'');
+
+  return 0;
+
+end;' language 'plpgsql';
+
+select inline_0 ();
+
+drop function inline_0 ();
+
Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.6.0d2-5.6.0d3.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/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/postgresql/upgrade/upgrade-5.6.0d2-5.6.0d3.sql	31 May 2009 01:00:02 -0000	1.1
@@ -0,0 +1,59 @@
+create function inline_0 ()
+returns integer as '
+begin
+
+  perform acs_attribute__create_attribute (
+        ''user'',
+        ''username'',
+        ''string'',
+        ''#acs-kernel.Username#'',
+        ''#acs-kernel.Usernames#'',
+        null,
+        null,
+        null,
+	0,
+	1,
+        null,
+        ''type_specific'',
+        ''f''
+      );
+
+  perform 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''
+      );
+
+  perform 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';
+
+select inline_0 ();
+
+drop function inline_0 ();