github.com/status-im/status-go@v1.1.0/appdatabase/migrations/sql/1691753800_pubsubtopic_key.up.sql (about)

     1  CREATE TABLE IF NOT EXISTS pubsubtopic_signing_key (
     2      topic VARCHAR NOT NULL,
     3      priv_key BLOB NULL,
     4      pub_key BLOB NOT NULL,
     5      PRIMARY KEY (topic)
     6  ) WITHOUT ROWID;
     7  
     8  CREATE TABLE IF NOT EXISTS mailserver_topics_new (
     9      topic VARCHAR NOT NULL DEFAULT "",
    10      pubsub_topic VARCHAR NOT NULL DEFAULT "/waku/2/default-waku/proto",
    11      chat_ids VARCHAR,
    12      last_request INTEGER DEFAULT 1,
    13      discovery BOOLEAN DEFAULT FALSE,
    14      negotiated BOOLEAN DEFAULT FALSE,
    15      PRIMARY KEY(topic, pubsub_topic)
    16  ) WITHOUT ROWID;
    17  
    18  INSERT INTO mailserver_topics_new 
    19  SELECT topic, "/waku/2/default-waku/proto", chat_ids, last_request, discovery, negotiated
    20  FROM mailserver_topics;
    21  
    22  DROP TABLE mailserver_topics;
    23  
    24  ALTER TABLE mailserver_topics_new RENAME TO mailserver_topics;