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

     1  BEGIN;
     2  CREATE TABLE data (
     3    seq              SERIAL          PRIMARY KEY,
     4    id               UUID            NOT NULL,
     5    validator        VARCHAR(64)     NOT NULL,
     6    namespace        VARCHAR(64)     NOT NULL,
     7    datatype_name    VARCHAR(64)     NOT NULL,
     8    datatype_version VARCHAR(64)     NOT NULL,
     9    hash             CHAR(64)        NOT NULL,
    10    created          BIGINT          NOT NULL,
    11    value            BYTEA           NOT NULL,
    12    blobstore        BOOLEAN         NOT NULL
    13  );
    14  CREATE UNIQUE INDEX data_id ON data(id);
    15  CREATE INDEX data_hash ON data(namespace,hash);
    16  CREATE INDEX data_created ON data(namespace,created);
    17  COMMIT;