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

     1  BEGIN;
     2  CREATE TABLE nonces (
     3    seq            SERIAL          PRIMARY KEY,
     4    context        CHAR(64)        NOT NULL,
     5    nonce          BIGINT          NOT NULL,
     6    group_hash     CHAR(64)        NOT NULL,
     7    topic          VARCHAR(64)     NOT NULL
     8  );
     9  
    10  CREATE INDEX nonces_context ON nonces(context);
    11  CREATE INDEX nonces_group ON nonces(group_hash);
    12  
    13  COMMIT;