BEGIN;
-- extend fromuser to 64 len
alter table trunk add column tmp varchar(64);
update trunk set tmp = '' where tmp IS NULL;
alter table trunk alter column tmp set not null;
alter table trunk alter column tmp set default '';
update trunk set tmp = fromuser where fromuser IS NOT NULL;
update trunk set tmp = '' where fromuser IS NULL;
alter table trunk drop column fromuser;
alter table trunk rename column tmp to fromuser;
COMMIT;


