Creating Foreign Keys - MySQL

Help
2011-05-13
2013-06-06
  • 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.

     
  • 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.

     
  • 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.