BEGIN;

alter table phonetype add column oper_mode varchar(12);
update phonetype set oper_mode = '' where oper_mode IS NULL;
alter table phonetype alter column oper_mode set NOT NULL;
alter table phonetype alter column oper_mode set default '';

alter table phonetype add column oper_status varchar(12);
update phonetype set oper_status = '' where oper_status IS NULL;
alter table phonetype alter column oper_status set NOT NULL;
alter table phonetype alter column oper_status set default '';

COMMIT;
