Implicit Gaming

Can someone figure out why I cant change the mysql ID colum from DEFAULT to AUTO_INCREMENT its gives the next error: /* SQL Error (1075): Incorrect table definition; there can be only one auto column and it must be defined as a key */ I want to change this to AUTO_INCREMENT because if anyone else create's an account the person ingame will be kicked because it safes every account as NULL