I would like to ask you how does like e-commerce database look. I just started making e-shop in php and I would like to know how should I design my database (tables). I've already table with something like user ID | User name | Name | Surname | address | login | password(MD5) | e-mail | registration datetime | last login datetime. I was thinking about to store IP's but I think that's better to add function for suspend account. Also do you mean is it better to store users, admins, employees datas in same table or is it better make them separates?
Thank You
