github.com/kaleido-io/firefly@v0.0.0-20210622132723-8b4b6aacb971/db/migrations/postgres/000007_create_offsets_table.up.sql (about)

     1  BEGIN;
     2  CREATE TABLE offsets (
     3    seq         SERIAL          PRIMARY KEY,
     4    id          UUID            NOT NULL,
     5    otype       VARCHAR(64)     NOT NULL,
     6    namespace   VARCHAR(64)     NOT NULL,
     7    name        VARCHAR(64)     NOT NULL,
     8    current     BIGINT          NOT NULL
     9  );
    10  CREATE UNIQUE INDEX offsets_id ON offsets(id);
    11  CREATE UNIQUE INDEX offsets_unique ON offsets(otype,namespace,name);
    12  COMMIT;