executions.sql

DROP TABLE IF EXISTS executions;
CREATE TABLE executions (
    tx_index     INTEGER UNSIGNED,
    -- tx_hash   TEXT,
    tx_hash_id   INTEGER UNSIGNED, -- id of record in index_transactions
    block_index  INTEGER,
    -- source    TEXT,
    source_id    INTEGER UNSIGNED, -- id of record in index_addresses
    contract_id  INTEGER UNSIGNED, -- id of record in index_contracts
    gas_price    BIGINT,
    gas_start    BIGINT,
    gas_cost     BIGINT,
    gas_remained BIGINT,
    value        BIGINT,
    data         BLOB,
    output       BLOB,
    status       TEXT
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE UNIQUE INDEX tx_index    ON executions (tx_index);
CREATE        INDEX block_index ON executions (block_index);
CREATE        INDEX source_id   ON executions (source_id);
CREATE        INDEX tx_hash_id  ON executions (tx_hash_id);
CREATE        INDEX contract_id ON executions (contract_id);