We are going to create a subversion post-commit hook to work with project tools and will share it.

We just need to know the actions that should happen in the DB. Does the status column only need to be changed or other areas updated?

The same goes for adding a comment to an existing issue.