BEGIN;
alter table fastdial_contact add column shortnumber2 varchar(16);
update fastdial_contact set shortnumber2 = '' where shortnumber2 IS NULL;
alter table fastdial_contact alter column shortnumber2 set default '';
alter table fastdial_contact alter column shortnumber2 set not null;
update fastdial_contact set shortnumber = '' where shortnumber IS NULL;
update fastdial_contact set shortnumber2 = shortnumber;
alter table fastdial_contact drop column shortnumber;
alter table fastdial_contact rename column shortnumber2 to shortnumber;
COMMIT;

