-- Key ownership verification. SSH keys verify automatically on first successful
-- SSH authentication; GPG keys verify by signing a challenge. Existing keys
-- predate this and are trusted.
ALTER TABLE keys ADD COLUMN verified_at BIGINT;
UPDATE keys SET verified_at = created_at;