Bogus accounts in patchwork
Jeremy Kerr
jk at ozlabs.org
Wed May 7 13:11:02 EST 2014
Hi all,
> DELETE FROM patchwork_person WHERE id NOT IN (
> SELECT submitter_id FROM patchwork_patch
> UNION
> SELECT submitter_id FROM patchwork_comment
Make that:
DELETE FROM patchwork_person WHERE id NOT IN (
SELECT submitter_id FROM patchwork_patch
UNION
SELECT submitter_id FROM patchwork_comment)
AND user_id IS NULL;
- so we retain linkages for folks that haven't submitted a patch or comment.
Cheers,
Jeremy
More information about the Patchwork
mailing list