github.com/kaleido-io/firefly@v0.0.0-20210622132723-8b4b6aacb971/db/migrations/ql/000007_create_offsets_table.up.sql (about) 1 CREATE TABLE offsets ( 2 id string NOT NULL, 3 otype string NOT NULL, 4 namespace string NOT NULL, 5 name string NOT NULL, 6 current int64 NOT NULL, 7 ); 8 CREATE UNIQUE INDEX offsets_primary ON offsets(id); 9 CREATE UNIQUE INDEX offsets_unique ON offsets(otype,namespace,name);