title: SQL CREATE TABLE Error
body: <p>The Answer was that I was using incorrect quotation marks instead of backticks. Stupid syntax hilighter tricked me.</p>
  
  <p>I've been stuck on this one simple(ish) thing for the last 1/2 hour so I thought I might try to get a quick answer here.</p>
  
  <p>What exactly is incorrect about my SQL syntax, assuming I'm using mysql 5.1</p>
  
  <pre><code>CREATE TABLE 'users' (
      'id' INT(11) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
      'username' VARCHAR(20) NOT NULL,
      'password' VARCHAR(40) NOT NULL,
      'salt' VARCHAR(40) DEFAULT NULL,
      'email' VARCHAR(80) NOT NULL,
      'created_on' INT(11) UNSIGNED NOT NULL,
      'last_login' INT(11) UNSIGNED DEFAULT NULL,
      'active' TINYINT(1) UNSIGNED DEFAULT NULL,
  ) 
  ENGINE InnoDB;
  </code></pre>
  
  <p>The error I get is:</p>
  
  <pre><code>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 ''users';
  
  CREATE TABLE 'users' (
      'id' INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,' at line 3
  
  
  Elapsed Time:  0 hr, 0 min, 0 sec, 0 ms.
  </code></pre>
  
  <p>Also, does anyone have any good tutorials about how to use Zend_Auth for complete noobs?</p>
  
  <p>Thanks.</p>