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