BEGIN;
-- extend out_username 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 = out_username where out_username IS NOT NULL;
update trunk set tmp = '' where out_username IS NULL;
alter table trunk drop column out_username;
alter table trunk rename column tmp to out_username;

-- extend in_username 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 = in_username where in_username IS NOT NULL;
update trunk set tmp = '' where in_username IS NULL;
alter table trunk drop column in_username;
alter table trunk rename column tmp to in_username;
COMMIT;

