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

     1  CREATE TABLE IF NOT EXISTS encrypted_community_description_cache (
     2    community_id TEXT PRIMARY KEY,
     3    clock UINT64,
     4    description BLOB,
     5    UNIQUE(community_id) ON CONFLICT REPLACE
     6    );
     7  
     8  CREATE TABLE IF NOT EXISTS encrypted_community_description_missing_keys (
     9          community_id TEXT,
    10          key_id TEXT,
    11          PRIMARY KEY (community_id, key_id),
    12          FOREIGN KEY (community_id) REFERENCES encrypted_community_description_cache(community_id) ON DELETE CASCADE
    13  );
    14  
    15  CREATE INDEX IF NOT EXISTS encrypted_community_description_id_and_clock ON encrypted_community_description_cache(community_id, clock);
    16  CREATE INDEX IF NOT EXISTS encrypted_community_description_key_ids ON encrypted_community_description_missing_keys(key_id);