Drop unused acpeerstates table in a migration, and delete unused keys in housekeeping
- Dominant language
- Rust
- Stars
- 929
- Forks
- 143
- Avg merge
- 1d 20h
- Merged PRs (30d)
- 53
Description
- Operating System (Linux/Mac/Windows/iOS/Android): Debian 12
- Core Version: 1.158.0
- Client Version: deltachat-rpc-client 1.158.0
## Expected behavior
Bots have to be able to forget about a contact for privacy reasons. After a contact is removed from all chats, it can be deleted. I'd expect it to be deleted from all database tables.
## Actual behavior
The email address and the public key remain in the acpeerstates table, and maybe also in other database tables (I don't have a good way to check all tables, is there a command for that?)
### Steps to reproduce the problem
1. Create new Alice + Bob profiles
2. Send a message from Bob to Alice
3. In Alice's account, delete the 1:1 chat with Bob
4. In Alice's account the Bob's contact
5. In an sqlitebrowser or similar software, run `select * from acpeerstates;` in Alice's dc.db file
Contributor guide
Assessment
This issue has not been assessed yet.