ALTER TABLE autopilot
ADD COLUMN IF NOT EXISTS project_id UUID REFERENCES project(id) ON DELETE SET NULL;
CREATE INDEX IF NOT EXISTS idx_autopilot_project ON autopilot(project_id);