title: Inserting Id field autoincrement with sqlite3 and node.js
body: <p>I am trying to insert into sqlite3 with node.js. I need a unique id field however I would like it to auto generate so I do not have to insert it when inserting to the table.
  I am getting connected and creating the table ok however then when I am inserting it is expecting me to supply an id field. 
  Here is the code so far:</p>
  
  <pre><code>var sqlite3 = require('sqlite3').verbose();
  var db = new sqlite3.Database('database/setup.db');
  
  
  db.serialize(function() {
  db.run("CREATE TABLE items (id INTEGER PRIMARY KEY, title TEXT, images TEXT, bid INTEGER, currentBidder TEXT)");
  
  var stmt = db.prepare("INSERT INTO items VALUES(?,?,?,?)");
  stmt.run('Title test 123', 'http://testshjshs', 100, 'shane'); 
  stmt.finalize();
  
  db.each("SELECT rowid, title FROM test", function(err, row) {
    console.log(row.rowid + ": " + row.title);
  });
  
  });
  
  db.close();
  </code></pre>
  
  <p>This is returning the following error.</p>
  
  <pre><code>Error: SQLITE_ERROR: table items has 5 columns but 4 values were supplied
  </code></pre>
  
  <p>I understand why it is returning the following error but how do I set it so it inserts auto inserts the field or is this not possible?
  Thanks</p>