db.store.postgresql.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                  text,
    cbor                  text,
    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);