BEGIN;
alter table company add column tmp varchar(40);
update company set tmp = '' where tmp IS NULL;
alter table company alter column tmp set not null;
alter table company alter column tmp set default '';
update company set tmp = suppl_password where suppl_password IS NOT NULL;
update company set tmp = '' where suppl_password IS NULL;
alter table company drop column suppl_password ;
alter table company rename column tmp to suppl_password;
COMMIT;
