use util.generate_id in client
fix usage of datetime.utcnow in defaults
generate_id uses a single uuid
add roles to user details
add created_by and deactivated_by fields to client
add scope table