BEGIN;
alter table building add column alarmprefix varchar(15);
update building set alarmprefix = '' where alarmprefix is NULL;
alter table building alter column alarmprefix set default '';
alter table building alter column alarmprefix set NOT NULL;
COMMIT;

