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

     1  BEGIN;
     2  CREATE TABLE events (
     3    seq            SERIAL          PRIMARY KEY,
     4    id             UUID            NOT NULL,
     5    etype          VARCHAR(64)     NOT NULL,
     6    namespace      VARCHAR(64)     NOT NULL,
     7    ref            UUID,
     8    group_hash     CHAR(64),
     9    created        BIGINT          NOT NULL
    10  );
    11  
    12  CREATE UNIQUE INDEX events_id ON events(id);
    13  CREATE UNIQUE INDEX events_created ON events(created);
    14  
    15  COMMIT;