-- Create / terminate run by cron instead of the web request, for panels that restart the web server or PHP-FPM
-- billing itself runs on (CWP on the same server adds a PHP-FPM pool per account and restarts PHP-FPM).
ALTER TABLE servers ADD run_from_cron TINYINT(1) NOT NULL DEFAULT 0 COMMENT '1 = create/terminate always from cron' AFTER verify_ssl;

CREATE TABLE module_jobs (
  id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
  service_id INT UNSIGNED NOT NULL,
  action VARCHAR(32) NOT NULL,
  admin_id INT UNSIGNED NULL,
  opt TEXT NULL COMMENT 'JSON, without passwords',
  created_at DATETIME NOT NULL,
  started_at DATETIME NULL,
  done_at DATETIME NULL,
  ok TINYINT(1) NULL,
  message VARCHAR(1000) NOT NULL DEFAULT '',
  KEY pending (done_at, id),
  KEY service (service_id, id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;