The core.Members table determines group membership. If you insert a new row with GroupId=-1 (special id for site admin) and UserId=<this user's id> he will become a site admin. You can look up his id in the core.Users view, e.g., SELECT UserId FROM core.Users WHERE email='xxx@test.com'.

Adam