1-- Add prefix deduplication columns to llm_requests table
2-- This allows storing only the suffix of request_body when there's a shared prefix
3-- with a previous request in the same conversation.
4
5ALTER TABLE llm_requests ADD COLUMN prefix_request_id INTEGER REFERENCES llm_requests(id);
6ALTER TABLE llm_requests ADD COLUMN prefix_length INTEGER;
7
8-- Index for efficient prefix lookups
9CREATE INDEX idx_llm_requests_prefix_request_id ON llm_requests(prefix_request_id) WHERE prefix_request_id IS NOT NULL;