title: How to create this table? #1071 - Specified key was too long; max key length is 1000 bytes
body: <pre><code>CREATE TABLE mini
  (
  realurl varchar(200) NOT NULL,
  catagory varchar(200),
  PRIMARY KEY (realurl,catagory),
  FOREIGN KEY (realurl) REFERENCES main(realurl)
  )
  </code></pre>
  
  <p>Error : `#1071 - Specified key was too long; max key length is 1000 bytes</p>
  
  <p>Why I can't create this table? What should I change to create this table?</p>