include more auditing in schema update and refactor to better allow transaction suppo...