title: What is wrong with my SQL here? #1089 - Incorrect prefix key
body: <pre><code>CREATE TABLE `table`.`users` (
      `id` INT(11) NOT NULL AUTO_INCREMENT,
      `username` VARCHAR(50) NOT NULL,
      `password` VARCHAR(50) NOT NULL,
      `dir` VARCHAR(100) NOT NULL,
      PRIMARY KEY (`id`(11))
  ) ENGINE = MyISAM;
  </code></pre>
  
  <p>I'm getting the <code>#1089 - Incorrect prefix key</code> error and can't figure out what I'm doing wrong. Help, please!</p>