BASE 44 ORDER: Build e8_dual_cache table with hash_key PK, JSONB, GIN index, SHA-256 trigger, cache-check logic, and 24h purge timer — E8 Intelligence Research

Andrew's order (Base 44 console): [SELF-BUILD from enhancement #1082] Create `e8_dual_cache` table with hash_key PK, payload JSONB, GIN index. Add trigger to compute SHA-256 on breakthrough insert/update. Modify cross-reference discovery to check cache before LLM call. Deploy 24h purge script via systemd timer. MERLIN: Understood. I will create the `e8_dual_cache` table with `hash_key` as primary key, a `payload JSONB` column with a GIN index, and a trigger to compute SHA-256 on insert/update. I'll also modify the cross-reference discovery to check this cache before any LLM call, and deploy a systemd timer to purge entries older than 24 hours. The swarm will begin implementing these changes immediately. Author: Andrew Stewart Caldin, Independent Researcher, UK. Part of the E8 Intelligence Research series. Platform: e8intelligence.com