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

Go to download

Show more of this group Show more artifacts with this name
Show all versions of yaci-store-transaction Show documentation

Yaci Store Transaction Module

The newest version!

CREATE INDEX idx_transaction_block
    ON transaction(block);

CREATE INDEX idx_transaction_block_hash
    ON transaction(block_hash);


-- transaction_witness

CREATE INDEX idx_transaction_witness_tx_hash
    ON transaction_witness(tx_hash);

-- withdrawal
CREATE INDEX idx_withdrawal_address
    ON withdrawal(address);

CREATE INDEX idx_withdrawal_tx_hash
    ON withdrawal(tx_hash);