I am putting together a small consumer website and am at the point to design and implement the users' database. I get from my PHP register form a username, a salt, a hashed pw, and some other data (email address, etc) which are non-required. Logins need to be uniques.
My inclination is to do a single table with this data, making Logins the key and indexing the table with them. Alternatively I could use an autoincrement field in the DB to generate a unique userID as an index, if there are performance gains to be had, or generate a GUID, but I'm not clear on the specific pros and cons for each of these approaches.
I suppose I should also record the time & date of registration.
Is this the right setup? What else should I consider adding?