are virtual, and if you try to query them with sqlite3, you’ll get the error “ Error: unknown tokenizer: mozporter“. P.S.: some tables such as messagesText etc.
Select distinct messagesText_content.c3author from (messages inner join messagesText_content on (messagesText_content.docid = messages.id)) where messages.date > '1230768000000000'
Unix_epoch_ms = (date - DATE(1970 1 1)*86400000000įor example this query will extract to the file authors.txt all the people who sent me mails from January 1st 2009 until today. Note that the date field in the messages table is in microseconds elapsed from the Unix epoch, to convert: date = DATE(1970 1 1) + unix_epoch_ms/86400000000 While this is the format of the messages table: CREATE TABLE messages (id INTEGER PRIMARY KEY, folderID INTEGER, messageKey INTEGER, conversationID INTEGER NOT NULL, date INTEGER, headerMessageID TEXT, deleted INTEGER NOT NULL default 0, jsonAttributes TEXT, notability INTEGER NOT NULL default 0) Īnd this is the messagesText_content: CREATE TABLE 'messagesText_content'(docid INTEGER PRIMARY KEY, 'c0subject', 'c1body', 'c2attachmentNames', 'c3author', 'c4recipients') Now let’s explore a little bit the format of the database. Open a shell, and type (here ehr3bn8y is the name of my profile, your will be different): sqlite3 ~/.thunderbird/fault/global-messages-db.sqlite Solution: use the internal sqlite database created by the Thunderbird search engine. Problem: you are not satisfied by the built-in search user interface of Mozilla Thunderbird 3.1, and you need to extract some informations as raw data.
Note: the following is not for the fainthearted.
0 kommentar(er)
