title: mysql create table not working
body: <p>I can create any table I want in mysql and it works, except for creating this table:</p>
  
  <pre><code>CREATE TABLE product_shop (
  product_id INT NOT NULL, 
  shop_id INT NOT NULL, 
  PRIMARY KEY (product_id, shop_id), 
  FOREIGN KEY (product_id) REFERENCES product(id) ON UPDATE CASCADE, 
  FOREIGN KEY (shop_id) REFERENCES shop(id) ON UPDATE CASCADE
  )
  </code></pre>
  
  <p>I can create this table and it works:</p>
  
  <pre><code>CREATE TABLE product_category_junction (
  product_id INT NOT NULL, 
  category_id INT NOT NULL, 
  PRIMARY KEY (product_id, category_id), 
  FOREIGN KEY (product_id) REFERENCES Product(id) ON UPDATE CASCADE, 
  FOREIGN KEY (category_id) REFERENCES Category(id) ON UPDATE CASCADE
  )
  </code></pre>
  
  <p>Or any other table. Even if I name the product_shop table to something else it won't create it. </p>
  
  <p>When I try to create it, it says :</p>
  
  <blockquote>
    <p>#1146 - Table 'the_vegan_repository.product_shop' doesn't exist</p>
  </blockquote>
  
  <p>and sometimes:</p>
  
  <blockquote>
    <p>#2006 - MySQL server has gone away</p>
  </blockquote>
  
  <p>The product and shop tables do exist with the id field in each. I am doing it in phpmyadmin. What is going on here??</p>