-- LLM review table for vehicle make candidates (review-only, no auto-promotion)
-- Schema per LLM governance layer spec
CREATE TABLE IF NOT EXISTS vehicle_make_llm_review (
  id INT AUTO_INCREMENT PRIMARY KEY,
  candidate_make VARCHAR(100) NOT NULL,
  occurrences INT NOT NULL,
  is_valid_oem TINYINT NOT NULL,
  category VARCHAR(50) NOT NULL,
  confidence INT NOT NULL,
  raw_response JSON,
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  INDEX idx_candidate (candidate_make)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
