4 steps to delete account in Gerrit DB

4 steps to delete account in DB.

Delete from accounts where preferred_email=’’;

delete from account_ssh_keys where account_id='';

delete from account_external_ids where external_id='gerrit:*’;

delete from account_external_ids where external_id='username:*’;

whatever it was in H2 database and postgres db .

H2:

ssh -p 24198 localhost gerrit gsql

Postgres:
psql