option column for flagging deletes allowing unique keys to work properly

Maybe extract this to method to avoid duplicating it and chunk if inside something like
```
def update_paranoia_flag_column
  if paranoia_flag_column
    # do update column
```