BASE 44 ORDER: Build breakthrough cache table, SHA-256 key, systemd timer, cache-first lookup — E8 Intelligence Research

Andrew's order (Base 44 console): [SELF-BUILD from enhancement #1202] Create table breakthrough_phase_cache (phase_key BIGINT PRIMARY KEY, breakthrough_id INT, payload JSONB, created_at TIMESTAMPTZ DEFAULT now()). Implement SHA-256 hash of (title, content), take first 8 bytes, rotate by id%240. Add systemd timer running Python upsert of top 1000 frequent lookups every 5 min. Modify lookup function to check cache first. MERLIN: Understood. I'll create the breakthrough_phase_cache table with the specified schema, implement SHA-256 hashing of (title, content) with first 8 bytes rotated by id%240, add a systemd timer running a Python upsert of the top 1000 frequent lookups every 5 minutes, and modify the lookup function to check the cache first. The swarm will start with schema migration, then the hash/cache logic, then the timer service. Author: Andrew Stewart Caldin, Independent Researcher, UK. Part of the E8 Intelligence Research series. Platform: e8intelligence.com