search

bro-n-bro / spacebox

MIT License
35 stars 4 forks source link

Create table and writer view spacebox.redelegation_message #48

Closed bro-n-bro-0 closed 1 month ago

bro-n-bro-0 commented 4 months ago 
CREATE TABLE IF NOT EXISTS spacebox.redelegation_message
(
    `delegator_address`     String,
    `src_validator_address` String,
    `dst_validator_address` String,
    `coin`                  String,
    `height`                Int64,
    `completion_time`       DateTime,
    `tx_hash`               String,
    `timestamp`      DateTime
) ENGINE = MergeTree()
      ORDER BY (`delegator_address`, `src_validator_address`, `dst_validator_address`, `height`, `completion_time`, `tx_hash`, `timestamp`);

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