github.com/kaleido-io/firefly@v0.0.0-20210622132723-8b4b6aacb971/db/migrations/postgres/000019_create_nextpins_table.up.sql (about)

     1  BEGIN;
     2  CREATE TABLE nextpins (
     3    seq            SERIAL          PRIMARY KEY,
     4    context        CHAR(64)        NOT NULL,
     5    identity       VARCHAR(1024)   NOT NULL,
     6    hash           CHAR(64)        NOT NULL,
     7    nonce          BIGINT          NOT NULL
     8  );
     9  
    10  CREATE INDEX nextpins_hash ON nextpins(hash);
    11  
    12  COMMIT;