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

     1  CREATE TABLE orgs (
     2    id             string            NOT NULL,  
     3    message_id     string            NOT NULL,
     4    name           string            NOT NULL,
     5    parent         string,
     6    identity       string            NOT NULL,
     7    description    string            NOT NULL,
     8    profile        blob,
     9    created        int64             NOT NULL
    10  );
    11  
    12  CREATE UNIQUE INDEX orgs_id ON orgs(id);
    13  CREATE UNIQUE INDEX orgs_identity ON orgs(identity);
    14  CREATE UNIQUE INDEX orgs_name ON orgs(name);