1  --
 2  -- changes related to protocol v3
 3  -- In table inventory and objectprocessorqueue, objecttype is now
 4  -- an integer (it was a human-friendly string previously)
 5  --
 6  
 7  DROP TABLE inventory;
 8  
 9  CREATE TABLE `inventory` (
10      `hash` blob,
11      `objecttype` int,
12      `streamnumber` int,
13      `payload` blob,
14      `expirestime` integer,
15      `tag` blob,
16      UNIQUE(hash) ON CONFLICT REPLACE
17  ) ;
18  
19  DROP TABLE objectprocessorqueue;
20  
21  CREATE TABLE `objectprocessorqueue` (
22      `objecttype` int,
23      `data` blob,
24      UNIQUE(objecttype, data) ON CONFLICT REPLACE
25  ) ;