Query
CREATE TABLE sms_conversations (
phone_number TEXT PRIMARY KEY,
-- "+1555123456"
display_name TEXT,
-- optional future contact name
provider TEXT NOT NULL DEFAULT 'textbelt',
message_count INTEGER NOT NULL DEFAULT 0,
pending_reply_count INTEGER NOT NULL DEFAULT 0,
last_message_at TEXT,
last_inbound_at TEXT,
last_outbound_at TEXT,
latest_draft_id TEXT,
created_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),
updated_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now'))
)