6
CREATE TABLE IF NOT EXISTS contact_type (
7
id INTEGER PRIMARY KEY,
8
descr TEXT NOT NULL UNIQUE -- to, cc, bcc, from
11
CREATE TABLE IF NOT EXISTS contact (
12
id INTEGER PRIMARY KEY,
13
cname TEXT DEFAULT '', -- sometimes, it's NULL; we set it
14
address TEXT DEFAULT '' -- to empty to prevent dups
16
CREATE INDEX IF NOT EXISTS contact_address_index ON contact (address);
18
CREATE TABLE IF NOT EXISTS message (
19
id INTEGER PRIMARY KEY,
20
msg_id TEXT, -- the message id
21
tstamp INTEGER DEFAULT 0, -- timestamp
22
mpath TEXT NOT NULL UNIQUE, -- path to the message
23
mdate INTEGER DEFAULT 0, -- message date (time_t)
24
msize INTEGER DEFAULT 0, -- message size (in bytes)
25
sender VARCHAR, -- message sender (From:)
26
recipients TEXT, -- message recipient (To:)
28
subject TEXT, -- message subject
29
flags INTEGER, -- flags (MuMsgFlags)
30
priority INTEGER -- priority (MuMsgPriority)
32
CREATE UNIQUE INDEX IF NOT EXISTS mpath_index ON message(mpath);
34
CREATE TABLE IF NOT EXISTS message_contact (
35
message_id INTEGER, -- points to message
36
contact_id INTEGER, -- points to contact
37
contact_type_id INTEGER -- points to contact_type