If you don't want a user to have the same username as another user you set that as the primary key. There is a fine reason for no auto-increment.

So... How would I have a value start at one, and go up every time a new user registers?

edit: and why does everyone have this and that as "foo" and "bar" on the explainations? My dad says that all the time and it freaks me out.