title: Android SQLite auto increment
body: <p>I currently have a table called User which has a id column which is created as </p>
  
  <p>'INTEGER PRIMARY KEY'</p>
  
  <p>Lets say I have created two users so the table has id 1 and 2</p>
  
  <p>If I delete the second user and create a third the id is 2, I need this to be 3</p>
  
  <p>So it seems Android is selecting the next available id, how can I change this to its more like  a sequence number?</p>
  
  <p>Regards</p>