github.com/status-im/status-go@v1.1.0/static/mailserver_db_migrations/1557732988_initialize_db.up.sql (about)

     1  CREATE TABLE envelopes (id BYTEA NOT NULL UNIQUE, data BYTEA NOT NULL, topic BYTEA NOT NULL, bloom BIT(512) NOT NULL);
     2  
     3  CREATE INDEX id_bloom_idx ON envelopes (id DESC, bloom);
     4  CREATE INDEX id_topic_idx ON envelopes (id DESC, topic);
     5  CREATE INDEX topic_idx ON envelopes(topic);