title: MySQL Workbench - adding relations without having to edit the tables
body: <p>I am editing a schema in MySQL workbench. I imported the schema from a mysqldump. Since it doesn't include any foreign keys, I am adding the relationships manually. </p>
  
  <p>Here is my problem: When adding a relationship, workbench adds a column with the foreign key to one of the tables. However, the column is already present. I have to remove the current column and change the name of the new column to the name of the original column. </p>
  
  <p>I illustrated it in the attached pictures:</p>
  
  <ol>
  <li>The two original tables </li>
  <li>The two tables after adding the relationship</li>
  <li>After removing original column and renaming new column - this is what I want in one step</li>
  </ol>
  
  <p><img src="https://i.stack.imgur.com/J7bui.png" alt="The two original tables">
  <img src="https://i.stack.imgur.com/UFUrK.png" alt="The two tables after adding the relationship">
  <img src="https://i.stack.imgur.com/e99eD.png" alt="After removing original column and renaming new column - this is what I want in one step"></p>
  
  <p>Is there a way to avoid this, and choose the target-column when adding the relationship, so that I don't have to edit a larger number of tables? </p>
  
  <p>(Edited to add: The example tables are not the tables I want to connect, in case somebody recognizes the Drupal 8 tables - they were just short enough to aid as an example). </p>