Creating Foreign Keys - MySQL

  • Nobody/Anonymous

    I upgraded to the latest version because I saw examples on the home page that indicated adminer could create foreign keys - but I'm darned if I can see how/where to do it. The foreign key option shown in the images on the web site do not appear when I create tables etc.  What am I missing?

  • Jakub Vrána

    Jakub Vrána - 2011-05-13

    Foreign keys in MySQL are supported only with InnoDB table type, not with MyISAM.

  • Nobody/Anonymous

    Actually I'm not using either - I'm using IBM DB2 storage engine but I suspect that the issue is the same. Thanks

  • Jakub Vrána

    Jakub Vrána - 2011-05-17

    IBMDB2I supports foreign keys too so I've added it to the Git version of Adminer.

  • Nobody/Anonymous

    Thanks for that - I'll give it a try but …

    Excuse my ignorance but I barely know what Git is and can find no link to that version on this site. 


Log in to post a comment.