added index on players.charid