Originally Posted by tempz
something like this?
ALTER TABLE tbl1
ADD UNIQUE KEY(col1, col2)
Same goes with PRIMARY KEY as well if you wanted that instead of just the unique. I typically name mine, but its not required.
I don't typically use the phpMyAdmin, but I do seem to recall that using it for composite keys and relations was a nightmare. SQL is much much easier.