Please refer to the Keys.dat article for the location.
Below is a list of Tables and their creation SQL command.
Contains Messages that were successfully decrypted. Contains trashed received messages too.
CREATE TABLE inbox ( msgid blob, toaddress text, fromaddress text, subject text, received text, message text, folder text, encodingtype int, read bool, UNIQUE(msgid) ON CONFLICT REPLACE)
Contains Messages that were sent. Contains trashed sent messages too.
CREATE TABLE sent ( msgid blob, toaddress text, toripe blob, fromaddress text, subject text, message text, ackdata blob, lastactiontime integer, status text, pubkeyretrynumber integer, msgretrynumber integer, folder text, encodingtype int )
Contains Addresses the user is subscribed to.
CREATE TABLE subscriptions ( label text, address text, enabled bool )
Contains the users address book
CREATE TABLE addressbook ( label text, address text )
Contains blacklisted addresses
CREATE TABLE blacklist ( label text, address text, enabled bool )
Contains whitelisted addresses
CREATE TABLE whitelist ( label text, address text, enabled bool )
Contains pubkeys and messages received
CREATE TABLE inventory ( hash blob, objecttype text, streamnumber int, payload blob, receivedtime integer, UNIQUE(hash) ON CONFLICT REPLACE)
Empty table. Will probably contain known nodes once the system is developed and deployed further. Currently the knownnodes.dat is used instead.
CREATE TABLE knownnodes ( timelastseen int, stream int, services blob, host blob, port blob, UNIQUE(host, stream, port) ON CONFLICT REPLACE)
Contains some settings, currently the version (probably of the database) and the time the database was last cleaned up
CREATE TABLE settings ( key blob, value blob, UNIQUE(key) ON CONFLICT REPLACE)
Contains public keys created by the user and the time it was last transmitted.
CREATE TABLE pubkeys ( hash blob, transmitdata blob, time int, usedpersonally text, UNIQUE(hash) ON CONFLICT REPLACE)
Internally a message is deleted by setting its folder to "trash" but leaving it in its table. The current version has an option to delete trashed messages definitely, this also shrinks the database. Allows the user to clean up the database more than once per month.