title: What is my syntax error in this mySQL create table statement?
body: <p>I am typing the following:</p>
  
  <pre><code>CREATE TABLE events (
  `id` mediumint unsigned not null auto_increment,
  `user` varchar(30) not null,
  `time` datetime not null,
  `duration` decimal(5,2) default 1.0,
  `title` tinytext not null,
  `location` text default null,
  `tag` ENUM(‘red’,’orange’,’yellow’,’green’,’blue’,’violet’,’brown’,’black’) default null,
  PRIMARY KEY (`id`),
  FOREIGN KEY (`user`) references users (`username`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  </code></pre>
  
  <p>and I am getting the following response:</p>
  
  <pre><code>ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '‘red’,’orange’,’yellow’,’green’,’blue’,’violet’,’brown' at line 8
  </code></pre>
  
  <p>This may be a case of tired eyes, but I am stumped. What is wrong with my enum statement?</p>