Bug #60331 foreign keys don't show in "show create table".
Submitted: 4 Mar 2011 9:30 Modified: 17 Mar 2011 19:30
Reporter: Uri Even-Chen Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Server: DDL Severity:S3 (Non-critical)
Version:5.0.93, 5.1.41, 5.1.54 OS:Any (Ubuntu 10.04 LTS, Windows, Mac OS X)
Assigned to: CPU Architecture:Any
Tags: foreign, ignored, keys

File: Maximum allowed size is 50MB.
Description:
Privacy:

If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.

To split a large file:

[6 Mar 2011 22:01] Rodrigo Coelho
When the comment for the field "password" is present, the constraint is not created. A key is created instead.

Attachment: comment_issue.sql (application/octet-stream, text), 625 bytes.