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

     1  BEGIN;
     2  CREATE TABLE groups (
     3    seq            SERIAL          PRIMARY KEY,
     4    message_id     UUID,
     5    name           VARCHAR(64)     NOT NULL,
     6    namespace      VARCHAR(64)     NOT NULL,
     7    ledger         UUID,
     8    hash           CHAR(64)        NOT NULL,
     9    created        BIGINT          NOT NULL
    10  );
    11  
    12  CREATE UNIQUE INDEX groups_hash ON groups(hash);
    13  
    14  COMMIT;