title: Wrong sql script generated for sqlite database by ebean in the Play framework
body: <p>I am using the play framework 2.1 and using the evolution to automatically generate sql scripts for me. The database I use is sqlite3.</p>
  
  <p>It seems the evolution can't generate correct script for sqlite3. The incorrect script I got is:</p>
  
  <pre><code>create table algorithm (
  
  id                        bigint AUTOINCREMENT primary key,
  
  name                      varchar(255),
  
  description               varchar(255))
  
  ;
  </code></pre>
  
  <p>I am new to sqlite3. By searching online I realized that:</p>
  
  <ol>
  <li><code>autoincrement</code> can only works with <code>Integer</code></li>
  <li><code>autoincrement</code> should be placed after <code>primary key</code></li>
  </ol>
  
  <p>So obviously the automatically generated script is incorrect. My questions are:</p>
  
  <ol>
  <li>Is there any way to fix the above issue so that I can still use evolution with sqlite3?</li>
  <li>In general do you suggest using evolution or disable it and write sql scripts manually?</li>
  </ol>