Skip to content

Open-source platform for 3D AI agents. Turn text or a photo into a rigged, animated GLB avatar, give it an LLM brain, memory and a wallet, and embed it anywhere with one web component. Remote MCP server, x402 payments, Three.js, browser-native.

613 B
Raw Blame
-- spec: permissions/0.1  task: 19-indexer-cron
-- indexer_state — cursor table for the delegation event indexer cron.
-- Keyed by (contract, chain_id). last_indexed_block advances after each
-- successfully processed batch so a timeout preserves partial progress.
-- Idempotent: safe to re-run.

CREATE TABLE IF NOT EXISTS indexer_state (
    id                  SERIAL PRIMARY KEY,
    contract            TEXT NOT NULL,
    chain_id            INTEGER NOT NULL,
    last_indexed_block  BIGINT NOT NULL DEFAULT 0,
    updated_at          TIMESTAMPTZ NOT NULL DEFAULT NOW(),
    UNIQUE (contract, chain_id)
);