this post was submitted on 25 Jun 2023
21 points (100.0% liked)
Lemmy
12535 readers
2 users here now
Everything about Lemmy; bugs, gripes, praises, and advocacy.
For discussion about the lemmy.ml instance, go to !meta@lemmy.ml.
founded 4 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
This probably needs verification, so run at your own risk!
The SQL statement to delete would be:
DELETE from person where name = '...'
person
is the table of users.name = '...'
is the condition for the row that is to be deleted.You can also modify the condition to, for example, delete a user using the
id
instead of theirname
(username).Here's a link to the "schema" of the
person
table as generated by the backend code.With federated services it’s generally a bad idea to fully delete an account, it’s better to mark the account as “deleted” so future requests can be notified of the deletion
This also prevents people from impersonating others