title: SQLite auto-increment non-primary key field
body: <p>Is it possible to have a non-primary key to be auto-incremented with every insertion?</p>
  
  <p>For example, I want to have a log, where every log entry has a primary key (for internal use), and a revision number ( a INT value that I want to be auto-incremented).</p>
  
  <p>As a workaround, this could be done with a sequence, yet I believe that sequences are not supported in SQLite. </p>