github.com/status-im/status-go@v1.1.0/protocol/migrations/sqlite/1697699419_community_control_node_sync.up.sql (about)

     1  CREATE TABLE communities_control_node (
     2      community_id BLOB NOT NULL PRIMARY KEY ON CONFLICT REPLACE,
     3      clock INT NOT NULL,
     4      installation_id VARCHAR NOT NULL
     5  );
     6  
     7  INSERT INTO
     8      communities_control_node (community_id, clock, installation_id)
     9  SELECT
    10      c.id,
    11      1 AS clock,
    12      s.installation_id
    13  FROM
    14      communities_communities AS c
    15      JOIN shhext_config AS s
    16  WHERE
    17      c.private_key IS NOT NULL
    18      AND c.private_key != '';