1
Development / File Structure for Member Tables
« on: September 21, 2012, 06:41:52 am »
Hi!
I'm working on creating a form for creating new members, which will allow users to sign up on their own. I can't seem to figure out the database structure.
Usernames (and some other data, including ID) is stored in fo_members.
All member Email addys are stored in fo_contact_emails.
But where are passwords stored? What about First/Last Names vs nicknames?
I know there is a lot to do here (assigning to companies, etc.) but for now can someone please provide me with a map of the db structure so I know how to built up my $insert_query stuffs?
I appreciate you time, thanks!
I'm working on creating a form for creating new members, which will allow users to sign up on their own. I can't seem to figure out the database structure.
Usernames (and some other data, including ID) is stored in fo_members.
All member Email addys are stored in fo_contact_emails.
But where are passwords stored? What about First/Last Names vs nicknames?
I know there is a lot to do here (assigning to companies, etc.) but for now can someone please provide me with a map of the db structure so I know how to built up my $insert_query stuffs?
I appreciate you time, thanks!