1   --
 2   -- Add a new column to the pubkeys table to store the address version.
 3   -- We're going to trash all of our pubkeys and let them be redownloaded.
 4   --
 5  
 6  DROP TABLE pubkeys;
 7  
 8  CREATE TABLE `pubkeys` (
 9      `hash` blob ,
10      `addressversion` int ,
11      `transmitdata` blob ,
12      `time` int ,
13      `usedpersonally` text ,
14      UNIQUE(hash, addressversion) ON CONFLICT REPLACE
15  ) ;
16  
17  DELETE FROM inventory WHERE objecttype = 'pubkey';