1 will set the post to visible. The problem with doing it directly in the database like that is that the count for the visible/non-visible posts in the thread table will be off and that will cause problems with pagination. You, as an admin, should be able to view deleted posts in your User CP > Moderation > Deleted Items > Posts and then make them visible there.