-- LLM alias expansion audit log (stores raw responses per make)
CREATE TABLE IF NOT EXISTS vehicle_make_alias_llm (
  id INT AUTO_INCREMENT PRIMARY KEY,
  make_id INT NOT NULL,
  make_name VARCHAR(100) NOT NULL,
  raw_response JSON,
  inserted_count INT DEFAULT 0,
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  INDEX idx_make_id (make_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
