-- 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;