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

     1  CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
     2  
     3  BEGIN;
     4  CREATE TABLE messages (
     5    seq         SERIAL          PRIMARY KEY,
     6    id          UUID            NOT NULL,
     7    cid         CHAR(36),
     8    mtype       VARCHAR(64)     NOT NULL,
     9    author      VARCHAR(1024)   NOT NULL,
    10    created     BIGINT          NOT NULL,
    11    namespace   VARCHAR(64)     NOT NULL,
    12    topics      VARCHAR(1024)   NOT NULL,
    13    tag         VARCHAR(64)     NOT NULL,
    14    group_hash  CHAR(64),
    15    datahash    CHAR(64)        NOT NULL,
    16    hash        CHAR(64)        NOT NULL,
    17    pins        VARCHAR(1024)   NOT NULL,
    18    confirmed   BIGINT,
    19    tx_type     VARCHAR(64)     NOT NULL,
    20    batch_id    UUID,
    21    local       BOOLEAN         NOT NULL
    22  );
    23  
    24  CREATE UNIQUE INDEX messages_id ON messages(id);
    25  CREATE INDEX messages_created ON messages(created);
    26  CREATE INDEX messages_confirmed ON messages(confirmed);
    27  COMMIT;