Quote:
Originally Posted by Nutter  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. |
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..