Re: Error messages when trying to create table with foreign key

[Charles Iscove]

That worked, but I also had to add an index:

alter table Release add index (Type);

Now I'm getting the following warning:

PRIMARY and INDEX keys should not both be set for column `idType`

I made all the 'id' columns in the tables Primary. Should I make another column Primary - what if the table as a number of columns - how do I decide which one - or should I just remove the Primary key altogether?



Edited 1 time(s). Last edit at 06/22/2009 10:57AM by Charles Iscove.