lib/sql/migration/014-cleanup-people.sql


1
2
3
4
5
6
7

BEGIN;
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;
COMMIT;