makima/migrations/20260126010001_add_red_team_to_tasks.sql


1
2
3
4
5
6
7
8
9

-- Add red team flag to tasks
ALTER TABLE tasks
ADD COLUMN is_red_team BOOLEAN NOT NULL DEFAULT FALSE;

-- Index for efficient red team task lookup per contract
CREATE INDEX idx_tasks_contract_red_team ON tasks(contract_id, is_red_team)
WHERE is_red_team = TRUE;

COMMENT ON COLUMN tasks.is_red_team IS 'Whether this is a red team monitoring task';