SET NAMES utf8mb4;

ALTER TABLE system_incidents ADD COLUMN IF NOT EXISTS dedupe_key VARCHAR(190) NULL;
ALTER TABLE system_incidents ADD COLUMN IF NOT EXISTS occurrences INT UNSIGNED NOT NULL DEFAULT 1;
ALTER TABLE system_incidents ADD COLUMN IF NOT EXISTS last_seen_at DATETIME NULL;
ALTER TABLE system_incidents ADD COLUMN IF NOT EXISTS acknowledged_by_user_id BIGINT UNSIGNED NULL;
ALTER TABLE system_incidents ADD COLUMN IF NOT EXISTS acknowledged_at DATETIME NULL;
ALTER TABLE system_incidents ADD COLUMN IF NOT EXISTS resolved_by_user_id BIGINT UNSIGNED NULL;
ALTER TABLE system_incidents ADD COLUMN IF NOT EXISTS resolution_note TEXT NULL;

ALTER TABLE system_incidents MODIFY COLUMN status ENUM('open','acknowledged','resolved') NOT NULL DEFAULT 'open';

CREATE UNIQUE INDEX IF NOT EXISTS uq_incident_open_key
ON system_incidents(workspace_id,dedupe_key,status);
