updates delete statements to be less destructive