Pls help. SQL query required to recreate a user with an ID of 1.

[Mr L]

I have used an unoffical patch to merge two VB databases together. Worked like a dream.

Later I merged some surplus accounts including the admin one. All seemed fine. A couple of weeks later (now), I notice that my ID has changed to X (new user ID) and the original user ID of 1 is gone. A mistake on my behalf here.

I need to recreate a user account with an ID of 1 and then manually do privilages etc. Can anyone help?

I am assuming that I can run an SQL query, but don't know what to run.

I still have full admin access to the board, but some scripts are not working as they look for user with an ID of 1.

Thanks.