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);