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

     1  CREATE TABLE subscriptions (
     2    id             string          NOT NULL,
     3    namespace      string          NOT NULL,
     4    name           string          NOT NULL,
     5    transport      string          NOT NULL,
     6    filter_events  string          NOT NULL,
     7    filter_topics  string          NOT NULL,
     8    filter_tag     string          NOT NULL,
     9    filter_group   string          NOT NULL,
    10    options        blob            NOT NULL,
    11    created        int64           NOT NULL
    12  );
    13  
    14  CREATE UNIQUE INDEX subscriptions_primary ON subscriptions(id);
    15  CREATE UNIQUE INDEX subscriptions_name ON subscriptions(namespace,name);