Bug #46445 Unable to create Primary Keys containing multiple columns
Submitted: 29 Jul 2009 8:05 Modified: 29 Aug 2009 8:24
Reporter: Syed Mohammed Omer Farooq Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.1.16 OS:Windows
Assigned to: CPU Architecture:Any
Tags: Primary Key containing multiple columns

[29 Jul 2009 8:05] Syed Mohammed Omer Farooq 
Description:
Unable to create primary key containing multiple columns.

How to repeat:
Create a table in MySQL Workbench "customers". Define following columns:
1.BRANCH_CODE      CHAR(4)     NOT NULL
2.CUSTOMER_ID      CHAR(10)    NOT NULL
3.CUSTOMER_NAME    VARCHAR(60) NOT NULL

Click the Index Tab and Define Index Name "PK_CUSTOMER" and from type columns select the Primary. From Index Columns select "BRANCH_CODE" and "CUSTOMER_ID" columns. As soon the multiple columns are selected the Type Column changed to INDEX.
[29 Jul 2009 8:24] Valeriy Kravchuk 
Thank you for the problem report. Please, try to double click blue dots to the left of column names at Columns tab. This should allow to create primary key on multiple columns.

In MySQL primary key index is always named PRIMARY. This is the reason of your problem, I think.
[29 Aug 2009 23:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[29 Dec 2009 5:08] [ name withheld ] 
This is clearly a duplicate of bug #46444