
diff -r 4968ebe46578 -r 01eb1bbf4186 libpurple/resources/conversationmanager/statements/insert-properties.sql
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/libpurple/resources/conversationmanager/statements/insert-properties.sql	Fri Jul 11 01:55:31 2025 -0500
@@ -0,0 +1,61 @@
+INSERT INTO conversations(
+  account_id,
+  age_restricted,
+  alias,
+  conversation_id,
+  created_on,
+  creator_id,
+  description,
+  drafting,
+  favorite,
+  federated,
+  logging,
+  needs_attention,
+  title,
+  topic,
+  topic_author_id,
+  topic_updated,
+  type,
+  url,
+  user_nickname
+)
+VALUES (
+  :account_id,
+  :conv_age_restricted,
+  :conv_alias,
+  :conv_id,
+  :conv_created_on,
+  :creator_id,
+  :conv_description,
+  :conv_drafting,
+  :conv_favorite,
+  :conv_federated,
+  :conv_logging,
+  :conv_needs_attention,
+  :conv_title,
+  :conv_topic,
+  :topic_author_id,
+  :conv_topic_updated,
+  :conv_type,
+  :conv_url,
+  :conv_user_nickname
+)
+ON CONFLICT(account_id, conversation_id)
+DO UPDATE SET
+  age_restricted=:conv_age_restricted,
+  alias=:conv_alias,
+  created_on=:conv_created_on,
+  creator_id=:creator_id,
+  description=:conv_description,
+  drafting=:conv_drafting,
+  favorite=:conv_favorite,
+  federated=:conv_federated,
+  logging=:conv_logging,
+  needs_attention=:conv_needs_attention,
+  title=:conv_title,
+  topic=:conv_topic,
+  topic_author_id=:topic_author_id,
+  topic_updated=:conv_topic_updated,
+  type=:conv_type,
+  url=:conv_url,
+  user_nickname=:conv_user_nickname




