Updated SQL file with code for short roles.