12 lines
407 B
SQL
12 lines
407 B
SQL
-- 036: Indexed blockchain blocks (chain-indexer)
|
|
CREATE TABLE IF NOT EXISTS blocks (
|
|
height BIGINT PRIMARY KEY,
|
|
hash VARCHAR(128) NOT NULL UNIQUE,
|
|
tx_count INT NOT NULL DEFAULT 0,
|
|
indexed_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
|
|
created_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
|
|
);
|
|
|
|
CREATE INDEX idx_blocks_hash ON blocks(hash);
|
|
CREATE INDEX idx_blocks_created_at ON blocks(created_at DESC);
|