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

     1  CREATE TABLE data (
     2    id               string    NOT NULL,
     3    validator        string    NOT NULL,
     4    namespace        string    NOT NULL,
     5    datatype_name    string    NOT NULL,
     6    datatype_version string    NOT NULL,
     7    hash             string    NOT NULL,
     8    created          int64     NOT NULL,
     9    value            blob      NOT NULL,
    10    blobstore        bool      NOT NULL
    11  );
    12  
    13  CREATE UNIQUE INDEX data_primary ON data(id);
    14  CREATE INDEX data_hash ON data(namespace,hash);
    15  CREATE INDEX data_created ON data(namespace,created);