contracts.sql

DROP TABLE IF EXISTS contracts;
CREATE TABLE contracts (
    contract_id INTEGER UNSIGNED, -- id of record in index_contracts
    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
    code        BLOB,
    nonce       INTEGER UNSIGNED
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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