BEGIN;
alter table department add column out_prepend varchar(15);
update department set out_prepend = '' where out_prepend is null;
alter table department alter column out_prepend set default '';
alter table department alter column out_prepend set not null;

alter table contact add column out_prepend varchar(15);
update contact set out_prepend = '' where out_prepend is null;
alter table contact alter column out_prepend set default '';
alter table contact alter column out_prepend set not null;

alter table phoneline add column out_prepend varchar(15);
update phoneline set out_prepend = '' where out_prepend is null;
alter table phoneline alter column out_prepend set default '';
alter table phoneline alter column out_prepend set not null;
COMMIT;

