Bug #38801 refactoring: synchronize datatypes in Foreign keys
Submitted: 14 Aug 2008 16:10
Reporter: Johannes Taxacher Email Updates:
Status: Verified Impact on me:
Category:MySQL Workbench Severity:S4 (Feature request)
Version:5.0.24 OS:Any
Assigned to: CPU Architecture:Any
Tags: refactoring

[14 Aug 2008 16:10] Johannes Taxacher
WB doesn't automatically change the columntype of referenced columns if one of the columns, contained in a FK, is changed

How to repeat:
- Create two tables with single column numeric primary keys
- Create a M:N relation
- Change data type of the relation-column, lets say from INT to MEDIUMINT
- Now both tables should have a MEDIUMINT column.

Suggested fix:
add a "synchronize function that accomplishes this task
[5 Sep 2008 14:31] Johannes Taxacher
as a little help until we have a functionality like this built in into workbench this could be helpful: http://dev.mysql.com/workbench/?p=148
[30 Jul 2009 22:48] Alfredo Kojima
bug #32907 marked as duplicate of this one
[30 Jul 2009 22:52] Alfredo Kojima
bug #45615 marked as duplicate of this one
[18 Feb 2011 21:06] Alfredo Kojima
Added bug #60102 as duplicate
[22 Feb 2011 17:21] Michael Garcia
The way I see it, workbench should automatically sync the changes, instead of the user having to call a function to do it.