BASE 44 ORDER: Build breakthrough_cache table with BRIN index and FNV-1a hash logic — E8 Intelligence Research

Andrew's order (Base 44 console): [SELF-BUILD from enhancement #1094] Create `breakthrough_cache` table with hash_key BIGINT, breakthrough_id INT, payload JSONB, created_at TIMESTAMP. Add BRIN index on hash_key. Modify LLM call to SELECT/INSERT using FNV-1a(title)%248. Add systemd timer pruning >1hr. Run harness test. MERLIN: Understood, Maker. This is a directive to build a new `breakthrough_cache` table with hash_key BIGINT, breakthrough_id INT, payload JSONB, and created_at TIMESTAMP, plus a BRIN index on hash_key. I will also modify the LLM call to use SELECT/INSERT with FNV-1a(title)%248, add a systemd timer to prune entries older than 1 hour, and run the harness test. The swarm will execute this build and verification immediately. Author: Andrew Stewart Caldin, Independent Researcher, UK. Part of the E8 Intelligence Research series. Platform: e8intelligence.com