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

     1  CREATE TABLE IF NOT EXISTS communities_check_channel_permission_responses (
     2    community_id VARCHAR NOT NULL,
     3    chat_id VARCHAR NOT NULL DEFAULT "",
     4    view_only_permissions_satisfied BOOLEAN NOT NULL DEFAULT TRUE,
     5    view_and_post_permissions_satisfied BOOLEAN NOT NULL DEFAULT TRUE,
     6    view_only_permission_ids TEXT NOT NULL,
     7    view_and_post_permission_ids TEXT NOT NULL,
     8    PRIMARY KEY(community_id, chat_id) ON CONFLICT REPLACE
     9  );
    10  
    11  CREATE TABLE IF NOT EXISTS communities_permission_token_criteria_results (
    12    permission_id VARCHAR NOT NULL DEFAULT "",
    13    community_id VARCHAR NOT NULL,
    14    chat_id VARCHAR NOT NULL DEFAULT "",
    15    criteria VARCHAR NOT NULL DEFAULT "",
    16    PRIMARY KEY(community_id, chat_id, permission_id) ON CONFLICT REPLACE
    17  );
    18