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

     1  CREATE TABLE IF NOT EXISTS emoji_reactions (
     2    id VARCHAR PRIMARY KEY ON CONFLICT REPLACE,
     3    clock_value INT NOT NULL,
     4    source TEXT NOT NULL,
     5    emoji_id INT NOT NULL,
     6    message_id VARCHAR NOT NULL,
     7    chat_id VARCHAR NOT NULL,
     8    local_chat_id VARCHAR NOT NULL,
     9    retracted INT DEFAULT 0
    10  );