ALTER TABLE contact ADD column company integer;
UPDATE contact SET company = contact_company.company FROM contact_company WHERE contact.id=contact_company.contact;
UPDATE contact set company = '1' where company IS NULL;
ALTER TABLE contact ALTER company SET not null;
ALTER TABLE contact ALTER company SET default '1';
