Bug #52372 DBDesigner 4 Relations comments (FKFieldsComment) import missing
Submitted: 25 Mar 2010 16:44 Modified: 5 Feb 2018 10:10
Reporter: Nitro Ghost Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:any OS:Any
Assigned to: CPU Architecture:Any
Tags: comment, DBDesigner 4, editor, field, foreign key, import, relation

[25 Mar 2010 16:44] Nitro Ghost
Description:
When importing a previously DB model from DBDesigner 4 with a comment on the foreign key on relation editor (double click on relation)
to MySQL Workbench, it ignores the comment.
From the xml DBDesginer model:
...
<RELATION ID="1" ... FKFields="id=idTableField\n" FKFieldsComments="comment\n" ... />
...

How to repeat:
Import a DBDesigner 4 xml model with comments on relation editor (foreign key).

Suggested fix:
on modules/src/wb_mysql_import_dbd4.cpp, function:
int Wb_mysql_import_DBD4::import_DBD4(workbench_physical_ModelRef model, const char *file_name, grt::DictRef options)
{
...
    // relations / fkeys
    //place the following instruction line
     conn_figure->comment(dbd_string_to_utf8(relation_el->Attribute("FKFieldsComment")));

...
    //that is not working so second choice to place the FKFieldsComment was:
    key->comment(dbd_string_to_utf8(relation_el->Attribute("FKFieldsComments")));
}
[5 Feb 2018 10:10] Mike Lischke
Posted by developer:
 
Workbench no longer supports DBDesigner4 import.