Just wondering what you would have in a user database, in my list i have:

ID
Username
Password
Email
Name
MSN
AIM
YIM
ICQ
Secret question
Answer
Location
Datejoined
Lastactive
Permissions

Just wondering what others people have in theres so i can maybe improve mine.

__________________

---

telephone number? SSN? lol...

__________________

---

you could have phone number but wouldnt fit in mine as its not relevant, whats SSN?

__________________

---

SSN is social security number and you better not listen to that advice - DO NOT STORE SSN OR TIN (Taxpayer Identification Number) IN YOUR DATABASE. That creates a huge liability if your db is hacked.

I'd also include address information, but in a separate table (so that one user could have many addresses [billing, home, work, etc.])

__________________
Jeremy Miller
Content Farmer - Optimized Automated Blog Posting

---

I would have no need for that anyway so if i used it in my system i would be breaking the law.

__________________

---

Sort of a vague question. What's the purpose of the application? That would really determine what you need to store. Think about a forum user compare to an ecommerce site user. You would want to store different information on the two.

You should also consider not storing the password as plain text but rather run it through either a md5() or password() function in the SQL query so that it's stored encoded.

__________________
- Ryan

---

And, if you have access to the right version of PHP, I'd suggest using a non-compromised hash function PHP: sha1 - Manual

__________________
Jeremy Miller
Content Farmer - Optimized Automated Blog Posting

---

For ecommerce, you probably need to store their credit card nicely with the encryption. But I guess you need to be sure with what you're doing if you're really going to keep something that's so important such as CC

__________________

---

I am really just practising and seeing what people think, the table i was thinking about was to be a basic user login system, maybe a profile, just to practise really.

I already use the md5() and PASSWORD() functions, there handy

I may end up turning this into a small CMS for myself, i know for that i need more tables with id, title, comment, user id etc..

__________________

---

Please, at least switch to using sha1 while it's early in the game if you're not able to use the more robust ones.

__________________
Jeremy Miller
Content Farmer - Optimized Automated Blog Posting

---