fixed rollback in some repository classes, updated schema