change the schema and add transactional annotation