CREATE TABLE fitment_overrides (
  id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  product_id BIGINT UNSIGNED NOT NULL,
  year SMALLINT NOT NULL,
  make VARCHAR(100) NOT NULL,
  model VARCHAR(100) NOT NULL,
  submodel VARCHAR(100) DEFAULT NULL,

  override_action ENUM('ALLOW','BLOCK','FORCE_CONFIDENCE') NOT NULL,
  override_confidence DECIMAL(4,3) DEFAULT NULL,
  reason VARCHAR(255) NOT NULL,

  created_by VARCHAR(100) NOT NULL,
  created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,

  UNIQUE KEY uniq_override_vehicle (
    product_id, year, make, model, submodel
  )
);
