title: showing error for creating table with foreign key
body: <pre><code>CREATE TABLE location (
    uid int not null auto_increment primary key,
    name varchar(255) NOT NULL,
    `state_uid` int not null,
    FOREIGN KEY location(state_uid)
    REFERENCES state(uid)
    ON UPDATE CASCADE
    ON DELETE RESTRICT,
    `city_uid` int not null,
    FOREIGN KEY location(city_uid)
    REFERENCES city(uid)
    ON UPDATE CASCADE
    ON DELETE RESTRICT,
    `area_uid` int not null,
    FOREIGN KEY location(area_uid)
    REFERENCES area(uid)
    ON UPDATE CASCADE
    ON DELETE RESTRICT
  );
  </code></pre>