[sequel-pro] How to create composite primary key in Sequel Pro?

[jia]

I couldn't find a way in the UI to create composite key. Any hint?
Thanks.

--
You received this message because you are subscribed to the Google Groups "Sequel Pro" group.
To post to this group, send email to seque...@googlegroups.com.
To unsubscribe from this group, send email to sequel-pro+...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/sequel-pro?hl=en.

[Jakob Egger]

1) If any field in your table has "auto_increment" in the extras column, remove it
2) if there is a primary index, remove it
3) click the add index button
4) where it says "indexed columns", type the columns you want in your key, separated by comma
5) click add


We are aware that this procedure is somewhat awkward. There are plans to improve this interface.

A related issue/feature request is http://spbug.com/480

Hope I could help,

Jakob Egger