SET NAMES utf8mb4;

ALTER TABLE system_test_runs ADD COLUMN IF NOT EXISTS duration_ms INT NULL;
ALTER TABLE system_test_runs ADD COLUMN IF NOT EXISTS triggered_by_user_id BIGINT UNSIGNED NULL;

CREATE TABLE IF NOT EXISTS system_incidents (
  id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  workspace_id BIGINT UNSIGNED NOT NULL,
  source VARCHAR(100) NOT NULL,
  severity ENUM('info','warning','error','critical') NOT NULL DEFAULT 'warning',
  title VARCHAR(190) NOT NULL,
  details TEXT NULL,
  status ENUM('open','resolved') NOT NULL DEFAULT 'open',
  opened_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  resolved_at DATETIME NULL,
  INDEX idx_incident_workspace_status(workspace_id,status,opened_at),
  CONSTRAINT fk_incident_workspace FOREIGN KEY(workspace_id) REFERENCES workspaces(id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
