RE: Error 1005 when adding a Foreign Key

2004-07-02 Thread Héctor Maldonado
Hi, Check if column PlanName is the primary key (and the only one) in table testplans. If so, check if both fields PlanName in testplans and PlanName in runload_list are exactly of the same type and size. Regards, Hector -- Ing. Hector Maldonado Melgar Dpto. Desarrollo de Software TCI S.A.

Re: Error 1005 when adding a Foreign Key

2004-07-02 Thread Josh Chamas
Bartis, Robert M (Bob) wrote: I recently added a column and Index to an existing table. I wanted to also add a Foreign Key. I have done this before defining the commands outside MySQL and souring the file in for new tables, but would prefer to not have to dump the current table just for the modific

Error 1005 when adding a Foreign Key

2004-07-02 Thread Bartis, Robert M (Bob)
I recently added a column and Index to an existing table. I wanted to also add a Foreign Key. I have done this before defining the commands outside MySQL and souring the file in for new tables, but would prefer to not have to dump the current table just for the modification. I tried to add one b