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

     1  CREATE TABLE pins (
     2    masked         bool             NOT NULL,
     3    hash           string           NOT NULL,
     4    batch_id       string           NOT NULL,
     5    idx            int64            NOT NUlL,
     6    dispatched     bool             NOT Null,
     7    created        int64            NOT NULL
     8  );
     9  
    10  CREATE UNIQUE INDEX pins_pin ON pins(hash, batch_id, idx);
    11  CREATE INDEX pins_dispatched ON pins(dispatched);