Purging users "awaiting email confirmation"


Active member
Greetings -

We have well-over 10,000 accounts with a user state of "awaiting email confirmation." I'd like to create a custom script that will remove these accounts on a regular basis. Which tables would I need to include to ensure they're completely removed?

So far I've identified:
  • xf_user
  • xf_user_authenticate
  • xf_user_group_relation
  • xf_user_option
  • xf_user_privacy
  • xf_user_profile
Accurate? Are there any others?

Thanks in advance.