Admin account deleted accidentally


I have accidentally deleted the admin account for my openfire server and now I cannot access the Openfire console. I still have access to the database, is there a way to manually create an admin account or change one of the existing users to admin?

Okay, problem solved. It seems I just need to rename one of my existing users in the database to “admin”.