gistfile1.txt

CREATE TABLE 
    blocks 
    ( 
        chainid      BIGINT NOT NULL, 
        creationtime TIMESTAMP(6) WITH TIME ZONE NOT NULL, 
        epoch        TIMESTAMP(6) WITH TIME ZONE NOT NULL, 
        flags        NUMERIC(20,0) NOT NULL, 
        hash         CHARACTER VARYING NOT NULL, 
        height       BIGINT NOT NULL, 
        miner        CHARACTER VARYING NOT NULL, 
        nonce        NUMERIC(20,0) NOT NULL, 
        parent       CHARACTER VARYING NOT NULL, 
        payload      CHARACTER VARYING NOT NULL, 
        powhash      CHARACTER VARYING NOT NULL, 
        predicate    CHARACTER VARYING NOT NULL, 
        target       NUMERIC(80,0) NOT NULL, 
        weight       NUMERIC(80,0) NOT NULL, 
        PRIMARY KEY (hash) 
    );

CREATE TABLE 
    events 
    ( 
        block      CHARACTER VARYING NOT NULL, 
        chainid    BIGINT NOT NULL, 
        height     BIGINT NOT NULL, 
        idx        BIGINT NOT NULL, 
        module     CHARACTER VARYING NOT NULL, 
        modulehash CHARACTER VARYING NOT NULL, 
        NAME       CHARACTER VARYING NOT NULL, 
        params JSONB NOT NULL, 
        paramtext  CHARACTER VARYING NOT NULL, 
        qualname   CHARACTER VARYING NOT NULL, 
        requestkey CHARACTER VARYING NOT NULL, 
        PRIMARY KEY (block, idx, requestkey), 
        CONSTRAINT events_block_fkey FOREIGN KEY (block) REFERENCES "blocks" ("hash") 
    );

CREATE TABLE 
    minerkeys 
    ( 
        block CHARACTER VARYING NOT NULL, 
        KEY   CHARACTER VARYING NOT NULL, 
        PRIMARY KEY (block, KEY), 
        CONSTRAINT minerkeys_block_fkey FOREIGN KEY (block) REFERENCES "blocks" ("hash") 
    );

CREATE TABLE 
    signers 
    ( 
        addr CHARACTER VARYING, 
        caps JSONB NOT NULL, 
        idx        INTEGER NOT NULL, 
        pubkey     CHARACTER VARYING NOT NULL, 
        requestkey CHARACTER VARYING NOT NULL, 
        scheme     CHARACTER VARYING, 
        sig        CHARACTER VARYING NOT NULL, 
        PRIMARY KEY (idx, requestkey) 
    );

CREATE TABLE 
    transactions 
    ( 
        badresult JSONB, 
        block   CHARACTER VARYING NOT NULL, 
        chainid BIGINT NOT NULL, 
        code    CHARACTER VARYING, 
        continuation JSONB, 
        creationtime TIMESTAMP(6) WITH TIME ZONE NOT NULL, 
        data JSONB, 
        gas      BIGINT NOT NULL, 
        gaslimit BIGINT NOT NULL, 
        gasprice DOUBLE PRECISION NOT NULL, 
        goodresult JSONB, 
        height BIGINT NOT NULL, 
        logs   CHARACTER VARYING, 
        metadata JSONB, 
        nonce      CHARACTER VARYING NOT NULL, 
        num_events BIGINT, 
        pactid     CHARACTER VARYING, 
        proof      CHARACTER VARYING, 
        requestkey CHARACTER VARYING NOT NULL, 
        ROLLBACK   BOOLEAN, 
        sender     CHARACTER VARYING NOT NULL, 
        step       BIGINT, 
        ttl        BIGINT NOT NULL, 
        txid       BIGINT, 
        PRIMARY KEY (block, requestkey), 
        CONSTRAINT transactions_block_fkey FOREIGN KEY (block) REFERENCES "blocks" ("hash") 
    );