update role usage
test removing utf8 pragma
remove utf8 keygen method