I have not searched but shouldn't they have some database schema documentations such as ER diagrams?
this post was submitted on 25 Jun 2023
13 points (100.0% liked)
Lemmy
13654 readers
1 users here now
Everything about Lemmy; bugs, gripes, praises, and advocacy.
For discussion about the lemmy.ml instance, go to !meta@lemmy.ml.
founded 5 years ago
MODERATORS
I have used
UPDATE person
SET deleted = 't'
WHERE id =nnnn;
You can get the id's from:
SELECT id, name, published
FROM person
WHERE instance_id= 1 and deleted = 'f'
ORDER by id;