libpurple/resources/conversationmanager/statements/delete-properties.sql@b39dbed64dc0 (annotated)
libpurple/resources/conversationmanager/statements/delete-properties.sql
Wed, 16 Jul 2025 01:08:36 -0500
- author
- Gary Kramlich <grim@reaperworld.com>
- date
- Wed, 16 Jul 2025 01:08:36 -0500
- changeset 43289
- b39dbed64dc0
- permissions
- -rw-r--r--
Delete conversations from the database when the user leaves them
Testing Done:
Left some remembered IRC channels and restarted and verified that they weren't restored. Also changed the topic in an existing room to verify that deleting tags in a save worked fine.
And of coursed, called in the turtles.
Bugs closed: PIDGIN-17989
Reviewed at https://reviews.imfreedom.org/r/4064/
|
43289
b39dbed64dc0
Delete conversations from the database when the user leaves them
Gary Kramlich <grim@reaperworld.com>
parents:
diff
changeset
|
1 | DELETE FROM conversations |
|
b39dbed64dc0
Delete conversations from the database when the user leaves them
Gary Kramlich <grim@reaperworld.com>
parents:
diff
changeset
|
2 | WHERE |
|
b39dbed64dc0
Delete conversations from the database when the user leaves them
Gary Kramlich <grim@reaperworld.com>
parents:
diff
changeset
|
3 | conversation_id = :conversation_id |
|
b39dbed64dc0
Delete conversations from the database when the user leaves them
Gary Kramlich <grim@reaperworld.com>
parents:
diff
changeset
|
4 | AND |
|
b39dbed64dc0
Delete conversations from the database when the user leaves them
Gary Kramlich <grim@reaperworld.com>
parents:
diff
changeset
|
5 | account_id = :account_id |
