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