bro-n-bro / spacebox

MIT License
35 stars 4 forks source link

Create table and writer view spacebox. create_validator_message #50

Closed bro-n-bro-0 closed 2 months ago

bro-n-bro-0 commented 4 months ago
CREATE TABLE IF NOT EXISTS spacebox.create_validator_message
(
    `timestamp` DateTime
    `height`              Int64,
    `tx_hash`             String,
    `delegator_address`   String,
    `validator_address`   String,
    `description`         String,
    `commission`    Float64,
    `min_self_delegation` Int64,
    `pubkey`              String
) ENGINE = MergeTree()
      ORDER BY (`timestamp`, `height`,  `tx_hash`, `delegator_address`, `validator_address`, `commission_rates` );

https://docs.cosmos.network/v0.46/modules/staking/07_events.html#msgcreatevalidator