alter table phoneline add column record varchar(5);
update phoneline set record='none' where record is null and recording='no';
update phoneline set record='both' where record is null and recording='yes';
alter table phoneline alter column record set default 'none';
alter table phoneline alter column record set not null;
alter table phoneline add constraint phoneline_record CHECK (record IN ('none','both','me','other'));
