title: SQLite syntax not compatible with MySQL?
body: <p>I'm using PDO and trying to make my application support both MySQL and SQLite, but in sqlite I get this error when I try to import my database schema:</p>
  
  <p><code>SQLSTATE[HY000]: General error: 1 near "AUTO_INCREMENT": syntax error</code></p>
  
  <p>The query looks like this:</p>
  
  <pre><code>CREATE TABLE events (
  
    id INT UNSIGNED NOT NULL AUTO_INCREMENT,
    name VARCHAR(32) NOT NULL,
    title VARCHAR(64) NOT NULL,
    description LONGTEXT,
    starttime DATETIME DEFAULT '0000-00-00 00:00:00',
  
    PRIMARY KEY(id),
    KEY name(name)
  
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  </code></pre>
  
  <p>(and it works in a MySQL database.)</p>
  
  <p>I don't understand what the problem is here? Shouldn't both database systems be compatible?</p>