makima/migrations/20260202000000_remove_red_team_system.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

-- Remove red team system
-- This migration drops all red team related tables, columns, and indexes

-- Drop red team notifications table
DROP TABLE IF EXISTS red_team_notifications;

-- Drop red team index on tasks
DROP INDEX IF EXISTS idx_tasks_contract_red_team;

-- Remove red team column from tasks
ALTER TABLE tasks DROP COLUMN IF EXISTS is_red_team;

-- Remove red team columns from contracts
ALTER TABLE contracts DROP COLUMN IF EXISTS red_team_enabled;
ALTER TABLE contracts DROP COLUMN IF EXISTS red_team_prompt;