debits.sql

DROP TABLE IF EXISTS debits;
CREATE TABLE debits (
    tx_index         INTEGER UNSIGNED,
    block_index      INTEGER UNSIGNED,
    -- address       TEXT,
    address_id       INTEGER UNSIGNED, -- id of record in index_addresses
    -- asset         TEXT,
    asset_id         INTEGER UNSIGNED, -- id of record in assets table
    quantity         BIGINT,
    action           TEXT,
    -- event         TEXT,
    event_id         INTEGER UNSIGNED,  -- id of record in index_transactions
    -- utxo          TEXT,
    utxo_id          INTEGER UNSIGNED,  -- id of record in index_transactions
    utxo_output      INTEGER UNSIGNED,  -- utxo output index
    -- utxo_address  TEXT,
    utxo_address_id  INTEGER UNSIGNED   -- id of record in index_addresses
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE INDEX tx_index        ON debits (tx_index);
CREATE INDEX block_index     ON debits (block_index);
CREATE INDEX address_id      ON debits (address_id);
CREATE INDEX asset_id        ON debits (asset_id);
CREATE INDEX event_id        ON debits (event_id);
CREATE INDEX utxo_id         ON debits (utxo_id);
CREATE INDEX utxo_address_id ON debits (utxo_address_id);