Query
CREATE TABLE email_threads (
thread_key TEXT PRIMARY KEY,
provider TEXT,
mailbox TEXT,
subject TEXT,
participants TEXT,
message_count INTEGER NOT NULL DEFAULT 0,
pending_reply_count INTEGER NOT NULL DEFAULT 0,
last_message_id TEXT,
last_message_at TEXT,
last_inbound_at TEXT,
last_outbound_at TEXT,
latest_draft_id TEXT,
updated_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),
created_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now'))
)