blocks.sql

DROP TABLE IF EXISTS blocks;
CREATE TABLE blocks (
    block_index            INTEGER UNSIGNED PRIMARY KEY,
    block_time             INTEGER UNSIGNED,
    -- block_hash          TEXT,
    block_hash_id          INTEGER UNSIGNED,     -- id of record in index_transactions table
    -- previous_block_hash TEXT,
    previous_block_hash_id INTEGER UNSIGNED,     -- id of record in index_transactions table
    -- ledger_hash         TEXT,
    ledger_hash_id         INTEGER UNSIGNED,     -- id of record in index_transactions table
    -- txlist_hash         TEXT,
    txlist_hash_id         INTEGER UNSIGNED,     -- id of record in index_transactions table
    -- messages_hash       TEXT,
    messages_hash_id       INTEGER UNSIGNED,     -- id of record in index_transactions table
    difficulty             FLOAT,
    transaction_count      INTEGER UNSIGNED     -- id of record in index_transactions table
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE INDEX block_hash_id ON blocks (block_hash_id);