title: How to use SQLite with Slick
body: <p>I've changed the conf to below:</p>
  
  <pre><code>db.default.driver=org.sqlite.JDBC 
  db.default.url="jdbc:sqlite:db/db.db"
  </code></pre>
  
  <p>and add:</p>
  
  <pre><code>"org.xerial" % "sqlite-jdbc" % "3.7.15-M1"
  </code></pre>
  
  <p>but the generated sql is wrong:</p>
  
  <pre><code>create table "user" ("uid" BIGINT PRIMARY KEY AUTOINCREMENT NOT NULL,"name" VARCHAR(254) NOT NULL,"pw" VARCHAR(254) NOT NULL,"email" VARCHAR(254) NOT NULL,"comment" VARCHAR(254),"updateAt" TIMESTAMP NOT NULL,"createAt" TIMESTAMP NOT NULL);
  </code></pre>
  
  <p>because <code>bigint</code> can not be auto-incremented.</p>
  
  <p>I don't want to fix it by hand.
  how to fix it.
  the errors:</p>
  
  <pre><code>We got the following error: [SQLITE_ERROR] SQL error or missing database (AUTOINCREMENT is only allowed on an INTEGER PRIMARY KEY) [ERROR:1, SQLSTATE:null]
  </code></pre>
  
  <p><a href="https://groups.google.com/forum/#!topic/scalaquery/07JBbnZ5VZk" rel="nofollow">https://groups.google.com/forum/#!topic/scalaquery/07JBbnZ5VZk</a></p>