1 -- Delete the empty public keys
2 delete from community where public_key is null;
3 delete from person where public_key is null;
6 alter table community alter column public_key set not null;
7 alter table person alter column public_key set not null;