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

Go to download

drop table if exists transaction_metadata;
create table transaction_metadata
(
    id                    uuid not null primary key,
    slot                  bigint,
    tx_hash               varchar(64) not null,
    label                 varchar(255),
    body                  clob,
    cbor                  clob,
    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);