BEGIN;

alter table fastdial_company add column tag varchar(24);
update fastdial_company set tag = '' where tag IS NULL;
alter table fastdial_company alter column tag set default '';
alter table fastdial_company alter column tag set not null;

alter table fastdial_contact add column tag varchar(24);
update fastdial_contact set tag = '' where tag IS NULL;
alter table fastdial_contact alter column tag set default '';
alter table fastdial_contact alter column tag set not null;

alter table fastdial_contact drop column country;
alter table fastdial_contact add column country varchar(25);
update fastdial_contact set country = '' where country IS NULL;
alter table fastdial_contact alter column country set default '';
alter table fastdial_contact alter column country set not null;

alter table fastdial_company drop column country;
alter table fastdial_company add column country varchar(25);
update fastdial_company set country = '' where country IS NULL;
alter table fastdial_company alter column country set default '';
alter table fastdial_company alter column country set not null;

COMMIT;

