Upgrade v11 — intelligence layer

Adds the tables that make per-entity profiles possible, and the indexes that make them fast. The indexes are the fix for the thin dashboards: indicators.asn and indicators.country_code exist today but are unindexed, so every ASN or country view is a full scan of the whole table.

Tables

Indexes

Each runs as its own request. On a 29M-row table one index can take minutes; doing them in a single request is how you get a 524 and a half-built schema.

Build indexes