github.com/status-im/status-go@v1.1.0/protocol/migrations/sqlite/1618923660_create_pin_messages.up.sql (about) 1 CREATE TABLE IF NOT EXISTS pin_messages ( 2 id VARCHAR PRIMARY KEY NOT NULL, 3 message_id VARCHAR NOT NULL, 4 whisper_timestamp INTEGER NOT NULL, 5 chat_id VARCHAR NOT NULL, 6 local_chat_id VARCHAR NOT NULL, 7 clock_value INT NOT NULL, 8 pinned BOOLEAN NOT NULL 9 );