title: Table relationship in phpmyadmin mysql not showing
body: <p>So I am using phpmyadmin to create mysql db. I have made SQL scripts, run it and it is successful but when I go to <code>db &gt; designer</code> in phpmyadmin, it doesnt have relationship (line) between the tables.</p>
  
  <p><img src="https://i.stack.imgur.com/LzzKp.png" alt="enter image description here"></p>
  
  <p>However, indexes on the table shows it looks like it is connected:
  <img src="https://i.stack.imgur.com/aJDCx.png" alt="enter image description here"></p>
  
  <p>Sample scripts I have done: </p>
  
  <pre><code>  CREATE TABLE IF NOT EXISTS location(
          id INT NOT NULL AUTO_INCREMENT,
          tiploc_code VARCHAR(20),
          stanox INT(10),
          crs_code CHAR(3),
          description VARCHAR(30),
          tps_description VARCHAR(30),
          PRIMARY KEY (id)
          );
  </code></pre>
  
  <p>and I use that location ID to be a foreign key in the calling_points table</p>
  
  <pre><code>     CREATE TABLE IF NOT EXISTS calling_points(
      id INT NOT NULL AUTO_INCREMENT,
      schedule INT,
      calling_type INT,
      location INT,
      arrival TIME,
      departure TIME,
      passing TIME,
      platform CHAR(4),
      departure_line CHAR(3),
      arrival_line CHAR(3),
      engineering_alwc TIME,
      pathing_alwc TIME,
      performance_alwc TIME,
      PRIMARY KEY (id),
      FOREIGN KEY (schedule) REFERENCES schedule(id)
        ON DELETE CASCADE
        ON UPDATE CASCADE,
      FOREIGN KEY (calling_type) REFERENCES calling_type(id)
        ON DELETE CASCADE
        ON UPDATE CASCADE,
      FOREIGN KEY (location) REFERENCES location(id)
        ON DELETE CASCADE
        ON UPDATE CASCADE
   );
  </code></pre>
  
  <p>Is this normal?</p>