title: MySQL - Unique foreign key
body: <p>I have to make one of the foreign keys unique. The problem is, I am getting the following message from the phpMyAdmin:</p>
  
  <pre>
  The following indexes appear to be equal and one of them should be removed: consignmentnumber_id_UNIQUE, fk_consignments_consignmentnumbers2
  </pre>
  
  <p>So my question is this: should I be bothered? Is it really important not to have such indexes?</p>