CREATE TABLE domain_resolve_cache (
    fqdn         TEXT PRIMARY KEY,
    addrs_json   TEXT NOT NULL DEFAULT '[]',
    resolved_at  TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ', 'now'))
);

CREATE INDEX idx_domain_resolve_cache_resolved ON domain_resolve_cache (resolved_at);
