Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # Delete all orphans user meta in WordPress
- DELETE FROM wp_usermeta
- WHERE NOT EXISTS (
- SELECT * FROM wp_users
- WHERE wp_usermeta.user_id = wp_users.ID
- );
- # Remove multisite only columns in users
- alter table wp_users drop column spam;
- alter table wp_users drop column deleted;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement