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

     1  CREATE TABLE groups (
     2    message_id     string,
     3    name           string          NOT NULL,
     4    namespace      string          NOT NULL,
     5    ledger         string,
     6    hash           string          NOT NULL,
     7    created        int64           NOT NULL
     8  );
     9  
    10  CREATE UNIQUE INDEX groups_hash ON groups(namespace,ledger,hash);