github.com/status-im/status-go@v1.1.0/protocol/migrations/sqlite/1660226788_create_chat_identity_social_links.up.sql (about) 1 CREATE TABLE IF NOT EXISTS chat_identity_social_links ( 2 chat_id VARCHAR NOT NULL, 3 link_text TEXT, 4 link_url TEXT, 5 UNIQUE(chat_id, link_text) ON CONFLICT REPLACE 6 ); 7 8 CREATE TABLE IF NOT EXISTS chat_identity_last_received ( 9 chat_id VARCHAR NOT NULL PRIMARY KEY ON CONFLICT REPLACE, 10 clock_value INT NOT NULL 11 );