github.com/status-im/status-go@v1.1.0/protocol/encryption/migrations/sqlite/1541164797_add_installations.up.sql (about) 1 CREATE TABLE installations ( 2 identity BLOB NOT NULL, 3 installation_id TEXT NOT NULL, 4 timestamp UNSIGNED BIG INT NOT NULL, 5 enabled BOOLEAN DEFAULT 1, 6 UNIQUE(identity, installation_id) ON CONFLICT REPLACE 7 );