initialize_schema.sql

CREATE TABLE `inbox` (
   `msgid` blob,
   `toaddress` text,
   `fromaddress` text,
   `subject` text,
   `received` text,
   `message` text,
   `folder` text,
   `encodingtype` int,
   `read` bool,
   `sighash` blob,
UNIQUE(msgid) ON CONFLICT REPLACE
) ;

CREATE TABLE `sent` (
   `msgid` blob,
   `toaddress` text,
   `toripe` blob,
   `fromaddress` text,
   `subject` text,
   `message` text,
   `ackdata` blob,
   `senttime` integer,
   `lastactiontime` integer,
   `sleeptill` integer,
   `status` text,
   `retrynumber` integer,
   `folder` text,
   `encodingtype` int,
   `ttl` int
) ;


CREATE TABLE `subscriptions` (
   `label` text,
   `address` text,
   `enabled` bool
) ;


CREATE TABLE `addressbook` (
   `label` text,
   `address` text,
   UNIQUE(address) ON CONFLICT IGNORE
) ;


 CREATE TABLE `blacklist` (
    `label` text,
    `address` text,
    `enabled` bool
 ) ;


 CREATE TABLE `whitelist` (
    `label` text,
    `address` text,
    `enabled` bool
 ) ;


CREATE TABLE `pubkeys` (
    `address` text,
    `addressversion` int,
    `transmitdata` blob,
    `time` int,
    `usedpersonally` text,
    UNIQUE(address) ON CONFLICT REPLACE
) ;


CREATE TABLE `inventory` (
    `hash` blob,
    `objecttype` int,
    `streamnumber` int,
    `payload` blob,
    `expirestime` integer,
    `tag` blob,
    UNIQUE(hash) ON CONFLICT REPLACE
) ;


INSERT INTO subscriptions VALUES ('Bitmessage new releases/announcements', 'BM-GtovgYdgs7qXPkoYaRgrLFuFKz1SFpsw', 1);


 CREATE TABLE `settings` (
    `key` blob,
    `value` blob,
    UNIQUE(key) ON CONFLICT REPLACE
 ) ;

INSERT INTO settings VALUES('version','11');

INSERT INTO settings VALUES('lastvacuumtime', CAST(strftime('%s', 'now') AS STR) );

CREATE TABLE `objectprocessorqueue` (
    `objecttype` int,
    `data` blob,
    UNIQUE(objecttype, data) ON CONFLICT REPLACE
) ;