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

