alter table trunk add column genringing varchar(3);
update trunk set genringing = 'no' where genringing IS NULL;
alter table trunk alter column genringing set not NULL;
alter table trunk alter column genringing set default 'no';

alter table trunk drop constraint trunk_genringing;
alter table trunk add constraint trunk_genringing CHECK (genringing IN ('yes','no'));

