[REQ] Add UI support for creating composite FKs

[GoogleCodeExporter]

Composite (multi-column) Foreign Key relations are possible under the InnoDB 
engine.

Currently, it is not possible to create them directly through the GUI within 
the "Relations" pane.

Furthermore, manually-created composite foreign key constraints appear in the 
Relations pane as if they are single-column foreign keys.

Screenshot 1 (attached) shows the Relations pane with 2 foreign keys applied to 
a table.
"courses_ibfk_1" is in actuality a composite foreign key constraint.

Screenshot 2 shows the SQL from the CREATE TABLE syntax, verifying that it is 
indeed a composite key.

The current state is misleading and inaccurate.

MySQL 5.1.44
Sequel Pro 0.9.9.1

Original issue reported on code.google.com by sidgrabo...@gmail.com on 2 Nov 2011 at 7:15

Attachments:

• bug1.tiff
• bug2.tiff

[GoogleCodeExporter]

Issue 1389 has been merged into this issue.

Original comment by schlabbe...@gmail.com on 21 Apr 2013 at 9:41

[GoogleCodeExporter]

Issue 1389 has been merged into this issue.

Original comment by schlabbe...@gmail.com on 21 Apr 2013 at 9:55

[GoogleCodeExporter]

Composite foreign keys are now displayed correctly.

Original comment by stuart02 on 21 Oct 2013 at 6:23

• Changed title: [REQ] Add UI support for creating composite FKs
• Added labels: Component-UI, Priority-Low, Type-Enhancement, Usability