title: Sql query will give weird 'unrecognized data type (near key) error in mysql
body: <p>I haven't worked with php and mysql for a long time and my return isn't so well-received by the platform.
  I created tables using <code>phpmyadmin</code> and then I used the code below the generate scripts for my tables:</p>
  
  <pre><code>show create table recipes
  </code></pre>
  
  <p>I dropped the tables and then started to use the generated scripts to recreate my tables, only to see that they are giving me syntax errors. This is the generated script.</p>
  
  <pre><code>CREATE TABLE recipes (
    id int NOT NULL AUTO_INCREMENT,
    name varchar(50) NOT NULL,
    serving varchar(50) NOT NULL,
    description text NOT NULL,
    image_url varchar(100) NOT NULL,
    calories float DEFAULT NULL,
    tag varchar(100) NOT NULL,
    meal int NOT NULL,
    user_id int NOT NULL,
    PRIMARY KEY (id),
    KEY user_id (user_id),
    FULLTEXT KEY name_full_text (name),
    FULLTEXT KEY tag_full_text (tag),
    CONSTRAINT recipes_ibfk_1 FOREIGN KEY (user_id) REFERENCES users (id) ON UPDATE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 
  </code></pre>
  
  <p>What I want from my table is that it use <code>id</code> as the primary key, <code>user_id</code> as the foreign key to the <code>users</code> table (which is already created), and I need two <code>FULLTEXT</code> indexes on two of the columns.</p>
  
  <p>The strange thing is that I am getting syntax errors in lines 11, 12, and 13. With the main one being <code>unrecognized data type. (near key)</code>. I am also getting <code>a comma or a closing bracket was expected (near name_full_text). Then again,</code>phpmyadmin` generated this query itself and I don't know why it is not accepting it.</p>
  
  <p>Any Suggestions?</p>