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