Can someone explain to me how users are stored SonarQube's database (mysql)? I did a wrong query that corrupted a new user's account. I am trying to fix it but I can't get the user to show up again on the /users page so something must still not be quite right even though everything look correct in the "users" table. Is there any other table involved?
The user is new so he has not activity in the DB (never logged in, nothing assigned etc.).
Alternatively I am ok deleting the user and recreating, but I don't know how to do that since it doesn't show in the web ui. To do it in the DB I would need again to know the data model.
You should revert your SQL change, delete the directory data/es then delete the user through the standard way (administration console or web service). If you don't know what was the exact change, then a database backup should be restored.