title: MySQL foreign key cannot be created (index problems?)
body: <p>I have a little problem making some foreign keys...<br>
  When I try to define the foreign key in MySQL Workbench, I get the following message:  </p>
  
  <blockquote>
    <p>Selected column 'playerName' must be indexed and be of a compatible type for a Foreign Key to be created.  </p>
  </blockquote>
  
  <p>There my problem starts: I'm pretty sure, that the column (towns.playerName) <strong>is</strong> indexed and it's definitively of the same type ( VARCHAR(255) )...<br>
  <a href="http://www.youscreen.de/hgvoqqjk16.jpg" rel="noreferrer">Indexes of 'towns'</a><br>
  I want to add a Foreign Key from <code>players.name (primary key, not null, unique)</code> to <code>towns.playersName(not null)</code>.<br>
  So what can I do to get the foreign key created?<br>
  It seems i am doing something wrong...</p>
  
  <p>PS: I'm sorry, if there is already a question for this...  </p>
  
  <p>EDIT: I just tried again (exactly as I did before several times) and now it works... really strange<br>
  Perhaps a bug in MySQL Workbench??</p>