BASE 44 ORDER: Build breakthrough_cache table with FNV-1a hash and daily prune — E8 Intelligence Research

Andrew's order (Base 44 console): [SELF-BUILD from enhancement #1278] Create breakthrough_cache table with hash_key BIGINT UNIQUE, payload JSONB, created_at. Implement FNV-1a 64-bit hash on normalized title+content, modulo 240. Add Python cache check before LLM, store after. Add composite index (hash_key, created_at). Schedule daily prune older than 7 days. MERLIN: Understood. I will create the breakthrough_cache table with hash_key BIGINT UNIQUE, payload JSONB, and created_at, then implement FNV-1a 64-bit hashing on normalized title+content modulo 240. The swarm will add a Python cache check before any LLM call, store results after, and add the composite index (hash_key, created_at). Finally, we will schedule a daily prune to remove entries older than 7 days. Author: Andrew Stewart Caldin, Independent Researcher, UK. Part of the E8 Intelligence Research series. Platform: e8intelligence.com