My web development experience is quite old, but...

Shouldn't you also store a motivation why the post was removed?

You might want to add support for multiple languages -- so don't store hard wired strings into the database without a good reason.