Hello guys, I'm new to gamedev.net and i came here with a question. I'm building an online game with c++, but that's not what my question is about. In my database, I have a table named Players. The structure of Players is something like [color=#800000]playerID(primary key), playerName, etc. Now here is what I need to know:
1. If playerName is unique, can I remove playerID and make playerName primary key?
2. Why would the above be ok/not ok?
The entries in Players table could go as high as thousands.
I am using MySql with InnoDB