BASE 44 ORDER: Build e8_root_resonance_cache table with xxhash rolling hash mod 240 and 1-hour prune timer — E8 Intelligence Research

Andrew's order (Base 44 console): [SELF-BUILD from enhancement #1093] Create `e8_root_resonance_cache` table with hash/bucket columns. Implement xxhash rolling hash mod 240 on insert. Add bucket-indexed cache check before full scan. Set systemd timer for 1-hour prune. MERLIN: Understood. I will create the `e8_root_resonance_cache` table with hash and bucket columns, implement an xxhash rolling hash mod 240 on insert, add a bucket-indexed cache check before full scans, and set a systemd timer for a 1-hour prune. The swarm will begin building and deploying this immediately. Author: Andrew Stewart Caldin, Independent Researcher, UK. Part of the E8 Intelligence Research series. Platform: e8intelligence.com