1CREATE TABLE identity_keys_new ( 2 account_uuid TEXT NOT NULL, 3 recipient INTEGER NOT NULL, 4 identity_key BLOB NOT NULL, 5 trust_level TEXT NOT NULL, 6 added DATETIME DEFAULT CURRENT_TIMESTAMP, 7 FOREIGN KEY(account_uuid) REFERENCES accounts(uuid), 8 UNIQUE(account_uuid,recipient,identity_key) 9); 10INSERT INTO identity_keys_new SELECT * FROM identity_keys GROUP BY account_uuid,recipient,identity_key ORDER BY added ASC; 11DROP TABLE identity_keys; 12ALTER TABLE identity_keys_new RENAME TO identity_keys;