Hello.
Please, send the output of the following statements:
SHOW CREATE TABLE country;
SHOW CREATE TABLE lang;
Include the CREATE statement for countrylang table and exact error number.
Guy Brom wrote:
> 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?
>
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
