BEGIN;
alter table contacttype add column clidpattern varchar(24);
update contacttype set clidpattern = '' where clidpattern IS NULL;
alter table contacttype alter column clidpattern set default '';
alter table contacttype alter column clidpattern set not null;
COMMIT;

