title: sql Error 1064 (42000) Syntax Error
body: <pre><code>CREATE TABLE IF NOT EXISTS message(
    id INT NOT NULL auto_increment,
    userid INT NOT NULL,
    date Date NOT NULL,
    text varchar(255) NOT NULL,
    PRIMARY KEY  ('id')
    FOREIGN KEY ('userid') REFERENCES users('id'));
  </code></pre>
  
  <p>I was just wondering if someone could help me in identifying a syntax error as I can not create a table.</p>