I have the following innoDb tables:
country has `id` as PK
lang has `id` as PK
I want to have a 3rd innoDb table:
countrylang with `cid,lang` as compound key with both `cid` and `lang` as
foreign (cascade-delete) keys to the "master" tables.
However mysql throws error (Cannot create table..) when I try to define
`cid` as a foreign key to country.id
country.id and countrytext.cid are both smallint(5)
Any help?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]