Hello!
I have such problem:
When I want to edit foreign key in DS it doesn't work. For example: I want to change delete or update rule in my FK, but when I open table again nothing has been changed. So, to edit this I have to delete my FK and to create it with new values of update or delete rule.
I’ve checked MySQL server that installed on my machine and tried to delete or add FK manually with “ALTER TABLE tbl_name ADD [CONSTRAINT symbol] FOREIGN KEY [id] (index_col_name, ...)” and “ALTER TABLE tbl_name DROP FOREIGN KEY fk_symbol” commands. Everything works well. Server version is 5.1.21
Please help…
Problems with foreign keys editing
More information
I am sorry. I've given some incorrect information above. Any FK you've created can't be modified at all. You cannot change any properties. After you created FK you can't modify it even if you delete and create it again. That's mean that only one method to change FK properties is to do it manually by ALTER TABLE command in MySQL Query Browser. This problem is similar to the problem with decimal type.