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;