Hi,
I have a table in my database for user information. At 1st I was thinking of only storing basic user info, username, 1st name, last name, password etc. However I now want to add more advanced user details, like 2 or 3 comment fields, address, directions, nearest facilities.
Should I create a new table, and have user_basic and user_advanced. Or just stick it all in 1 table?
The tables haven't been used yet, and are blank so wiping them, and starting again isn't a problem.
Cheers for any input
Ben
I have a table in my database for user information. At 1st I was thinking of only storing basic user info, username, 1st name, last name, password etc. However I now want to add more advanced user details, like 2 or 3 comment fields, address, directions, nearest facilities.
Should I create a new table, and have user_basic and user_advanced. Or just stick it all in 1 table?
The tables haven't been used yet, and are blank so wiping them, and starting again isn't a problem.
Cheers for any input
Ben