Adminer

Database management in a single PHP file

Brought to you by: jakubvrana

Creating Foreign Keys - MySQL

Forum: Help

Creator: Nobody/Anonymous

Created: 2011-05-13

Updated: 2013-06-06

Nobody/Anonymous - 2011-05-13

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?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Jakub Vrána - 2011-05-13

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

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Nobody/Anonymous - 2011-05-13

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

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Jakub Vrána - 2011-05-17

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

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Nobody/Anonymous - 2011-05-17

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.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Jakub Vrána - 2011-05-17

You can use current development version linked from homepage.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.