ALTER TABLE contact ADD COLUMN presence INTEGER;
UPDATE contact SET presence='1' WHERE presence IS NULL;
ALTER TABLE contact ALTER presence SET DEFAULT '1';
ALTER TABLE contact ALTER presence SET NOT NULL;
