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 -N --- openacs-4/packages/acs-kernel/sql/postgresql/upgrade/t.sql 31 May 2009 01:00:02 -0000 1.1 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,43 +0,0 @@ -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 -N -r1.1 -r1.2 --- 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 +++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.6.0d2-5.6.0d3.sql 4 Jun 2009 22:56:39 -0000 1.2 @@ -34,22 +34,6 @@ ''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';