ALTER TABLE contact add column canlogout varchar(3);
UPDATE contact SET canlogout = 'yes' where canlogout is NULL;
ALTER TABLE contact ALTER column canlogout SET not NULL;
ALTER TABLE contact ALTER column canlogout SET default 'yes';
alter table contact add constraint contact_canlogout CHECK (canlogout IN ('yes','no'));
