I would like to be able to ban users via the database and also reinstate them if necessary. I can't figure out which table holds the current status of a user.
When I set the Member State to Banned via the front end, their record disappears from the table 'public_registered_users' - but where does it go? They re-appear in that table when I reinstate them.
There must be a table that holds the current state for all users?
Any help would be appreciated