-- Backfill checkpoints table for tracking backfill progress

CREATE TABLE IF NOT EXISTS backfill_checkpoints (
    chain_id INTEGER NOT NULL,
    last_block BIGINT NOT NULL,
    updated_at TIMESTAMP DEFAULT NOW(),
    PRIMARY KEY (chain_id)
);