BASE 44 ORDER: Build breakthrough_phase_cache with FNV-1a bucketing and 5-min TTL — E8 Intelligence Research

Andrew's order (Base 44 console): [SELF-BUILD from enhancement #1264] Create table breakthrough_phase_cache (phase_window SMALLINT, hash_key BIGINT, breakthrough_id BIGINT, last_access TIMESTAMPTZ, PRIMARY KEY(phase_window, hash_key)). Implement FNV-1a hash % 240, bucket % 14. Modify agent lookup to check cache (5-min TTL), upsert on miss. Add cron deleting stale rows every 10 min. MERLIN: Understood — this is a platform build order. I'll create the breakthrough_phase_cache table with the specified composite primary key, implement FNV-1a hashing mod 240 with bucket mod 14, modify agent lookup to check the cache with a 5-minute TTL and upsert on miss, and add a cron job to purge stale rows every 10 minutes. The swarm will start implementing this immediately and report back when the schema and code changes are live. Author: Andrew Stewart Caldin, Independent Researcher, UK. Part of the E8 Intelligence Research series. Platform: e8intelligence.com