Create Admin Account in UNA direct in database

Seemed that the admin account for a UNA site was accidentally removed through the UNA studio.  Might want to add a ticket to GitHub to prevent this.

I need to add the admin account back directly through the database but I don't know the structure of the UNA database to accomplish this.  Please help.

This is frustrating, all my work is gone, there has to be a way

I figured it out, sys_accounts is the table that holds the main login, user, email, password for the accounts.

Thanks, i'm playing around now with the icons, cause they seem to have changed in size. GG i was able to make the menu icon smaller by replacing it. The icon you see on the attached photo is actually 225x225, but the site makes them large, anyway, hopefully AlexT can help out.

This is how everything started, i'm adding this to the forum so that no one makes the same mistake. If admin or any level that has the rights to create profile or organization, can NOT go to any of the accounts in which were created and delete "a test account" that was created for testing purposes. You have to choose "delete profile...not "delete account, cause if you choose delete account, you will find yourself locked out of the site. It will delete the primary account as well.

I am not sure why the template is out of whack.  I reloaded the template from the UNA zip but that did not correct the situation. You may be forced to start over with a clean install.

 Yes, i have no other choice...  go for it, please.

Please refer to this post about creating Operator profile manually:

https://una.io/cmts.php?sys=bx_forum&id=112&cmt_id=180