1  CREATE TEMPORARY TABLE `pubkeys_backup` (
 2      `hash` blob,
 3      `transmitdata` blob,
 4      `time` int,
 5      `usedpersonally` text,
 6      UNIQUE(hash) ON CONFLICT REPLACE
 7  ) ;
 8  
 9  INSERT INTO `pubkeys_backup` SELECT hash, transmitdata, `time`, usedpersonally FROM `pubkeys`;
10  
11  DROP TABLE `pubkeys`
12  
13  CREATE TABLE `pubkeys` (
14      `hash` blob,
15      `transmitdata` blob,
16      `time` int,
17      `usedpersonally` text,
18      UNIQUE(hash) ON CONFLICT REPLACE
19  ) ;
20  
21  
22  INSERT INTO `pubkeys` SELECT hash, transmitdata, `time`, usedpersonally FROM `pubkeys_backup`;
23  
24  DROP TABLE `pubkeys_backup`;
25  
26  DELETE FROM inventory WHERE objecttype = 'pubkey';
27  
28  DELETE FROM subscriptions WHERE address='BM-BbkPSZbzPwpVcYZpU4yHwf9ZPEapN5Zx'
29  
30  INSERT INTO subscriptions VALUES('Bitmessage new releases/announcements','BM-GtovgYdgs7qXPkoYaRgrLFuFKz1SFpsw',1)