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

     1  BEGIN;
     2  CREATE TABLE subscriptions (
     3    seq            SERIAL          PRIMARY KEY,
     4    id             UUID            NOT NULL,
     5    namespace      VARCHAR(64)     NOT NULL,
     6    name           VARCHAR(64)     NOT NULL,
     7    transport      VARCHAR(64)     NOT NULL,
     8    filter_events  VARCHAR(256)    NOT NULL,
     9    filter_topics  VARCHAR(256)    NOT NULL,
    10    filter_tag     VARCHAR(256)    NOT NULL,
    11    filter_group   VARCHAR(256)    NOT NULL,
    12    options        JSONB           NOT NULL,
    13    created        BIGINT          NOT NULL
    14  );
    15  
    16  CREATE UNIQUE INDEX subscriptions_id ON subscriptions(id);
    17  CREATE UNIQUE INDEX subscriptions_name ON subscriptions(namespace,name);
    18  
    19  COMMIT;