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

     1  BEGIN;
     2  CREATE TABLE members (
     3    seq            SERIAL          PRIMARY KEY,
     4    group_hash     CHAR(64)        NOT NULL,
     5    idx            INT             NOT NULL,
     6    identity       VARCHAR(1024)   NOT NULL,
     7    node_id        UUID            NOT NULL
     8  );
     9  
    10  CREATE INDEX members_group ON members(group_hash);
    11  
    12  COMMIT;