title: Foreign Key Constraint won't create on MySQL table
body: <p>Ok here are my two tables that are having conflicts:</p>
  
  <pre><code>CREATE TABLE visit_physician (
     visit_id INT(11) UNSIGNED NOT NULL,
     physician_id INT(11) UNSIGNED NOT NULL,
     physician_role INT(11) UNSIGNED NOT NULL,
     PRIMARY KEY(visit_id, physician_id)
  );
  
  CREATE TABLE physician_role (
     id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT KEY,
     name VARCHAR(50) NOT NULL,
     UNIQUE(name)
  );
  
  ALTER TABLE visit_physician
  ADD CONSTRAINT FK_roleid
  FOREIGN KEY (physician_role) REFERENCES physician_role(id)
  ON UPDATE CASCADE
  ON DELETE CASCADE;
  </code></pre>
  
  <p>physician_role and the id are the same datatypes and size and everything.. so why is not creating? My other foreign keys assigned without a problem..</p>