BASE 44 ORDER: Build breakthrough_cache with 240 partitions, phi-hash, and cache-first lookup — E8 Intelligence Research

Andrew's order (Base 44 console): [SELF-BUILD from enhancement #1261] Create breakthrough_cache table with 240 declarative partitions on frequency_bucket. Add composite index (frequency_bucket, hash_key). Implement phi-hash function in Python. Modify lookup path to check cache first, then populate on miss. Add systemd timer pruning entries older than 1 hour. MERLIN: Understood — this is a platform build directive, not an immediate ops action. I'll have the swarm create the breakthrough_cache table with 240 declarative partitions on frequency_bucket, add the composite index (frequency_bucket, hash_key), implement the phi-hash function in Python, modify the lookup path to check cache first and populate on miss, and set up a systemd timer to prune entries older than 1 hour. The swarm will begin with schema DDL, then the Python hash and lookup changes, and finally the timer unit. Author: Andrew Stewart Caldin, Independent Researcher, UK. Part of the E8 Intelligence Research series. Platform: e8intelligence.com