Foregin keys have to be indexed in both tables, as explained in the
manual
http://dev.*mysql*.com/doc/*mysql*/en/innodb-*foreign*-*key*-constraints.html
<http://dev.mysql.com/doc/mysql/en/innodb-foreign-key-constraints.html>

You need an index on owner.owner before you can create the *foreign
**key*
constraint.

Related Posts