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

     1  CREATE TABLE nodes (
     2    id             string          NOT NULL,  
     3    message_id     string          NOT NULL,
     4    owner          string          NOT NULL,
     5    name           string          NOT NULL,
     6    description    string          NOT NULL,
     7    dx_peer        string,
     8    dx_endpoint    blob,
     9    created        int64           NOT NULL
    10  );
    11  
    12  CREATE UNIQUE INDEX nodes_id ON nodes(id);
    13  CREATE UNIQUE INDEX nodes_owner ON nodes(owner,name);
    14  CREATE UNIQUE INDEX nodes_peer ON nodes(dx_peer);