
diff -r a7d2978df0b6 -r 741992355ead libpurple/resources/sqlitehistoryadapter/01-schema.sql
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/libpurple/resources/sqlitehistoryadapter/01-schema.sql	Tue Oct 12 00:50:59 2021 -0500
@@ -0,0 +1,17 @@
+CREATE TABLE IF NOT EXISTS message_log
+(
+        protocol TEXT NOT NULL, -- examples: slack, xmpp, irc, discord
+        account TEXT NOT NULL, -- example: grim@reaperworld.com@milwaukee.slack.com
+        conversation_id TEXT NOT NULL, -- example: #general
+        message_id TEXT NOT NULL, -- exampe: 14fdjakafjakl1155
+        author TEXT NULL, -- could be null for status messages
+        author_name_color TEXT NULL,
+        author_alias TEXT NULL,
+        recipient TEXT NULL,
+        content_type TEXT NULL CHECK(content_type IN ('plain', 'html', 'markdown', 'bbcode')),
+        content TEXT NULL, -- must be UTF8 string
+        raw_content TEXT NULL, -- the message as came from the protocol
+        protocol_timestamp TEXT, -- according to protocol, could be wrong
+        client_timestamp DATETIME, -- when it "landed" in libpurple
+        log_version INTEGER DEFAULT 1 NOT NULL
+);




