title: AUTO_INCREMENT in sqlite problem with python
body: <p>I am using sqlite with python 2.5. I get a sqlite error with the syntax below. I looked around and saw AUTOINCREMENT on this page <a href="http://www.sqlite.org/syntaxdiagrams.html#column-constraint" rel="noreferrer">http://www.sqlite.org/syntaxdiagrams.html#column-constraint</a> but that did not work either. Without AUTO_INCREMENT my table can be created.</p>
  
  <pre><code>An error occurred: near "AUTO_INCREMENT": syntax error 
  CREATE TABLE fileInfo
  (
  fileId int NOT NULL AUTO_INCREMENT,
  name varchar(255),
  status int NOT NULL,
  PRIMARY KEY (fileId)
  );
  </code></pre>