In MySQL, adding an identifying relationship places the new relationship at the first index of all keys on the table. MySQL doesn't like this since the auto increment id field needs to be in the first position. Have to reposition keys each time I add an identifying relationship. This is a newer bug.
MySQL Error: "Incorrect table definition; there can be only one auto column and it must be defined as a key"
Customer support service by UserEcho