db.store.mysql.V0_600_1__init.sql Maven / Gradle / Ivy

Go to download

drop table if exists transaction_metadata;
create table transaction_metadata
(
    id                    binary(16) not null primary key,
    slot                  bigint,
    tx_hash               varchar(64) not null,
    label                 varchar(255),
    body                  longtext,
    cbor                  longtext,
    block                 bigint,
    block_time            bigint,
    update_datetime       timestamp
);

CREATE INDEX idx_txn_metadata_tx_hash
    ON transaction_metadata(tx_hash);

CREATE INDEX idx_txn_metadata_label
    ON transaction_metadata(label);