Comment by codexon

"you could easily not switch to a CASCADE, but instead set delete=1 and mark every sensitive field with a special value"