BEGIN;

alter table messaging_translate add column dialnum varchar(15);
update messaging_translate set dialnum = '' where dialnum IS NULL;
alter table messaging_translate alter column dialnum set NOT NULL;
alter table messaging_translate alter column dialnum set default '';

COMMIT;

