Lost admin account. Can I programmatically add one?


Something got messed up in the database, and now there is no admin account. I was curious what I can do to get one back? Can I add one using mysql, for example? Can you please guide me as to what I need to add to get an admin account? I tried playing with cscart_users table, but couldn't figure out what to add there to make it work.

Many thanks