Entering & executing CREATE/ALTER TABLE works for me too, but UNIQUE option of index kind is disabled on Indices tab of Table Editor.
OK, here is my environment:
- mysql-server: 5.1.37-1ubuntu5.1
- mysql-gui-tools: 5.0r12-1ubuntu2
- interesting! UNIQUE index kind is grayed out only when MyISAM or InnoDB engine is selected! but those engines seem to support it, because entering and executing still work!
- default charset is UTF-8, but it barely matter
- index type is default, but it barely matter too
- OS is Ubuntu 9.10 amd64
Thanks, Dave!
UPD:
Look at MGTableEditor::update_for_selected_engine()
I never saw this code before, but I suggest that index "type" and "kind" could be messed up here.
http://pastebin.com/asV3HJef
Edited 1 time(s). Last edit at 04/30/2010 12:43PM by Mihail Lukin.