MySQL Bugs: #18773: foreign keys deleted when changing layers

Bug #18773	foreign keys deleted when changing layers
Submitted:	4 Apr 2006 14:15	Modified:	5 May 2006 15:18
Reporter:	Joelle Tegwen	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Workbench Preview	Severity:	S3 (Non-critical)
Version:	Beta 1.0.5/1.0.6	OS:	Windows (Windows XP sp 2)
Assigned to:		CPU Architecture:	Any

Description:
I have created a model with 5 layers. All of the tables were set to be MyISAM tables. I have relationships drawn between the tables (for demonstration purposes) and I typed the keys all in myself.

In the process of refining my model I moved some tables from one layer to another. When I did this, columns that were attached to the foreign keys were deleted. It took me a while to notice because the lines were still connecting the tables (I'm not sure why that is, aren't they tied to the fks?) 

I had to add back in all of the keys and re-establish the fks.

How to repeat:
Create MyISAM tables on different layers and draw relationships between them. Move one of the tables with foreign keys from one layer to another. I'm also willing to send my document if that would be helpful.

Thank you for the bug report. Yes please provide your document, you
can attach it here using the File tab and compressed into a zip file.
Thanks in advance.

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".

I did add my file. Do I need to do something else?

Thank you for the bug report.
Please see http://bugs.mysql.com/bug.php?id=19433 too,
maybe related.