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

     1  CREATE TABLE messages (
     2    id          string  NOT NULL,
     3    cid         string,
     4    mtype       string  NOT NULL,
     5    author      string  NOT NULL,
     6    created     int64   NOT NULL,
     7    namespace   string  NOT NULL,
     8    topics      string  NOT NULL,
     9    tag         string  NOT NULL,
    10    group_hash  string,
    11    datahash    string  NOT NULL,
    12    hash        string  NOT NULL,
    13    pins        string  NOT NULL,
    14    confirmed   int64,
    15    tx_type     string  NOT NULL,
    16    local       bool    NOT NULL,
    17    batch_id    string
    18  );
    19  
    20  CREATE UNIQUE INDEX messages_primary ON messages(id);
    21  CREATE INDEX messages_created ON messages(created);