SQL data created upon registration

[h_kakashi]

Hi, I was wondering if anyone could give me the tables and columns that are affected upon a user registration.

I know that data is added into the fields in the `user` table, but where else is stuff put when a new user registers?

Also, how does VB's cookie/session creation and authentication work? I'm trying to integrate my forum and CMS so that if a user logs in the forum, he'd be logged in on the CMS and vice versa... I tried including global.php and checking for $bbuserinfo but all I got was 'NULL' for the contents, also how exactly is this variable created (if I wanted to make the session/cookie in my CMS login script).