BEGIN;

ALTER TABLE contact add column position varchar(30);
UPDATE contact SET position = '' where position is NULL;
ALTER TABLE contact ALTER column position SET not NULL;
ALTER TABLE contact ALTER column position SET default '';

COMMIT;
