diff -r 3f96e2b2b03d -r 36c3c3cd2402 libpurple/resources/sqlitehistoryadapter/01-schema.sql --- a/libpurple/resources/sqlitehistoryadapter/01-schema.sql Mon Oct 10 00:27:32 2022 -0500 +++ b/libpurple/resources/sqlitehistoryadapter/01-schema.sql Mon Oct 10 00:38:48 2022 -0500 @@ -1,4 +1,4 @@ -CREATE TABLE IF NOT EXISTS message_log +CREATE TABLE message_log ( protocol TEXT NOT NULL, -- examples: slack, xmpp, irc, discord account TEXT NOT NULL, -- example: grim@reaperworld.com@milwaukee.slack.com