-- Pixmenia v19 persistent assets optional settings
CREATE TABLE IF NOT EXISTS asset_repair_logs (
  id INT AUTO_INCREMENT PRIMARY KEY,
  checked_count INT NOT NULL DEFAULT 0,
  fixed_count INT NOT NULL DEFAULT 0,
  missing_count INT NOT NULL DEFAULT 0,
  report_json LONGTEXT NULL,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Settings insert skipped in v23 to preserve live admin settings.