title: Why am I receiving an SQL error with this statement?
body: <p>I am attempting to set up some tables within PHPMyAdmin and have used this statement; Why is it creating an error and not being accepted? I cannot see any obvious syntax problems so I'm not sure what the problem could be. The error being generated is labelled #1064.</p>
  
  <pre><code>CREATE TABLE 'users' (
    'id' INT NOT NULL AUTO_INCREMENT,
    'username' VARCHAR(45) NOT NULL,
    'password' VARCHAR(45) NOT NULL,
    'email' VARCHAR(45) NOT NULL,
    'dob' DATE NOT NULL,
    'image_url' VARCHAR(45) NOT NULL,
    'name' CHAR NOT NULL,
    'email_private' TINYINT NOT NULL,
    PRIMARY KEY ('id')
  );
  
  
  CREATE TABLE 'comments' (
    'id' INT NOT NULL AUTO_INCREMENT,
    'comment' VARCHAR(140) NOT NULL,
    'receiver_id' INT NOT NULL,
    PRIMARY KEY ('id'),
    CONSTRAINT 'receiver_id'
      FOREIGN KEY ('receiver_id')
      REFERENCES 'users' ('id')
  );
  </code></pre>