add `Projections` to order by block number & date

[DenisCarriere]

https://clickhouse.com/docs/en/sql-reference/statements/alter/projection

ALTER TABLE transactions ADD PROJECTION transactions_block_projection (
SELECT
*
ORDER BY block_number, block_date
)

ALTER TABLE transactions MATERIALIZE PROJECTION transactions_block_projection

[fschoell]

No need to add it afterwards, we can include this in the create table statement. See docs (at least for chains that are not synced yet)

[DenisCarriere]

Oh nice! can simply add PROJECTION 🔥 i'll update that