Add ATX ID or Node Id to rewards table

[brunovale91]

Add ATX id to rewards table to make it easier to identity which rewards belong to which ATX.

// AnyReward contains the reward information by ATXID.
type AnyReward struct {
	AtxID  ATXID
	Weight RatNum
}

type CoinbaseReward struct {
	Coinbase Address
	Weight   RatNum
}

func (e *Executor) convertRewards(rewards []types.AnyReward) ([]types.CoinbaseReward, error) {
	res := make([]types.CoinbaseReward, 0, len(rewards))
	for _, r := range rewards {
		atx, err := e.cdb.GetAtxHeader(r.AtxID)
		if err != nil {
			return nil, fmt.Errorf("exec convert rewards: %w", err)
		}
		res = append(res, types.CoinbaseReward{
			Coinbase: atx.Coinbase,
			Weight:   r.Weight,
		})
	}
	sort.Slice(res, func(i, j int) bool {
		return bytes.Compare(res[i].Coinbase.Bytes(), res[j].Coinbase.Bytes()) < 0
	})
	return res, nil
}

Any reward gets converted to CoinbaseReward in convertRewards.

Atx ID can be added to CoinbaseRewards and then saved in the rewards table.

/ Add reward to the database.
func Add(db sql.Executor, reward *types.Reward) error {
	if _, err := db.Exec(`
		insert into rewards (coinbase, layer, total_reward, layer_reward) values (?1, ?2, ?3, ?4)
		on conflict(coinbase, layer)
			do update set
				total_reward=add_uint64(total_reward, ?3),
				layer_reward=add_uint64(layer_reward, ?4);`,
		func(stmt *sql.Statement) {
			stmt.BindBytes(1, reward.Coinbase[:])
			stmt.BindInt64(2, int64(reward.Layer.Uint32()))
			stmt.BindInt64(3, int64(reward.TotalReward))
			stmt.BindInt64(4, int64(reward.LayerReward))
		}, nil); err != nil {
		return fmt.Errorf("insert %+x: %w", reward, err)
	}
	return nil
}