git.ozlabs.org Git - patchwork/blob - lib/sql/migration/014-cleanup-people.sql

   1 BEGIN;
   2 DELETE FROM patchwork_person WHERE id NOT IN (
   3         SELECT submitter_id FROM patchwork_patch
   4         UNION
   5         SELECT submitter_id FROM patchwork_comment)
   6     AND user_id IS NULL;
   7 COMMIT;