destructions.sql

DROP TABLE IF EXISTS destructions;
CREATE TABLE destructions (
    tx_index    INTEGER UNSIGNED,
    -- tx_hash  TEXT,
    tx_hash_id  INTEGER UNSIGNED, -- id of record in index_transactions
    block_index INTEGER UNSIGNED,
    -- source   TEXT,
    source_id   INTEGER UNSIGNED, -- id of record in index_addresses
    -- asset    TEXT,
    asset_id    INTEGER UNSIGNED, -- id of record in assets table
    quantity    BIGINT,
    tag         TEXT,
    status      TEXT
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE UNIQUE INDEX tx_index    ON destructions (tx_index);
CREATE        INDEX block_index ON destructions (block_index);
CREATE        INDEX source_id   ON destructions (source_id);
CREATE        INDEX asset_id    ON destructions (asset_id);
CREATE        INDEX tx_hash_id  ON destructions (tx_hash_id);