For a registration page where the user enters their contact information and their username and password. I have two tables, one for a username and password with a foreignkey called contactinfo and a table of contact information that i want to join with the users table? Should both foreign and primary key also be set to auto increment?

Thanks