BEGIN;

alter table zap_channel add column answeronpolarityswitch varchar(3);
alter table zap_channel alter column answeronpolarityswitch set default 'yes';
update zap_channel set answeronpolarityswitch = 'yes' where answeronpolarityswitch is null;
alter table zap_channel alter column answeronpolarityswitch set not null;

alter table zap_channel add column hanguponpolarityswitch varchar(3);
alter table zap_channel alter column hanguponpolarityswitch set default 'yes';
update zap_channel set hanguponpolarityswitch = 'yes' where hanguponpolarityswitch is null;
alter table zap_channel alter column hanguponpolarityswitch set not null;

COMMIT;

